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 “columels” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
columels124481(None) 
columel1136271columel_
calomels1236132calomels
calumets1236282calumets
colonels104210452colonels
columella1352662columella
columneas1343012columneas
columns1136472colum_ns
colures9315142colure_s
cormels113813372co_rmels
volumes12298232volume_s
aludels835293_aludels
blumes105917793_blume_s
boluses94113833boluse_s
calomel1138073calomel_
calumet11313293calume_t
camels105217083c__amels
caramels1238803caramels
cerumens1235763cerumens
climes104720003c_lime_s
clouters10399803clouters
clues74623033c_lu_e_s
clumbers143910413c_lumbers
clumps1215314643c_lum_ps
coelomes1239293coelome_s
cohunes1249713cohune_s
coldness1137953coldness
coles76055063col__e_s
coleus86818273col__eus
coleuses1039723coleuse_s
colies84837053col_ie_s
colleens1036843colleens
collets93517903col_lets
colliers103613583colliers
collies94326583collie_s
colluders12285613colluders
colludes11279223collude_s
colonel94213283colonel_
colones96124433colone_s
coloreds1138093coloreds
colorers10312183colorers
colourers1136473colourers
colters93522443col_ters
colugos1035693colu_gos
columbic1643443columbic
columellae1452083columellae
columellar1451913columellar
column1038103colum__n
columnal1244413columnal
columnar1243713columnar
columnea1243673columnea
columned1334923columned
columnist1346473columnist
colure8314163colure__
comely134213733co__mely
comers105328083co__mers
comes97246993co__me_s
comets105823583co__mets
compels133210883co_mpels
consumers1337203consumers
consumes12310413consume_s
contumely1644243contumely
coquets18399893coqu_ets
corbels113813593co_rbels
cormel103815603co_rmel_
cornels94716663co_rnels
cornmeals1344573cornmeals
coronels104012143coronels
corulers1039773corulers
costrels1038933costrels
costumers1374853costumers
costumes1258013costume_s
coulees9315513co_ulees
coulters103614313coulters
counsels1037573counsels
coupes105022523co_upe_s
couples115317053co_uples
couters93827303co_uters
cupels10310203c__upels
dolmens10388693dol_mens
flumes115119733_flume_s
glumes94516813_glume_s
housels105312133ho_usels
illumes9327673illume_s
lumens85013973__lumens
ousels64815273_o_usels
ouzels15408703_o_uzels
plumes104318133_plume_s
polymers1538333polymers
pommels13235783po_mmels
relumes9612513relume_s
solubles1065893solubles
solums85211333solum__s
solutes73515263solute_s
toluoles835513toluoles
toluols735823tolu_ols
toluyls1032833tolu_yls
volume11358273volume__
volumed13285683volume_d
volutes102710983volute_s

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621007.37619815.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.84222786.4
 
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.