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

171 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
kummels1523479(None) 
kummel14266171kummel_
pummels13236541pummels
bummers133712442bummers
cummers133713482cummers
gummers123712202gummers
hummers143813062hummers
kugels1146072ku_gels
mummers103712842mummers
pommels13235792pommels
pummel12278042pummel_
pummelo13284232pummelo
pummelos14223102pummelos
rummers113513652rummers
summers113616502summers
umbels104510592_umbels
bulbels11398013bulbels
bumbles134016843bumbles
bummalo1353793bummalo
bummalos1442873bummalos
bummed134211723bumme_d
bummer124014103bumme_r
bummest13298623bummest
bumpers133912053bumpers
bushels124110713bushels
camels105217083_camels
compels133210893compels
cormels113813373cormels
cudgels1135333cudgels
cumbers134515413cumbers
cummer124414593cumme_r
cummins1358963cummins
cupels10310203cu_pels
dammers123214273dammers
damsels10126713damsels
dimmers123811563dimmers
drummers13316163drummers
duels65619233du__els
duffels14296453duffels
dummies123012133dummies
dumpers123412663dumpers
emmers104013223_emmers
emmets10349153_emmets
enamels9128163enamels
femmes135410213femme_s
fuels87117353fu__els
fumbles143514413fumbles
fumers113613383fu_mers
fumes105224703fu_me_s
fumets114311813fu_mets
funnels10348173funnels
fusels94412453fu_sels
gammers123214563gammers
gimels938893_gimels
gimmals12225823gimmals
gimmes113010903gimme_s
grummets13275033grummets
gumless10228273gumless
gummas114810513gumm_as
gummed123811663gumme_d
gummer114615453gumme_r
gummous1236263gummous
gunnels8358563gunnels
gunsels8338133gunsels
hammals14409233hammals
hammers144216063hammers
hemmers143310843hemmers
humbles143215803humbles
hummed144812673humme_d
hummer133615273humme_r
hummus1336243humm_us
humpers142713523humpers
humvees1534683humvees
impels10389523_impels
jammers183710703jammers
jumbals18106533jumbals
jumbles183013323jumbles
jumpers18399843jumpers
jurels133710583ju_rels
kames115024693k_ame_s
keels94622413k__eels
kennels11387193kennels
kermes124616133kerme_s
kermess13396223kermess
kernels11417953kernels
kevels134410713k_evels
kirmess13234313kirmess
kismets13306883kismets
knawels14344683knawels
kneels10408933k_neels
koels94613903k__oels
krimmers16315673krimmers
kuchens1634713kuchens
kues86426773ku__e_s
kugel1068573ku_gel_
kumiss1235923ku_miss
kumys1435933ku_m_ys
kumyses1633143kumyses
limmers113413083limmers
lumbers113815913lumbers
lumens85013973lu_mens
lumpens11298263lumpens
lumpers113514483lumpers
mammals10389273mammals
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mels65941533___mels
mumbles133014433mumbles
mummed104411553mumme_d
mummer93614543mumme_r
mummery13336663mummery
mummies103812843mummies
mumms85513153mumm__s
mumpers133311373mumpers
mussels9419843mussels
mutuels935943mutuels
numbers113711243numbers
numbles113814273numbles
nutmegs10132903nutmegs
ousels64815283ou_sels
ouzels15408703ou_zels
plummets14304773plummets
pommel12277453pommel_
pumelo10257113pu_melo
pumelos11196093pu_melos
pummeled1543373pummeled
pumpers133113673pumpers
rammers113715043rammers
rimmers113812883rimmers
rubels84112993ru_bels
rumbles114018393rumbles
rumens83611813ru_mens
rummer104715483rumme_r
rummest11279833rummest
rummies113212793rummies
rumples113313133rumples
runnels7329153runnels
samiels939763samiels
scummers14277783scummers
simmers113314613simmers
simnels976103simnels
skimmers16296463skimmers
slummers12358933slummers
stammels12495563stammels
sumless92611123sumless
summas104313163summ_as
summed114014043summe_d
summer104017713summe_r
summerly15275103summerly
summery14329413summery
summits1137983summits
summons1158003summons
tramels93812493tramels
trammels12295413trammels
trommels12254333trommels
tumbles113816023tumbles
tumbrels12285733tumbrels
tummies113012033tummies
tummler11266613tummler
tummlers12295703tummlers
tunnels7328723tunnels
umbel93612843_umbel_
umbers104215213_umbers
umbles103817493_umbles
unmews11326523_unmews
wadmels1334303wadmels
wurzels1934083wurzels
yammers143410323yammers
yummies14359533yummies

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 Limit1340271716.64320175.7
3Display Results1711710.0602850.0
 (SQL Overall)1786911717.09325192.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.