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

297 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
yummier1430684(None) 
gummier12349471gummier
rummier11309561rummier
yummies14359531yummies
bummer124014102bumm_er
bumpier13359202bumpier
chummier1734512chummier
crummier1435602crummier
cummer124414592cumm_er
dummied13346722dummied
dummies123012132dummies
dumpier12409652dumpier
fumier11310902fu_mier
gammier123711192gammier
gemmier12337382gemmier
gummer114615452gumm_er
hammier143510652hammier
hummer133615272humm_er
humpier143110722humpier
jammier18408022jammier
jumpier18317942jumpier
lumpier113410142lumpier
mummer93614542mumm_er
mummied11327102mummied
mummies103812842mummies
plummier1434122plummier
rammier112811022rammier
rummer104715482rumm_er
rummies113212792rummies
scummier1445082scummier
slummier1235472slummier
summer104017712summ_er
tummies113012032tummies
tummler11266612tummler
yammer133713182yamm_er
yuckier16358532yuckier
yukkier13263892yukkier
yummiest15256722yummiest
balmier113811513balmier
barmier114313043barmier
beamier113411943beamier
boomier113312183boomier
buffier1568403buffier
buggier113611343buggier
bulgier103911213bulgier
bulkier134111513bulkier
bullier94116433bullier
bumbler134013233bumbler
bummed134211723bumm_ed
bummers133712443bumm_ers
bumming143410783bumming
bumper123714343bu_mper
burier84324653bu_rier
burlier93514413burlier
burrier93613553burrier
bushier123712813bushier
busier85219723bu_sier
bustier93916153bustier
cammie124615293cammie_
cammies134016483cammies
campier133313273campier
clammier1435843clammier
clumpier1435583clumpier
clumsier1234733clumsier
comfier1439163comfier
commie124215523commie_
commies133718453commies
crumbier1456363crumbier
crummie1336153crummie_
crummies1437643crummies
cumber124016703cu_mber
cummers133713483cumm_ers
cummin1288783cummi_n
cummins1358963cummins
cuppier1368323cuppier
curdier103312623curdier
curlier93314183curlier
currier93316703currier
curvier123110663curvier
cushier123610833cushier
dammer114317933damm_er
dimmer114112613dimm_er
doomier103610123doomier
drumlier1134523drumlier
drummer12407503drumm_er
duckier143911793duckier
dumber114414173du_mber
dumper114615213du_mper
dungier9368583dungier
duskier12409433duskier
dustier83814133dustier
elmier839813_elmier
emmer94314463_emm_er
filmier1237503filmier
flamier123112143flamier
foamier12339003foamier
frumpier1534173frumpier
fubsier12367763fubsier
fuggier12348963fuggier
fumbler143610813fumbler
fumer105918233fu_m_er
funkier14349983funkier
funnier103210173funnier
furrier103513663furrier
furzier19318103furzier
fussier103610673fussier
fustier104213933fustier
fuzzier18256523fuzzier
gambier124711973gambier
gamier93617933_gamier
gammer1112318333gamm_er
germier10309543germier
gimmie11298183gimmie_
gimmies123010113gimmies
gimpier12247943gimpier
glummer12417983glumm_er
glumpier1334873glumpier
grimier103210433grimier
grummer12338783grumm_er
grumpier1334803grumpier
gulfier1137793gulfier
gulpier1046953gulpier
gummed123811663gumm_ed
gummers123712203gumm_ers
gummiest13269023gummiest
gumming133810193gumming
gummite1236133gummite
gummites1346173gummites
gunkier12369553gunkier
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
hammer138120033hamm_er
haulmier1333143haulmier
hemmer134112643hemm_er
hempier14319003hempier
homier116416993_homier
huffier1637493huffier
hulkier14328973hulkier
humaner12257663humaner
humbler143411943humbler
hummed144812673humm_ed
hummers143813063humm_ers
humming153310673humming
humper134115883hu_mper
hunkier144512143hunkier
hurrier103412943hurrier
huskier14369763huskier
immies102412443_immies
jammer174014133jamm_er
jammies183611293jammies
jemmied19294483jemmied
jemmies18318333jemmies
jimmie17376473jimmie_
jimmied19275033jimmied
jimmies18328783jimmies
juicier1635463juicier
jumbler183910273jumbler
jumper173612373ju_mper
junkier18339493junkier
kummel14266173kumm_el
lambier113611643lambier
limbier11349113limbier
limier83518723_limier
limmer104314793limm_er
loamier9349163loamier
luckier133811533luckier
lumber103817773lu_mber
lumper103816653lu_mper
lunier64617603lu_nier
lustier73813503lustier
luthier1038233luthier
malmier113611953malmier
mammer94218863mamm_er
mammie94313783mammie_
mammies104314763mammies
mimer94825763__mimer
mommies103912273mommies
muckier153411483muckier
muddier114110023muddier
muggier11288943muggier
mumbler133510913mumbler
mummed104411553mumm_ed
mummers103712843mumm_ers
mummery13336663mumm_ery
mummify1643333mummify
mumming114010023mumming
mumper123513523mu_mper
murkier133110273murkier
mushier123813593mushier
muskier134312733muskier
mussier93314363mussier
mustier94017963mustier
muzzier17326553muzzier
nubbier11308133nubbier
number103913223nu_mber
nutsier7329253nutsier
nuttier73112023nuttier
outlier72216143outlier
palmier113312173palmier
plumier113510043plumier
plummer13298523plumm_er
pommie123710503pommie_
pommies133712843pommies
premier113515633premier
pudgier11377723pudgier
puffier1547973puffier
puggier11309383puggier
pulpier1148623pulpier
pumicer1335063pumicer
pummel12278043pumm_el
pumper124415553pu_mper
punier84519223pu_nier
punkier133512793punkier
punnier93511263punnier
pursier94012753pursier
purtier93214093purtier
pushier123611093pushier
pussier93711993pussier
puttier93314503puttier
quakier20239203quakier
qualmier1934563qualmier
querier16310013querier
rammer103519653ramm_er
rimier83916273_rimier
rimmer103516033rimm_er
roomier93812243roomier
rubier84814743ru_bier
ruddier9338523ruddier
rulier65016353ru_lier
rumbler113514113rumbler
rummager1343593rummager
rummers113513653rumm_ers
rummiest12299353rummiest
rumplier1235303rumplier
runnier74010113runnier
runtier73512853runtier
rushier103411973rushier
rustier74416363rustier
ruttier73412283ruttier
scummer13398753scumm_er
seamier93114633seamier
simmer104115353simm_er
slimier93212013slimier
slummer113711203slumm_er
spumier1137903spumier
stemmier1245253stemmier
stumpier1255883stumpier
suckier133613973suckier
sudsier868783sudsier
sulkier113811963sulkier
summae103911013summae_
summed114014043summ_ed
summerier1346423summerier
summers113616503summ_ers
summery14329413summ_ery
summing122912383summing
summit10311543summi_t
summited13246413summited
summiteer1343003summiteer
summitry1543323summitry
summits1137983summits
summoner1245533summoner
sumpter1138873sumpter
sunnier73412153sunnier
surfier102613543surfier
surlier72915443surlier
surmiser1036763surmiser
swimmier15174313swimmier
tammie104212693tammie_
tammies113814683tammies
thrummier1641793thrummier
thymier1534393thymier
tommies113812983tommies
tubbier11237743tubbier
tuftier1096603tuftier
tumbler113412823tumbler
tummlers12295703tummlers
turfier10249793turfier
uglier748953_uglier
umber94617593_u_mber
umpire1047893_umpire
unmiter9310393_unmiter
vampier14308233vampier
vuggier12296813vuggier
wimpier14248053wimpier
wombier1436543wombier
wormier12278763wormier
wussier10408083wussier
yammerer15225483yammerer
yammers143410323yamm_ers
yolkier14336123yolkier
yumminess1653643yumminess
yummy15429153yumm__y
yuppie13297133yuppie_
yuppies14339263yuppies

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.1401276364.3
2DLD Change Limit1340272976.69020033.9
3Display Results2972970.1062801.9
 (SQL Overall)1786912976.93625762.8
 
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.