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

193 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
scummier144508(None) 
scummer13398751scumm_er
slummier1235471slummier
chummier1734512chummier
crummier1435602crummier
cummer124414592_cumm_er
gummier12349472_gummier
plummier1434122plummier
rummier11309562_rummier
scammer133611972scamm_er
scummed14347912scumm_ed
scummers14277782scumm_ers
scummiest1535212scummiest
scummily1743302scummily
scumming15256792scumming
scurfier13267052scurfier
scurvier13255882scurvier
scuzzier1842712scuzzier
slummer113711202slumm_er
spumier1137902spu_mier
stemmier1245252stemmier
stumpier1255882stumpier
summer104017712s_umm_er
swimmier15174312swimmier
yummier14306842_yummier
bummer124014103_bumm_er
bumpier13359203_bumpier
cammie124615293_cammie_
cammies134016483_cammies
campier133313273_campier
clammier1435843clammier
clumpier1435583clumpier
clumsier1234733clumsier
comfier1439163_comfier
commie124215523_commie_
commies133718453_commies
crumbier1456363crumbier
crummie1336153crummie_
crummies1437643crummies
cumber124016703_cu_mber
cummers133713483_cumm_ers
cummin1288783_cummi_n
cummins1358963_cummins
cuppier1368323_cuppier
curdier103312623_curdier
curlier93314183_curlier
currier93316703_currier
curvier123110663_curvier
cushier123610833_cushier
drumlier1134523drumlier
drummer12407503drumm_er
dummied13346723_dummied
dummies123012133_dummies
dumpier12409653_dumpier
frumpier1534173frumpier
fumier11310903_fu_mier
gammier123711193_gammier
gemmier12337383_gemmier
glummer12417983glumm_er
glumpier1334873glumpier
grummer12338783grumm_er
grumpier1334803grumpier
gummer114615453_gumm_er
hammier143510653_hammier
haulmier1333143haulmier
hummer133615273_humm_er
humpier143110723_humpier
jammier18408023_jammier
jumpier18317943_jumpier
lumpier113410143_lumpier
mummer93614543_mumm_er
mummied11327103_mummied
mummies103812843_mummies
plumier113510043plu_mier
plummer13298523plumm_er
rammier112811023_rammier
rummer104715483_rumm_er
rummies113212793_rummies
saucier9810283sau_cier
scabbier1435133scabbier
scalier94316913sc_alier
scammed14479543scamm_ed
scammers14339773scamm_ers
scamming15328543scamming
scamper134613163sc_amper
scampies1439333scampies
scamster1235303scamster
scantier10309983scantier
scarier94017873sc_arier
scarrier10298453scarrier
scattier10267583scattier
schemer1477963schem_er
schizier2234063schizier
schlumpier1941473schlumpier
schmeer1475363sc_hmeer
scimiter1236143scimiter
screwier1346433screwier
scrimper1455763scrimper
scrimpier1554243scrimpier
scrubbier1543333scrubbier
scruffier1743303scruffier
scrummed1554313scrumm_ed
scrumming1654023scrumming
scuffer15328883scu_ffer
scuffler16286703scuffler
sculker13318323scu_lker
sculler99812153scu_ller
scumble1337013scumble_
scumbled1535053scumbled
scumbles1447023scumbles
scumlike1644353scumlike
scummy15265223scumm__y
scunner9358243scu_nner
scupper1367423scu_pper
scurried11267053scurried
scurries102911483scurries
scurvies13248123scurvies
scutcher15176963scutcher
scutter93512173scu_tter
seamier93114633s_eamier
seemlier1035193seemlier
shammer144613143shamm_er
shammied16265543shammied
shammies15259693shammies
shimmer143310873shimm_er
shimmied16294983shimmied
shimmies15287803shimmies
simmer104115353s_imm_er
skimmer15327533skimm_er
skimpier1634293skimpier
skunkier11174283skunkier
slammer113913033slamm_er
slimier93212013s_limier
slimmer114211343slimm_er
slimsier1085213slimsier
sludgier1034823sludgier
slumber113811003slu_mber
slummed12359273slumm_ed
slummers12358933slumm_ers
slummiest1335673slummiest
slumming13278383slumming
slushier1135983slushier
sluttier836453sluttier
smarmier1235033smarmier
smudgier1233753smudgier
smuttier1035213smuttier
snubbier1244993snubbier
snuffier14276943snuffier
soupier93111753sou_pier
spammer133410433spamm_er
spunkier14235823spunkier
spurrier10297693spurrier
squirmier2042853squirmier
stammer116013343stamm_er
steamier1048303steamier
stemmer113210183stemm_er
stormier1036103stormier
strummer1234783strumm_er
stubbier1235353stubbier
studier82510053stu_dier
studlier935473studlier
stuffier14336623stuffier
stumbler1235813stumbler
stummed12348553stumm_ed
stumming13347673stumming
stumper113610093stu_mper
sturdier9216963sturdier
suckier133613973s_uckier
sudsier868783s_udsier
sulkier113811963s_ulkier
summae103911013s_ummae_
summed114014043s_umm_ed
summerier1346423s_ummerier
summers113616503s_umm_ers
summery14329413s_umm_ery
summing122912383s_umming
summit10311543s_ummi_t
summited13246413s_ummited
summiteer1343003s_ummiteer
summitry1543323s_ummitry
summits1137983s_ummits
summoner1245533s_ummoner
sumpter1138873s_umpter
sunnier73412153s_unnier
surfier102613543s_urfier
surlier72915443s_urlier
surmiser1036763s_urmiser
swampier1544593swampier
swimmer14297653swimm_er
thrummier1641793thrummier
tummies113012033_tummies
tummler11266613_tummler
yummies14359533_yummies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621936.61022112.3
3Display Results1931930.0603216.7
 (SQL Overall)1786911937.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.