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

421 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
clogged1252865(None) 
clagged12749231clagged
clogger11438801clogger
cogged116416611c_ogged
flogged13528801flogged
logged96622941_logged
slogged104910471slogged
beclogged1643142beclogged
blogger11448312blogger
bogged116019282_bogged
chugged1584822chugged
clanged114212652clanged
clinged113310092clinged
cloaked14368542cloaked
clocked164112832clocked
cloggers12437282cloggers
cloggier1244252cloggier
cloggy1344872clogg_y
clomped14398972clomped
cloned94518802clo_ned
clonked14429562clonked
clopped143611522clopped
closed95317962clo_sed
clothed134010282clothed
clotted104011822clotted
clouded11348832clouded
cloured103111542cloured
clouted104212162clouted
clowned13447722clowned
cloyed125111562clo_yed
cologned1237152cologned
cragged12479882cragged
dogged106017702_dogged
flagged13459632flagged
flogger12449462flogger
fogged125518372_fogged
frogged13408492frogged
glugged11396622glugged
hogged125817772_hogged
jogged166015922_jogged
lagged95520132_lagged
legged95713082_legged
lodged913815702_lodged
logger86420002_logger
longed87121372_longed
lugged94417062_lugged
mogged115215392_mogged
nogged95716332_nogged
plugged12408042plugged
progged12409802progged
shogged13397962shogged
slagged104312772slagged
slogger94310482slogger
slugged104410382slugged
snogged10417972snogged
sogged95518522_sogged
togged95117512_togged
unclogged1443932unclogged
aligned9128553aligned
alleged9389313alleged
backlogged2152963backlogged
bagged114519903_bagged
befogged1643153befogged
begged115013803_begged
belonged1235313belonged
bloated104513433bloated
blobbed11366563blobbed
blocked16449983blocked
bloggers12397403bloggers
blooded11379803blooded
bloomed12439433bloomed
blooped12398543blooped
blotted103911833blotted
bloused104310643bloused
blowed125016693blo_wed
blowsed13449023blowsed
blowzed22435973blowzed
bludged12439313bludged
blunged114310133blunged
boggled12409003_boggled
bonged105719603_bonged
boogied11379283boogied
bragged12449843bragged
bugged114318403_bugged
cadged114812333c_adged
caged95426363c__aged
changed144214143changed
charged144614023charged
chigger1436003chigger
chocked194411613chocked
choired13349343choired
choked164914793cho_ked
chomped17329773chomped
chopped174511003chopped
chorded144710553chorded
chored125321883cho_red
choused135012463choused
chowed154914643cho_wed
chowsed16478603chowsed
chugger1445373chugger
clacked164113603clacked
cladded12356923cladded
claimed12298833claimed
clammed14369963clammed
clamped144012043clamped
clanger104113493clanger
clanked143812253clanked
clapped143511173clapped
clashed133614013clashed
clasped123610443clasped
classed104113653classed
clawed125115073cl_awed
clayed125013043cl_ayed
cleaned103512003cleaned
cleared103612463cleared
cleated103417843cleated
cleaved134010483cleaved
cleeked14357733cleeked
clefted13326753clefted
cleped115114113cl_eped
clerked14326653clerked
clewed1225113203cl_ewed
cliched153711023cliched
clicked164112453clicked
climbed14336983climbed
clinger103812153clinger
clinked144011643clinked
clipped14439833clipped
cliqued19266683cliqued
clobber13378163clobber
cloche134312373cloche_
cloches144113713cloches
clocker153910873clocker
clod76124613clo___d
clog76123243clo_g__
cloggiest1334723cloggiest
cloggily1543243cloggily
clogging13368503clogging
clogs85519553clo_g_s
clone75728163clo_ne_
cloner84418093clo_ner
clones84526563clo_nes
cloque17288743cloque_
cloques18268563cloques
close76425223clo_se_
closer84918203clo_ser
closes85425593clo_ses
closet85226603clo_set
closeted1135613closeted
closured11266353closured
clothe114712993clothe_
clothes124513813clothes
clotured11246163clotured
cloud86716423clo__ud
clough12539133cloug_h
cloughs13517053cloughs
clouter93511693clouter
clove105619443clo_ve_
cloven114211513clo_ven
clover114617123clo_ver
clovered14187363clovered
cloves114918823clo_ves
clowder13367933clowder
cloze165517543clo_ze_
clozes174915563clo_zes
clubbed14307453clubbed
clucked163810133clucked
clued84917683cl__ued
clumped143610663clumped
clunked14439573clunked
coaled95022703c_oaled
coated94927043c_oated
coaxed165612513c_oaxed
cocked155022563c_ocked
codded114515303c_odded
coded95433183c_o_ded
codger105814853c_odger
coed77140543c_o__ed
coifed124113063c_oifed
coigned11418663coigned
coiled95123933c_oiled
coined94523603c_oined
coked124730693c_o_ked
coled85540753c_o_led
collaged12279963collaged
collied103316673collied
collogued1344073collogued
cologne1039353cologne_
colognes11310603colognes
colored10313473colored
coloured1148313coloured
combed135516543c_ombed
comped135919873c_omped
coned86040053c_o_ned
congaed11399743congaed
conge85227593c_onge_
congee96024463c_ongee
congeed113212313congeed
conger95024273c_onger
conges94928173c_onges
conked135019113c_onked
conned95119703c_onned
cooed84534343c_o_oed
cooeed95917863c_ooeed
cooeyed1346893cooeyed
cooked135921363c_ooked
cooled95224583c_ooled
cooped114821603c_ooped
coopted123710763coopted
coped105036843c_o_ped
copied114618563c_opied
copped135221253c_opped
corded105923353c_orded
cored85044223c_o_red
corked135020783c_orked
corned95224523c_orned
coshed124217543c_oshed
cosied94819883c_osied
costed95623113c_osted
coted85033853c_o_ted
coughed143310903coughed
couped115019313c_ouped
coved115027373c_o_ved
cowed115637843c_o_wed
cowled125218383c_owled
coxed154322813c_o_xed
coyed114623803c_o_yed
cozied184112153c_ozied
cringed113312403cringed
croaked143710533croaked
crocked164014433crocked
crooked143910943crooked
crooned103813343crooned
cropped143812063cropped
crossed105313893crossed
crowded14418783crowded
crowed124717293cro_wed
crowned133912423crowned
defogged1533783defogged
digged104314653_digged
dodged107514683_dodged
dogger95216783_dogger
dragged11379563dragged
drugged11367183drugged
eclogue1044503eclogue_
eclogues1144573eclogues
egged85114383__egged
eloigned1043423eloigned
eloined8149813eloined
eloped95914143elo_ped
fagged124717703_fagged
figged124013893_figged
flagger12469353flagger
flanged123810843flanged
fledged13417843fledged
floated113312703floated
flocced15365483flocced
flocked174510253flocked
floggers13387863floggers
flooded12307933flooded
floored11268683floored
flopped15338763flopped
flossed11388533flossed
floured11289873floured
flouted113210813flouted
flowed133513763flo_wed
fogger114414783_fogger
forged115519323_forged
fragged134010163fragged
frigged13439053frigged
frugged13387293frugged
fugged124615383_fugged
gagged104817153_gagged
gigged104112293_gigged
gloated93511533gloated
globed104811763glo_bed
glogg837353glogg__
gloggs935033glogg_s
glommed13265443glommed
gloomed11337413gloomed
glopped13347613glopped
gloried9169513gloried
glossed94410073glossed
glouted9429713glouted
gloved114811873glo_ved
glowed114913833glo_wed
glozed173711223glo_zed
goggled11348953_goggled
gonged97115913_gonged
gorged95016983_gorged
gouged96214593_gouged
hagged124317703_hagged
hogger114615083_hogger
hogget114715763_hogget
hugged124113643_hugged
igged86012763__igged
jagged164115353_jagged
jigged164412773_jigged
jogger154713163_jogger
joggled17398433_joggled
jugged163813933_jugged
kegged13469243_kegged
kludged14366533kludged
kluged12427223kl_uged
lagger85919833_lagger
loaded84616873_loaded
loafed104011153_loafed
loamed94414613_loamed
loaned73816293_loaned
lobbed113114613_lobbed
lobed86022133_lo_bed
locked134921663_locked
locoed94312193_locoed
lodge76520083_lodge_
lodger86517683_lodger
lodges86820143_lodges
lofted103811893_lofted
loge56837193_lo_ge_
loges66534203_lo_ges
loggers94616133_loggers
loggets9378913_loggets
loggia8457053_loggia
loggie84011993_loggie
loggier93811143_loggier
loggy105714193_logg_y
logier75015733_logier
loided83414023_loided
lolled74315823_lolled
longe66626463_longe_
longer75823203_longer
longes75925573_longes
looed64626133_lo_oed
looked114717073_looked
loomed94616763_loomed
looped95217173_looped
loosed75520893_loosed
looted74421113_looted
loped85128333_lo_ped
lopped114218623_lopped
lorded84916733_lorded
lotted74222403_lotted
lounged9468243_lounged
louped95316383_louped
loured74617403_loured
loused74822913_loused
louted74920693_louted
loved95021363_lo_ved
lowed95233903_lo_wed
loxed135017053_lo_xed
luged74019093_l_uged
lugger83916553_lugger
lunged85418273_lunged
mugged114113833_mugged
nagged93916053_nagged
noodged10295923noodged
ogled75915963__ogled
ologies8615023ologies
pegged114811903_pegged
pigged114214153_pigged
plagued11307473plagued
pledged12358613pledged
plodded1265563plodded
plonked14348103plonked
plopped11288773plopped
plotted104612373plotted
plotzed19376223plotzed
ploughed15204303ploughed
plowed124213203plo_wed
ployed124310563plo_yed
plugger11378433plugger
plunged11439523plunged
ponged105619353_ponged
prigged12398933prigged
progger11319373progger
pronged113912393pronged
pugged114314533_pugged
ragged94620263_ragged
rigged94517403_rigged
rogued84711473_rogued
rouged86717323_rouged
rugged94215383_rugged
sagged94120013_sagged
scragged1335823scragged
scrouged1235383scrouged
shagged134210133shagged
slanged94112853slanged
sledged103610313sledged
sloggers10418783sloggers
sloped94216853slo_ped
slopped123511443slopped
sloshed11329823sloshed
slotted84613883slotted
sloughed13305583sloughed
slowed104617073slo_wed
sludged103610343sludged
slugger93610683slugger
snagged104010673snagged
snugged10408033snugged
splodged1333273splodged
sponged1137953sponged
stagged104212083stagged
stodged10377983stodged
stooged94310733stooged
swagged13419153swagged
swigged13327183swigged
tagged93418123_tagged
thonged12376843thonged
togaed84711343_togaed
toggled10428653_toggled
tonged86518903_tonged
trigged10359853trigged
tugged93813523_tugged
twigged13345283twigged
ullaged937033ullaged
vegged124910013_vegged
vogued11457633_vogued
wagged124616123_wagged
wigged124413583_wigged
wronged12397673wronged
zagged183612513_zagged
zigged184110193_zigged

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 Filter1786911340270.296603685.8
2DLD Change Limit1340274218.34616058.8
3Display Results4214210.1403007.1
 (SQL Overall)1786914218.78220347.4
 
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.