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

126 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
cloggiest133472(None) 
loggiest103011011_loggiest
boggiest123110932_boggiest
clingiest1257132clingiest
cloddiest1334632cloddiest
cloggier1244252cloggie_r
cloudiest1235582cloudiest
craggiest13116522craggiest
doggiest113410522_doggiest
flaggiest14145512flaggiest
foggiest13249652_foggiest
froggiest1434912froggiest
groggiest1235092groggiest
leggiest10308232_leggiest
logiest82515542_lo_giest
scroggiest1443322scroggiest
slaggiest11157712slaggiest
smoggiest1334462smoggiest
soggiest102711642_soggiest
baggiest123011753_baggiest
blockiest1736363blockiest
bloodiest1236663bloodiest
bloomiest1335853bloomiest
blottiest11286833blottiest
blousiest1136313blousiest
blowiest1337923blo_wiest
blowsiest1435323blowsiest
blowziest2343673blowziest
braggiest13116783braggiest
buggiest123410363_buggiest
cagiest102916433c__agiest
chokiest1738723cho_kiest
choosiest1437323choosiest
choppiest18226383choppiest
clammiest1535743clammiest
clankiest1536673clankiest
classiest11309553classiest
clayiest1337923cl_ayiest
clergies1137903clergies_
cliffiest1743953cliffiest
cliquiest2044093cliquiest
clogged12528653clogg_e_d
clogger11438803clogg_e_r
cloggers12437283clogg_ers
cloggily1543243cloggi_ly
clogging13368503cloggi_ng
closest94312533clo__sest
clubbiest1534273clubbiest
clumpiest1535353clumpiest
clumsiest1335393clumsiest
clunkiest1535163clunkiest
coaliest10316223c_oaliest
cobbiest14118523c_obbiest
cockiest163013293c_ockiest
comfiest1539133c_omfiest
congest104618773c_ong_est
corkiest143114793c_orkiest
corniest102117303c_orniest
cosiest93819853c_o_siest
cowiest123614673c_o_wiest
coziest184014353c_o_ziest
croakiest15167173croakiest
croupiest1337063croupiest
dodgiest11308713_dodgiest
doggies103613023_doggies_
draggiest12126413draggiest
dreggiest12124543dreggiest
druggiest12134973druggiest
faggiest132910183_faggiest
fledgiest1444183fledgiest
floatiest1237293floatiest
flockiest1835643flockiest
floppiest1654783floppiest
flossiest12296803flossiest
fuggiest13228813_fuggiest
globbiest1444023globbiest
gloomiest1235603gloomiest
gloppiest1444833gloppiest
glossiest10277943glossiest
goggliest1234063_goggliest
jaggiest17289323_jaggiest
jiggiest17277693_jiggiest
kludgiest1543153kludgiest
ledgiest10288593_ledgiest
lingiest93715263_lingiest
loamiest102310213_loamiest
loftiest1139083_loftiest
loggets9378913_logg_ets
loggias9356783_loggias_
loggie84011993_loggie__
loggier93811143_loggie_r
loggish12258733_loggi_sh
longest84114953_long_est
longies82916553_longies_
looniest83313253_looniest
loopiest103011323_loopiest
loppiest122410113_loppiest
lousiest82311613_lousiest
lowliest11229473_lowliest
luggies93011213_luggies_
moggies113111723_moggies_
muggiest12228533_muggiest
naggiest102610013_naggiest
ologies8615023olo_gies_
ologist8313833olo_gi_st
piggiest12259663_piggiest
plottiest11287833plottiest
podgiest12269093_podgiest
puggiest12219223_puggiest
quaggiest2044173quaggiest
saggiest102812723_saggiest
scraggiest1444373scraggiest
shaggiest14156903shaggiest
slangiest10129083slangiest
slobbiest1345093slobbiest
sloppiest1345983sloppiest
sloshiest1246683sloshiest
sloughiest1443943sloughiest
sludgiest1135813sludgiest
snaggiest11126683snaggiest
spongiest1237093spongiest
staggiest11148263staggiest
stodgiest1135653stodgiest
twiggiest1443413twiggiest
vuggiest13216923_vuggiest
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.513348325.5
2DLD Change Limit1486411267.15620771.5
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.73223110.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.