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

142 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
smudgier123375(None) 
sludgier1034821sludgier
kludgier1432462kludgier
muddier114110022_muddier
muggier11288942_muggier
pudgier11377722_pudgier
sedgier9399052s_edgier
smoggier1243972smoggier
smudge10387912smudg_e_
smudged12326462smudg_ed
smudges11348282smudg_es
smudgiest1334372smudgiest
smudgily1543122smudgily
smudging13255722smudging
smugger11327052smu_gger
smuggler12244522smuggler
smuttier1035212smuttier
stodgier1034222stodgier
studier82510052stud_ier
studlier935472studlier
sudsier868782s_udsier
bludger11419563bludg_er
budger104617713_budg_er
budgie104310343_budgie_
budgies115312513_budgies
buggier113611343_buggier
bulgier103911213_bulgier
cruddier1244153cruddier
dodgier10388243_dodgier
drudger10328323drudg_er
druggier11134833druggier
dungier9368583_dungier
edgier8469733__edgier
fledgier1333683fledgier
fuggier12348963_fuggier
gaudier938453gaud_ier
grudger10368313grudg_er
grungier1034983grungier
hedgier12367883_hedgier
judger154411453_judg_er
ledgier9458503_ledgier
loudlier934953loudlier
mangier104114063_mangier
mingier103815293_mingier
muckier153411483_muckier
mudder104413493_mud_der
muddied12339213_muddied
muddies113513953_muddies
muddler113411623_muddler
mugger103914703_mu_gger
murkier133110273_murkier
mushier123813593_mushier
muskier134312733_muskier
mussier93314363_mussier
mustier94017963_mustier
muzzier17326553_muzzier
nudger85111643_nudg_er
podgier11338723_podgier
puggier11309383_puggier
ridgier937883_ridgier
ruddier9338523_ruddier
saggier92912063s_aggier
sagier73717163s__agier
sandier84017843sand_ier
saucier9810283sau_cier
sauger74316253sau_g_er
scummier1445083scummier
scurfier13267053scurfier
scurvier13255883scurvier
scuzzier1842713scuzzier
seedier83513633seed_ier
shadier113111153shad_ier
shaggier13116053shaggier
shoddier1334213shoddier
shudder12297323shud_der
skiddier1464193skiddier
skunkier11174283skunkier
slaggier10126953slaggier
slangier9117933slangier
sludge84811943sludg_e_
sludged103610343sludg_ed
sludges93811993sludg_es
sludgiest1135803sludgiest
sludging11268363sludging
slugger93610683slu_gger
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
smarmier1235033smarmier
smearier1036953smearier
smellier1036793smellier
smidge10378483smidg_e_
smidgen11426513smidg_en
smidges11448193smidg_es
smidgin11335103smidgi_n
smidgins12314843smidgins
smirkier1444433smirkier
smokier1356703sm_okier
smudginess1442873smudginess
smudgy13294133smudg__y
smuggle11265013smuggle_
smuggled13254223smuggled
smugglers13263433smugglers
smuggles12225443smuggles
smutchier1643503smutchier
snaggier10136303snaggier
snubbier1244993snubbier
snuffier14276943snuffier
snugger9318313snu_gger
snuggies10246363snuggies
soggier93410883s_oggier
soldier82812153sold_ier
soupier93111753sou_pier
splurgier1252343splurgier
spongier1135743spongier
spudder11256553spud_der
spumier1137903spu_mier
spunkier14235823spunkier
spurrier10297693spurrier
staggier10167513staggier
stagier83513443s_tagier
stingier9279123stingier
stubbier1235353stubbier
studdie9195273studdie_
studdies10207073studdies
studied9268693stud_ied
studiers9236623stud_iers
studies82413863stud_ies
stuffier14336623stuffier
stumpier1255883stumpier
sturdier9216963sturdier
suckier133613973s_uckier
sudser73511283s_ud_ser
sulkier113811963s_ulkier
sunnier73412153s_unnier
surfier102613543s_urfier
surger74320093s_urg_er
surlier72915443s_urlier
swingier12267003swingier
trudger9338733trudg_er
vuggier12296813_vuggier
wedgier12428283_wedgier

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 Limit1461621426.64022012.3
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.12625075.9
 
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.