Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “creviced” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
creviced163445(None) 
crevice1436151crevice_
crevices1536711crevices
cervices1537132cervices
chevied16357482chevi_ed
credited1238252credited
prevised143611072prevised
reviled114417922_reviled
revised113815482_revised
revived144211652_revived
revoiced14317872_revoiced
serviced1435612serviced
breveted1435623breveted
brevier1237763brevi_er
caviled1348723c_aviled
ceiled94114953c_e_iled
cervical1546853cervical
cervid1239323cervi__d
cervine122610803cervine_
cervixes2054603cervixes
ceviche1744143c_eviche
ceviches1834843c_eviches
chaliced1637043chaliced
cheliped1635043cheliped
chevies153511443chevi_es
chivied16368383chivi_ed
clevises1336903clevises
coedited1237833coedited
coerced1238583coe_rced
convicted1746313convicted
convinced1745363convinced
coppiced1734823coppiced
corniced1368593corniced
craved125417773crav__ed
cravened1476713cravened
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
created104323453cre_ated
creed85727393cre___ed
creeled104012013cre_eled
creeped12329713cre_eped
creeshed1435693creeshed
cremated133412963cremated
crenated113013913crenated
creneled11326893creneled
creolised1255203creolised
creolized2145643creolized
creped114115703cre__ped
crepier1139733crepi_er
crested103416533cre_sted
cretic102816283cretic__
cretics112911653cretic_s
crevassed1543193crevassed
crewed125316553cre__wed
cricked164814283cr__icked
cried84624283cr__i_ed
cruised103710213cr_uised
deiced104214483_de_iced
device124512163_device_
devices133212583_devices
deviled124112183_deviled
devised123712563_devised
devoiced15276063_devoiced
evicted1337243__evicted
evinced1335403__evinced
evited104013143__evited
grecized2134433grecized
levied104111433_levi_ed
precised133213413precised
precited133013813precited
predicted1538913predicted
prefaced1638423prefaced
prefiled143310573prefiled
prefired144310753prefired
prefixed21357693prefixed
premised133013193premised
premixed20338003premixed
prenticed14118063prenticed
prepriced1676633prepriced
presided12410553presided
presliced1435973presliced
prevailed1536043prevailed
preview1536473previ_ew
previewed1843413previewed
previse123713793previse_
previses133814283previses
prevued1337143prev_ued
prewired14358473prewired
priced115018883pr__iced
provided1536843provided
ravined115411823_ravined
recited104319103_recited
reduced11610323_reduced
refaced133713573_refaced
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refixed183611153_refixed
rehired115013153_rehired
reined74425523_re_ined
reived104518133_re_ived
rejoiced18296923_rejoiced
relaced103517213_relaced
relied74926233_reli_ed
relined85321933_relined
relived115114683_relived
remised103516843_remised
remixed173510743_remixed
reoiled84316853_reoiled
repined104918773_repined
repriced132610543_repriced
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resited85122423_resited
resized174614903_resized
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
reveled113917753_reveled
revered112819333_revered
review1238693_revi_ew
reviewed1534823_reviewed
revile94921613_revile_
reviler104314973_reviler
reviles104421353_reviles
revise94019743_revise_
reviser104114663_reviser
revises104220533_revises
revive124914823_revive_
reviver134411373_reviver
revives134715543_revives
revoice12319183_revoice_
revoices13278993_revoices
revoked154410523_revoked
revoted114314153_revoted
revved13469723_rev_ved
rewired115413283_rewired
riced85825543_r__iced
service1239083service_
servicer1335263servicer
services1338573services
triced95518673tr__iced
unrevised1345163unrevised
viced115118183___viced
weeviled1533143weeviled

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461621489.20315882.0
3Display Results1481480.0632349.2
 (SQL Overall)1786911489.42218965.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.