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

159 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
stodgier103422(None) 
dodgier10388242_dodgier
podgier11338722_podgier
sedgier9399052s_edgier
shoddier1334212shoddier
sludgier1034822sludgier
smoggier1243972smoggier
smudgier1233752smudgier
soggier93410882s_oggier
spongier1135742spongier
staggier10167512staggier
stagier83513442st_agier
stingier9279122stingier
stockier14217252stockier
stodge8369042stodg_e_
stodged10377982stodg_ed
stodges9309082stodg_es
stodgiest1135652stodgiest
stodgily1343902stodgily
stodging11277462stodging
stogie7311322sto_gie_
stogies8413692sto_gies
stonier72013792sto_nier
stormier1036102stormier
studier82510052stud_ier
studlier935472studlier
boggier113711583_boggier
cloddier1234063cloddier
cloggier1244253cloggier
codger105814873_codg_er
dodger95817053_dodg_er
doggier103810943_doggier
edgier8469733__edgier
fledgier1333683fledgier
foggier12349913_foggier
froggier1354643froggier
godlier938893_godlier
goodlier1035793goodlier
grodier939673grod_ier
groggier1134343groggier
hedgier12367883_hedgier
hoodier113812973hood_ier
kludgier1432463kludgier
ledgier9458503_ledgier
lodger86517693_lodg_er
loggier93811143_loggier
logier75015733_lo_gier
moodier103212203mood_ier
pudgier11377723_pudgier
ridgier937883_ridgier
saggier92912063s_aggier
sagier73717163s__agier
sandier84017843sand_ier
scroggier1343143scroggier
seedier83513633seed_ier
shadier113111153shad_ier
shaggier13116053shaggier
shoalier1137073shoalier
shoddies1336053shoddies
showier1339103sho_wier
skiddier1464193skiddier
slaggier10126953slaggier
slangier9117933slangier
slobbier1254633slobbier
slogger94310483slo_gger
sloppier1255713sloppier
sloshier1135283sloshier
sloughier1343673sloughier
smokier1356703smo_kier
snaggier10136303snaggier
snobbier1234633snobbier
snoopier10177273snoopier
snootier8278383snootier
snoozier17185193snoozier
snottier8217383snottier
snoutier8206973snoutier
snowier1038793sno_wier
soapier93411713s_oapier
soddies92312853s_oddies
soldier82812153s_oldier
sonsier7711743s_onsier
sootier73916613s_ootier
soppier112711583s_oppier
sorrier72313733s_orrier
soupier93111753s_oupier
sponger1038523spong_er
spookier14175493spookier
spoonier10167653spoonier
sportier102010053sportier
spottier10207313spottier
stager74821343st_ag_er
stagger94212393st_agger
staggie9138463staggie_
staggies101210323staggies
stalkier1257073stalkier
starrier8279463starrier
steadier937313steadier
steamier1048303steamier
steelier839193steelier
stemmier1245253stemmier
stickier14229763stickier
stillier868823stillier
stinger84314683sting_er
stinkier12278543stinkier
stocker133713083sto_cker
stodginess1243893stodginess
stodgy11415733stodg__y
stogey105811543sto_g_ey
stoker104417623sto__ker
stolider936603stolider
stomper114111233sto_mper
stoner65823203sto__ner
stooge73811663stoog_e_
stooged94310733stoog_ed
stooges83611483stoog_es
stooging102810043stooging
stooker113811733sto_oker
stoolie739723stoolie_
stoolies8311083stoolies
stooper93813193sto_oper
stoper84320103sto__per
stopover1344063stopover
stopper113012603sto_pper
storer64721673sto__rer
storied8515163sto_ried
stories7324273sto_ries
stourie7469353stourie_
stouter74012053sto_uter
stover94115643sto__ver
strawier1137493strawier
stringier1036713stringier
stripier1058863stripier
stronger9349693strong_er
stroppier1364463stroppier
stubbier1235353stubbier
studdie9195273studdie_
studdies10207073studdies
studied9268693stud_ied
studiers9236623stud_iers
studies82413863stud_ies
stuffier14336623stuffier
stumpier1255883stumpier
sturdier9216963sturdier
sudsier868783s_udsier
swingier12267003swingier
swoonier11185133swoonier
swoopier13175143swoopier
tangier83013913_tangier
tidier73515113_tid_ier
toddies93011993_toddies
toddler9379043_toddler
todies74223553_tod_ies
toggler9399193_toggler
tonger74719693_tong_er
tonier65520713_to_nier
tougher114210983_tougher
wedgier12428283_wedgier
woodier113912063wood_ier
woodsier1245473woodsier

Search took 9 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 Limit1461621597.75018859.6
3Display Results1591590.0602650.0
 (SQL Overall)1786911598.23321704.2
 
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.