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

140 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
coelome113968(None) 
coelom10310421coelom_
coelomes1239291coelomes
coeloms1139061coeloms
celom9515682c_elom_
celoms10412122c_eloms
cleome1039082cle_ome
coelomate1398102coelomate
coelomic1445712coelomic
colone85425002co_lone
coulomb1344552coulomb
telome8311922_telome
woesome1246732woesome
acoelomate1454343acoelomate
acoelous1047023acoelous
awesome1245573awesome
become123312593_become
boresome1248403boresome
caeoma1039033cae_oma
callose9313663callose
calomel1138073c_alomel
cellae84915933c_ellae
celotex1635023c_elotex
cenote83715843c_enote
chalone12312103chalone
chegoe1237273chego_e
chelae113614603chel_ae
chelate122914893chelate
cheloid13310833cheloid
chrome133214813c_hrome
cleomes1138813cle_omes
clime95720893c__lime
clomb115714703c__lomb
clomp115615703c__lomp
clone75728163c__lone
close76425223c__lose
clove105619443c__love
cloze165517543c__loze
coalhole1345093coalhole
coble94823173cobl__e
codrove1336423codrove
coeliac1138233coeliac
coelomata1385323coelomata
coelomates1497563coelomates
coenure968153coenure
coenzyme2442993coenzyme
coerce10310403coe_rce
coesite9713623coesite
coevolve1642963coevolve
cognomen1346083cognomen
cokelike1336813cokelike
cole66956113co_l__e
collage102813753collage
collate92919683collate
college102410433college
collide103214783collide
collie83621993co_llie
collogue1145463collogue
colloid10312883colloid
collop107312313collo_p
collops112611753collops
collude10337983collude
colobi105011083co_lobi
colog86619933co_lo_g
cologne1039353co_logne
cologs96517353co_logs
colon78630193co_lo_n
colonel94213283co_lonel
colones96124433co_lones
coloni85619203co_loni
colons86028683co_lons
colony115417273co_lony
color76123743co_lo_r
colored10313473co_lored
colorer9312523co_lorer
colormen1247243co_lormen
colors86622373co_lors
colour85915093co_lour
columel1136273co_lumel
column1038103co_lumn
colure8314163co_lure
come87547703c___ome
commode1438123commode
commove1635963commove
comose105016843co_mose
compone136517193compone
compose135716663compose
compote135616463compote
condole102914953condole
condom114215363condom_
condoms124214083condoms
condone102616293condone
conenose1078593conenose
conglobe1344153conglobe
connote9311613connote
console92715983console
consomme1445373consomme
consume11510133consume
convoke16207173convoke
cooee74531023co__oee
coolie83821603cool_ie
coomb115615703co__omb
coombe124110093co__ombe
coplot10518273coplo_t
coplots11511593coplots
corelate10516013corelate
corrode101310573corrode
costume1157853costume
coulee8323503coul_ee
couloir936153couloir
coulombs1443093coulombs
cowpoke1835103cowpoke
cowrote12289673cowrote
coxcomb2243293coxcomb
coyote11411783co_yote
creme94319323cre__me
creole8913723cre_ole
cyclone1437243cyclone
delime9314043_delime
dolesome1147103dolesome
elope75219343__elope
eyesome1246163eyesome
genome94312193_genome
hoelike141411163hoelike
lonesome1047473lonesome
lovesome1345643lovesome
myeloma1444043myeloma
noisome947973noisome
nonhome1248833nonhome
oceloid1037973oceloid
ocelot8813383ocelo_t
ocelots977233ocelots
oenomel946563_oenomel
relume8313273_relume
telomes9310533_telomes
toelike11149823toelike
toilsome1045203toilsome
veloce11310133_veloce
volume11358273vo_lume
welcome1445193_welcome

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.1561145455.1
2DLD Change Limit1340271407.61017612.0
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.81222873.9
 
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.