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

252 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
dummied1334672(None) 
dummies123012131dummies
mummied11327101mummied
bummed134211722bumm_ed
dammed124214792damm_ed
dimmed124110322dimm_ed
drummed13306322drumm_ed
dumbed124012082du_mbed
dumped123814492du_mped
dumpier12409652dumpier
gummed123811662gumm_ed
gummier12349472gummier
hummed144812672humm_ed
jemmied19294482jemmied
jimmied19275032jimmied
mummed104411552mumm_ed
mummies103812842mummies
rummier11309562rummier
rummies113212792rummies
summed114014042summ_ed
summited13246412summited
tummies113012032tummies
yummier14306842yummier
yummies14359532yummies
bammed133913243bamm_ed
buddied12388003buddied
bullied104514813bullied
bumbled144113043bumbled
bummer124014103bumm_er
bumming143410783bumming
bumped134414003bu_mped
bumpier13359203bumpier
buried94822373bu_ried
busied95117223bu_sied
cammie124615293cammie_
cammies134016483cammies
chammied18215973chammied
chummed17396443chumm_ed
chummier1734513chummier
commie124215523commie_
commies133718453commies
commixed2264743commixed
crummie1336153crummie_
crummier1435603crummier
crummies1437643crummies
cullied104012353cullied
culmed114610593culm_ed
cummer124414593cumm_er
cummin1288783cummi_n
cummins1358963cummins
curried103313653curried
daisied93410013daisied
dallied93713613dallied
damaged1257463damaged
dammer114317933damm_er
damming133812743damming
dammit11311133dammi_t
damned104212913d_amned
damped124315583d_amped
decried112612853decried
deemed104713063deem_ed
defied115016383d_efied
degummed1542603degumm_ed
deified123112413deified
delimed11310723delimed
demies94825803d_emies
demised113613683demised
demoded123611123demoded
demoed103713443d_emoed
demoted114313543demoted
denied84318633d_enied
denimed1159233denimed
desmid1048363desmi_d
diamide1138473diamide
died66137853d___ied
dimmer114112613dimm_er
dimming13339593dimming
dimpled132810303dimpled
dirtied93210853dirtied
divvied1544813divvied
dizzied17236133dizzied
dollied93811143dollied
domed95423263d_om_ed
doomed104113293doom_ed
doomier103610123doomier
dormie9312623dormie_
drammed13378073drammed
dried75321383d__ried
drumbled14266033drumbled
drumlier1134523drumlier
drummer12407503drumm_er
drumming14265783drumming
dualized1937403dualized
dubbed124113213du_bbed
duchies133312313duchies
ducked144718013du_cked
duckie133511663duckie_
duckier143911793duckier
duckies143613813duckies
ducted104012123du_cted
duddie9348863duddie_
duded84417133du__ded
dueled84813663du_eled
duelled9359753duelled
dueted84113593du_eted
duetted937023duetted
duked115218463du__ked
dulled84719423du_lled
dumber114414173du_mber
dumbhead17102743dumbhead
dumbing13319853dumbing
dummy134712783dumm__y
dummying17263723dummying
dumper114615213du_mper
dumpiest1338743dumpiest
dumpily1566233dumpily
dumping133712913dumping
dumpish15116113dumpish
dunged95414693du_nged
dungier9368583dungier
dunked124315283du_nked
dunned85015523du_nned
dunted84718503du_nted
duomi8310133duomi__
duped95118323du__ped
dupped124411643du_pped
dured75025403du__red
durned84113173du_rned
durrie73713263durrie_
durries83817353durries
dusked124112513du_sked
duskier12409433duskier
dusted83918373du_sted
dustier83814133dustier
duties74921903du_ties
fulmined1454333fulmined
fumbled153710493fumbled
fumed116118823fu_m_ed
fumier11310903fu_mier
gammed124216163gamm_ed
gammier123711193gammier
gemmed12329573gemm_ed
gemmier12337383gemmier
gimmie11298183gimmie_
gimmies123010113gimmies
gullied93812063gullied
gummer114615453gumm_er
gummiest13269033gummiest
gumming133810193gumming
gummite1236133gummite
gummites1346173gummites
gumweed1433943gumweed
gussied9267193gussied
hammed144116973hamm_ed
hammier143510653hammier
hemmed144211463hemm_ed
humbled153711813humbled
humid114213763hu_mi_d
humified1745653humified
hummer133615273humm_er
humming153310673humming
humored1336723humored
humped144015243hu_mped
humphed1835423humphed
humpier143110723humpier
hurried113511043hurried
immies102412443_immies
immixed1933573_immixed
jammed183811503jamm_ed
jammier18408023jammier
jammies183611293jammies
jemmies18318333jemmies
jimmie17376473jimmie_
jimmies18328783jimmies
jumbled19379963jumbled
jumped183511553ju_mped
jumpier18317943jumpier
juried144212443ju_ried
juttied15417863juttied
kummel14266173kumm_el
lammed113915623lamm_ed
lumped114216963lu_mped
lumpier113410143lumpier
mammie94313783mammie_
mammies104314763mammies
mimed105622733__mimed
mommies103912273mommies
muddied12339213muddied
mumbled143010763mumbled
mummer93614543mumm_er
mummified1643253mummified
mummify1643333mummify
mumming114010023mumming
mumped133813163mu_mped
nimmed11368573nimm_ed
numbed114111443nu_mbed
outvied11239693outvied
plummier1434123plummier
pommie123710503pommie_
pommies133712843pommies
pumiced1435173pumiced
pummel12278043pumm_el
pummeled1543373pummeled
pumped133915563pu_mped
puttied103811163puttied
queried1738683queried
rammed113117303ramm_ed
rammier112811023rammier
rimmed114812303rimm_ed
rubied94312413ru_bied
rumbaed12287493rumbaed
rumbled124514593rumbled
rummaged1443273rummaged
rummer104715483rumm_er
rummiest12299353rummiest
rumored1046643rumored
rumpled123810013rumpled
scummed14347913scumm_ed
scummier1445083scummier
shammied16265543shammied
shimmied16294983shimmied
slummed12359273slumm_ed
slummier1235473slummier
stimied10310623stimied
stummed12348553stumm_ed
stymied1335663stymied
sullied83714483sullied
summae103911013summae_
summand1236263summand
summated13298833summated
summer104017713summ_er
summered1338143summered
summing122912383summing
summit10311543summi_t
summits1137983summits
summoned1345723summoned
surmised1136863surmised
tammie104212693tammie_
tammies113814683tammies
tommed113310143tomm_ed
tommies113812983tommies
tumbled123412243tumbled
tumefied1443353tumefied
tumid84114023tu_mi_d
tummler11266613tummler
tumped114216233tu_mped
umped104717273_u_mped
umpired1235783_umpired
unmined102612953_unmined
unmixed17228213_unmixed
untied73720813_untied
yummiest15256723yummiest

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272525.61023890.7
3Display Results2522520.0932709.7
 (SQL Overall)1786912526.09329327.3
 
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.