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

143 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
calumets123628(None) 
calumet11313291calumet_
callets93821702cal_lets
calmest11312342cal_mest
calomels1236132calomels
columels1244812columels
maumets11369692ma_umets
acumens1136953_acumens
albumens1244143_albumens
aliments10311093_aliments
almehs11619493_al_mehs
almes75126543_al_me_s
aludels835293_aludels
alumins9512983_alumins
alumnus935223_alumnus
alums75720603_alum__s
amulets939923_amulets
armets84918353_a_rmets
baguets1037483bagu_ets
ballets93719513bal_lets
bluets87215493_blu_ets
blumes105917793_blume_s
cabarets12268463cabarets
cabinets1238283cabinets
cablets114216343ca_blets
cachets145014263ca_chets
cadets96316503ca__dets
caduceus1342553caduceus
cajuputs1941783cajuputs
calamars1238133calamars
calamata1247553calamata
calamatas1345783calamatas
calamints1348043calamints
calamite12312533calamite
calamites13410703calamites
calamity1547753calamity
calamus1139243calam_us
calces104420053cal_ce_s
calcites12313003calcites
calibers1238523calibers
calices114321693calice_s
calipees1247413calipees
calipers1249443calipers
calkers134414693cal_kers
callants104112143callants
callees94117773cal_lees
callers94221963cal_lers
callet84536763cal_let_
calluses1039323calluse_s
calmed114816383cal_me_d
calmer105216933cal_me_r
calmness1236643calmness
calms95222353cal_m__s
calomel1138073calome_l
calottes10610083calottes
caloyers1337343caloyers
calques182710193calque_s
calumnies1346043calumnies
calumny1443863calum_ny
calves115119283cal_ve_s
calxes154113033cal_xe_s
calyces14428803calyce_s
calyxes19426233calyxe_s
camels105217083ca__mels
cameos105818003ca__meos
cames97047313ca__me_s
camlets114314623ca_mlets
capelets1268603capelets
caplets114914523ca_plets
caramels1238803caramels
carburets1345203carburets
carets85330773ca__rets
carnets93918403ca_rnets
carpets113915333ca_rpets
casements1348583casements
caskets133910173ca_skets
casuists1036523casuists
caules85927253ca_ule_s
caulkers14375643caulkers
causers94014783ca_users
causes88026473ca_use_s
causeys12387223ca_useys
cayuses12188403cayuse_s
cermets1139713c_ermets
cerumens1235763cerumens
chalets122813473chal__ets
chalumeau1652083chalumeau
chalumeaus1751333chalumeaus
claimers12298743claimers
clammers143510683clammers
clarets94111103c_larets
claughts1443383claughts
clauses93813323clause_s
climes104720003c_lime_s
closets94611603c_losets
clues74623033c_lu_e_s
clumbers143910393c_lumbers
clumps1215314643c_lum_ps
collets93517903col_lets
columel1136273colume_l
columneas1343003columneas
columns1136473colum_ns
colures9315133colure_s
comets105823583c__omets
coquets18399893coqu_ets
cruets85314953c_ru_ets
crumpets14335943c_rumpets
crusets93811043c_rusets
culets85518513c__ulets
cullets94015613cul_lets
curets84922343c__urets
faucets12578443fa_ucets
flumes115119733_flume_s
fumets114311813__fumets
gallets83517403gal_lets
galumphs1642023galumphs
glumes94516813_glume_s
helmets12309073hel_mets
illumes9327673illume_s
lumens85013973__lumens
lunets66914763__lunets
mallets93318493mal_lets
mammets103911113ma_mmets
manumits1246003manumits
maumet103518883ma_umet_
palets85122313pal__ets
pallets93919303pal_lets
palmers113513623pal_mers
pelmets11309693pel_mets
plumes104318133_plume_s
plummets14304773_plummets
ramets83517393ra__mets
relumes9612513relume_s
sallets73719653sal_lets
saluters8319853saluters
salutes73716253salute_s
taluses7311213taluse_s
valets93715623val__ets
valuates112811193valuates
valuers10328943valu_ers
values94314943valu_e_s
volumes12298233volume_s
wallets103914833wal_lets

Search took 7 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.186960704.3
2DLD Change Limit1461621436.67321903.5
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.90525878.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.