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

156 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
shaggiest1415689(None) 
saggiest102812711s_aggiest
slaggiest11157701slaggiest
snaggiest11126671snaggiest
staggiest11148251staggiest
baggiest123011752_baggiest
braggiest13116782braggiest
craggiest13116522craggiest
draggiest12126412draggiest
faggiest132910182_faggiest
flaggiest14145502flaggiest
jaggiest17289322_jaggiest
naggiest102610012_naggiest
quaggiest2044172quaggiest
sagiest82617982s_a_giest
scraggiest1444362scraggiest
shabbiest1635322shabbiest
shadiest121711272sha_diest
shaggier13116052shaggie_r
shagginess1543932shagginess
shakiest151910932sha_kiest
shaliest111415052sha_liest
slangiest10129072slangiest
smoggiest1334462smoggiest
soggiest102711642s_oggiest
staggies101210322staggies_
stagiest91613402sta_giest
swaggies13136692swaggies_
aggies83515513__aggies_
baggies113814853_baggies_
boggiest123110933_boggiest
braggest1296533bragg_est
buggiest123410363_buggiest
cagiest102916433_ca_giest
chaffiest2045413chaffiest
chalkiest1837083chalkiest
chanciest1638373chanciest
chariest13315503cha_riest
charriest1438253charriest
chattiest1448203chattiest
cloggiest1334723cloggiest
doggiest113410523_doggiest
dreggiest12124543dreggiest
druggiest12134973druggiest
foggiest13249653_foggiest
froggiest1434913froggiest
fuggiest13228813_fuggiest
groggiest1235093groggiest
haggis11209513_haggi_s_
haggises1335883_haggises
haggish15207473_haggi_sh
haggles123312483_haggles_
hairiest11612463_hairiest
hammiest152610003_hammiest
handiest123417773_handiest
hangnest12311413_hangnest
happiest152411673_happiest
hardiest123416333_hardiest
hastiest112916493_hastiest
haziest193313003_ha_ziest
hedgiest13298133_hedgiest
jaggies163311083_jaggies_
jiggiest17277693_jiggiest
leggiest10308233_leggiest
loggiest103011013_loggiest
mangiest112815903_mangiest
muggiest12228533_muggiest
orangiest1038463orangiest
piggiest12259663_piggiest
puggiest12219223_puggiest
raggies93214733_raggies_
rangiest93115983_rangiest
sagest74920263s_a_g_est
saggier92912063s_aggie_r
saltiest83117713s_altiest
sandiest93218683s_andiest
sappiest122612573s_appiest
sarkiest123615063s_arkiest
sassiest83413613s_assiest
sauciest10310973s_auciest
savviest1435983s_avviest
scabbiest1534913scabbiest
scaliest101714393sca_liest
scantiest112611003scantiest
scariest101615943sca_riest
scarriest11188393scarriest
scattiest11268363scattiest
scraggliest1542483scraggliest
scroggiest1443323scroggiest
seamiest102715413sea_miest
sedgiest10259763s_edgiest
shadowiest1742803shadowiest
shagged134210133shagg_e_d
shaggily1643773shaggi_ly
shagging14349053shaggi_ng
shammies15259683shammies_
shandies122714103shandies_
shannies113411253shannies_
shanties113116583shanties_
shapeliest1544963shapeliest
sharpest1339143sha_rpest
sharpies13411223sharpies_
shavies134213203sha_vies_
sheeniest12158353sheeniest
shelliest1238023shelliest
shelviest1535003shelviest
shiest95821523sh___iest
shiftiest1537363shiftiest
shiniest113212493sh_iniest
shirtiest1239323shirtiest
shittiest1238333shittiest
shoaliest1238503shoaliest
shoddiest1434753shoddiest
showiest1438783sh_owiest
skankiest12145703skankiest
slaggier10126953slaggie_r
slatiest82616263sla_tiest
sludgiest1135803sludgiest
smarmiest1335903smarmiest
smudgiest1334373smudgiest
smuggest1244373smugg_est
snaggier10136303snaggie_r
snakiest122110543sna_kiest
snappiest1346493snappiest
snarkiest13207633snarkiest
snarliest91810203snarliest
snazziest1743133snazziest
snuggest1045243snugg_est
snuggies10246363snuggies_
soapiest102412843soa_piest
spaciest122310893spa_ciest
spangliest1345153spangliest
sparkiest15188093sparkiest
sparriest11198783sparriest
spongiest1237083spongiest
spriggiest14174533spriggiest
staggie9138463staggie__
staggier10167513staggie_r
stalkiest1347903stalkiest
starriest9159763starriest
stingiest10209773stingiest
stodgiest1135653stodgiest
straggliest1343613straggliest
sugariest1038133sugariest
suggest9310863s_ugg_est
swaggie12135783swaggie__
swampiest1635023swampiest
swankiest16136203swankiest
swingiest13207573swingiest
tangiest92915223_tangiest
twangiest1355223twangiest
twiggiest1443413twiggiest
vuggiest13216923_vuggiest
waggliest1434783_waggliest
whackiest2144983whackiest
wiggiest13269013_wiggiest

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.203880251.2
2DLD Change Limit1486411567.09620947.2
3Display Results1561560.0602600.0
 (SQL Overall)1786911567.35924282.0
 
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.