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

125 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
stodgiest113565(None) 
dodgiest11308712_dodgiest
podgiest12269092_podgiest
sedgiest10259762s_edgiest
shoddiest1434762shoddiest
sludgiest1135812sludgiest
smoggiest1334462smoggiest
smudgiest1334372smudgiest
soggiest102711642s_oggiest
spongiest1237092spongiest
staggiest11148262staggiest
stagiest91613412st_agiest
stingiest10209772stingiest
stockiest15207752stockiest
stodges9309082stodg_es_
stodgier1034222stodgie_r
stodginess1243892stodginess
stogies8413692sto_gies_
stoniest8413542sto_niest
stormiest1137002stormiest
studliest1036572studliest
boggiest123110933_boggiest
cloddiest1334633cloddiest
cloggiest1334723cloggiest
doggiest113410523_doggiest
edgiest92310353__edgiest
fledgiest1444183fledgiest
foggiest13249653_foggiest
froggiest1434913froggiest
godliest1039453_godliest
goodliest1146393goodliest
grodiest10310553grod_iest
groggiest1235093groggiest
hedgiest13298133_hedgiest
hoodiest122413173hood_iest
kludgiest1543153kludgiest
ledgiest10288593_ledgiest
loggiest103011013_loggiest
logiest82515543_lo_giest
moodiest112712183mood_iest
pudgiest12297893_pudgiest
ridgiest1038903_ridgiest
saggiest102812723s_aggiest
sagiest82617993s__agiest
sandiest93218693sand_iest
scroggiest1443323scroggiest
seediest92714053seed_iest
shadiest121711283shad_iest
shaggiest14156903shaggiest
shoaliest1238513shoaliest
shoddies1336053shoddies_
showiest1438793sho_wiest
skiddiest1543813skiddiest
slaggiest11157713slaggiest
slangiest10129083slangiest
slobbiest1345093slobbiest
sloppiest1345983sloppiest
sloshiest1246683sloshiest
sloughiest1443943sloughiest
smokiest1437883smo_kiest
snaggiest11126683snaggiest
snobbiest1354963snobbiest
snoopiest11157073snoopiest
snootiest9178753snootiest
snooziest18175393snooziest
snottiest9167973snottiest
snoutiest9178253snoutiest
snowiest1138143sno_wiest
soapiest102412853s_oapiest
soddies92312853s_oddies_
songfest1236843s_ongfest
sonsiest8313033s_onsiest
sootiest84016753s_ootiest
soppiest122511943s_oppiest
sorriest8413883s_orriest
soupiest102212923s_oupiest
spookiest15156403spookiest
spooniest11178143spooniest
sportiest111711033sportiest
spottiest11177693spottiest
staggies101210323staggies_
stalkiest1347913stalkiest
starriest9159773starriest
steadiest1038523steadiest
steamiest1138413steamiest
steeliest939643steeliest
stemmiest1335143stemmiest
stickiest15229603stickiest
stilliest939223stilliest
stinkiest13198463stinkiest
stockist14197713stocki_st
stodge8369043stodg_e__
stodged10377983stodg_e_d
stodgily1343903stodgi_ly
stodging11277463stodgi_ng
stogie7311323sto_gie__
stolidest1046113stolidest
stooges83611483stoog_es_
stoolies8311083stoolies_
stories7324273sto_ries_
stoutest837613sto_utest
strawiest1237223strawiest
stringiest11197593stringiest
stripiest1138023stripiest
strongest10338303strong_est
stroppiest1444583stroppiest
stubbiest1345483stubbiest
studdies10207073studdies_
studies82413863stud_ies_
stuffiest15235953stuffiest
stumpiest1335863stumpiest
sturdiest10207393sturdiest
sudsiest939623s_udsiest
swingiest13207573swingiest
swooniest12176293swooniest
swoopiest14155393swoopiest
tangiest92915223_tangiest
tidiest83514873_tid_iest
toddies93011993_toddies_
todies74223553_tod_ies_
toniest73218903_to_niest
toughest1238303_toughest
wedgiest13307983_wedgiest
woodiest123112073wood_iest
woodsiest1335203woodsiest

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411256.83021763.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.27924548.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.