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

128 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
calomels123613(None) 
calomel1138071calomel_
caloyers1337342caloyers
calumets1236282calumets
camels105217082ca__mels
caramels1238802caramels
colonels104210462colonels
columels1244812columels
almehs11619493_al_mehs
almes75126543_al_me_s
aloes54933673_alo_e_s
aludels835303_aludels
baloneys1334663baloneys
cabombas1643813cabombas
cacodyls1642713cacodyls
cacomixls2241693cacomixls
caeomas1138403caeom_as
cajolers17267133cajolers
cajoles163712103cajole_s
cajones163311333cajone_s
calamars1238133calamars
calamus1139243calam_us
calces104420053cal_ce_s
calibers1238523calibers
calices114321693calice_s
calicles123811433calicles
calipees1247413calipees
calipers1249443calipers
calkers134414693cal_kers
callees94117783cal_lees
callers94221963cal_lers
callets93821703cal_lets
calloses10313393callose_s
calls75634733cal___ls
calmed114816383cal_me_d
calmer105216933cal_me_r
calmest11312343cal_mest
calmly1337613cal_m_ly
calmness1236643calmness
calms95222353cal_m__s
calorics122810463calorics
calories102919563calories
calos74431903calo___s
calottes10610083calottes
caloyer1238143caloye_r
calques182710193calque_s
calumet11313293calume_t
calves115119283cal_ve_s
calxes154113033cal_xe_s
calyces14428803calyce_s
calycles15295693calycles
calyxes19426233calyxe_s
calzones1948763calzone_s
camel96822803ca__mel_
cameos105818003ca__meos
cames97047313ca__me_s
camomile14156323camomile
camomiles15155633camomiles
cancels114113313ca_ncels
cannels93413363ca_nnels
canoers94318373cano_ers
canoes84725883cano_e_s
canoness1039393canoness
caporals1238923caporals
capotes11314643capote_s
capsomers1544753capsomers
caramel11310253caramel_
caravels1337443caravels
carcels114516063ca_rcels
carolers103314173carolers
carols85124983caro__ls
caromed123713623carome_d
caroms105619573carom__s
carousels1165343carousels
carpels115315463ca_rpels
carrels95117303ca_rrels
cartels94618123ca_rtels
carvels124914593ca_rvels
celoms10412123celom__s
chalones13312173chalone_s
chlorals13148033chlorals
chromes142914933chrome_s
chromyls18244733chromyls
claimers12298743claimers
clammers143510693clammers
cleomes1138813cleome_s
climes104720003c_lime_s
clomps125212233c_lom_ps
cloners94514823c_loners
clones84526563c_lone_s
closely1237053c_losely
closers94415323c_losers
closes85425593c_lose_s
closets94611603c_losets
clovers125114663c_lovers
cloves114918823c_love_s
clozes174915563c_loze_s
coelomes1239293coelome_s
colonel94213283colonel_
colones96124433colone_s
coloreds1138093coloreds
colorers10312183colorers
columel1136273columel_
comely134213733c__omely
comers105328083c__omers
comes97246993c__ome_s
comets105823583c__omets
compels133210893c__ompels
cormels113813373c_ormels
coronels104012153coronels
damosels11195243damosels
damozels20133173damozels
falafels1453113falafels
galores82614343galore_s
hallels103310133hal_lels
haloes94623863halo_e_s
halogens1237363halogens
losels64714593__losels
oenomels1044583oenomels
oinomels1044513oinomels
palmers113513623pal_mers
philomels1643503philomels
radomes10311053radome_s
salols64017873salo__ls
scalpels12345883scal_pels
slalomers1144553slalomers
telomes9310533telome_s
wadmels1334303wa_dmels

Search took 9 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.423422437.4
2DLD Change Limit1461621287.79618748.3
3Display Results1281280.0602133.3
 (SQL Overall)1786911288.27921583.6
 
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.