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 “comfrey” 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.

121 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
comfrey173468(None) 
comfreys1843331comfreys
coffret15310072coffret
comfier1439162comfier
comfy153710212comf__y
pomfret1446992pomfret
cockney1835873cockney
coffee144113743co_ffee
coffees15329573coffees
coffer144112863co_ffer
coffered1737673coffered
coffers154112693coffers
coffle14359043coffle_
coffled16297363coffled
coffles152610003coffles
coffrets1645363coffrets
cohere112716993cohere_
cohered133514693cohered
coherer122912783coherer
coheres122917693coheres
coifed124113063coif_ed
coiffe1447043coiffe_
coiffed1635413coiffed
coiffes1546803coiffes
colored10313473colored
colorer9312523colorer
colure8314163colure_
colures9315143colures
comade114415323comade_
comae97128423com_ae_
comake144413423comake_
comaker153410603comaker
comakes154413643comakes
comate104124843comate_
comates114123643comates
combe116223543com_be_
combed135516543com_bed
comber125118503com_ber
combers134516623combers
combes125321733com_bes
come87547703com__e_
comedy14378233com_edy
comely134213733com_ely
comer95832693com__er
comers105328083comer_s
comes97246993com__es
comet95946073com__et
comfiest1539133comfiest
comfit133112423comf_it
comfits14328743comfits
comfort143611693comfort
comforted17315963comforted
comforter16255983comforter
comforts15347323comforts
comity13312713com_ity
commie124215523commie_
commies133718453commies
commy144712643com__my
comose105016853comose_
company1619711143company
compare135814993compare_
compared153811823compared
comparer143611363comparer
compares143816433compares
comped135919873com_ped
compeer133811553compeer
compel124412893com_pel
compere134616623compere
compered153414923compered
comperes143217973comperes
complex2037243complex
comply152810383com_ply
compony1613011913compony
compress1439053compress
compted143813523compted
comte96125473com_te_
comtes106222813com_tes
coney105932883co__ney
confer114018683conf_er
conferee13613733conferee
confers124120093confers
confrere1347563confrere
convey144610223co_nvey
cooey105828223co__oey
cookery164210393cookery
cookey155414333co_okey
coopery143910273coopery
coppery16409393coppery
corby125018533co__rby
core67263113co__re_
cored85044223co__red
corer75538873co__rer
cores76361853co__res
corky145221153co__rky
corny106023273co__rny
cory96941513co__r_y
cosey106226713co__sey
costrel9310373costrel
covary1438743covar_y
covered133315293covered
coverer123113523coverer
covey136121783co__vey
cowered133214653cowered
cowry135512483co_wr_y
cozey196718543co__zey
gomerel1036393gomerel
hombre13309303hombre_
hombres14369883hombres
homered133212713homered
homey135924843hom__ey
kouprey1652793kouprey
lamprey1434863lamprey
offkey1932343_offkey
ombre94111803_ombre_
ombres103911143_ombres
orfray1234393_orfray
osprey1134883_osprey
palfrey1533343palfrey
pomfrets1543033pomfrets
sombre10729473sombre_
sombrely1543703sombrely

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271217.09318895.7
3Display Results1211210.0502420.0
 (SQL Overall)1786911217.53323721.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.