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

407 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
clogger1143880(None) 
blogger11448311blogger
clogged12528651clogged
cloggers12437281cloggers
cloggier1244251cloggier
flogger12449451flogger
logger86420001_logger
slogger94310481slogger
bloggers12397402bloggers
chigger1436002chigger
chugger1445372chugger
clagged12749232clagged
clanger104113492clanger
clinger103812152clinger
clobber13378162clobber
clocker153910872clocker
cloggy1344872clogg_y
cloner84418092clo_ner
closer84918202clo_ser
clouter93511682clouter
clover114617122clo_ver
clowder13367932clowder
codger105814842c_odger
cogged116416612c_ogged
conger95024272c_onger
dogger95216782_dogger
flagger12469342flagger
flogged13528802flogged
floggers13387862floggers
fogger114414772_fogger
hogger114615082_hogger
jogger154713162_jogger
lagger85919832_lagger
lodger86517682_lodger
logged96622942_logged
loggers94616132_loggers
loggier93811142_loggier
logier75015732_logier
longer75823202_longer
lugger83916552_lugger
plugger11378422plugger
progger11319372progger
slogged104910462slogged
sloggers10418782sloggers
slugger93610672slugger
agger76420893__agger
aligner8108313aligner
alleger8319623alleger
bagger104619203_bagger
beclogged1643143beclogged
bigger104315063_bigger
bloater94013423bloater
blocker15419923blocker
blonder104011943blonder
bloomer11419813bloomer
blooper11358533blooper
blotter94612853blotter
blower115316573blo_wer
blowier1248943blowier
bludger11419563bludger
blunger104112013blunger
bogged116019283_bogged
boggier113711583_boggier
boggler113910083_boggler
booger94816553_booger
bragger113810033bragger
bugger104418723_bugger
cadger105013893c_adger
cager85229223c__ager
cagier93715933c_agier
caloyer1238143calo_yer
changer134215543changer
charger133914063charger
chiggers1535553chiggers
choicer14197893choicer
choker154314373cho_ker
chokier1638043chokier
choler113717153cho_ler
chomper163810073chomper
chooser124412963chooser
chopper163611893chopper
chouser125212943chouser
chowder16387803chowder
chugged1584823chugged
chuggers1554853chuggers
clabber134210113clabber
clacker153813773clacker
claimer11279883claimer
clamber133311733clamber
clammer134211793clammer
clamper134012993clamper
clanged114212653clanged
clangers114312343clangers
clangor10426683clangor
clapper134011863clapper
claquer18287343claquer
clasher124615513clasher
clasper113811863clasper
classer93614613classer
clatter94014973clatter
claver113816973cl_aver
clavier1239173clavier
clawer114512783cl_awer
clayier1248323clayier
cleaner93712303cleaner
clearer93710823clearer
cleaver124110803cleaver
clever114611533cl_ever
clicker154111883clicker
climber13449133climber
clinged113310093clinged
clingers113810663clingers
clingier1155853clingier
clinker133811663clinker
clipper133710323clipper
cloaked14368543cloaked
clobbers14397513clobbers
cloche134312373cloche_
cloches144113713cloches
clocked164112833clocked
clockers16369813clockers
cloddier1234063cloddier
clog76123243clo_g__
cloggiest1334723cloggiest
cloggily1543243cloggily
clogging13368503clogging
clogs85519553clo_g_s
cloister1037093cloister
clomped14398973clomped
clone75728163clo_ne_
cloned94518803clo_ned
cloners94514823clo_ners
clones84526563clo_nes
clonked14429563clonked
clopped143611523clopped
cloque17288743cloque_
cloques18268563cloques
close76425223clo_se_
closed95317963clo_sed
closers94415313clo_sers
closes85425593clo_ses
closet85226603clo_set
closure9278473closure
clothe114712993clothe_
clothed134010283clothed
clothes124513813clothes
clothier1335363clothier
clotted104011823clotted
cloture9238453cloture
clouded11348833clouded
cloudier1135053cloudier
clough12539133cloug_h
cloughs13517053cloughs
clour76617283clo__ur
cloured103111543cloured
clouted104212163clouted
clouters10399793clouters
clove105619443clo_ve_
cloven114211513clo_ven
clovers125114663clo_vers
clovery15407403clo_very
cloves114918823clo_ves
clowders14357473clowders
clowned13447723clowned
clownery1633313clownery
cloyed125111563clo_yed
cloze165517543clo_ze_
clozes174915563clo_zes
clubber13319593clubber
clumber134011443clumber
clunker13419453clunker
cluster94013323cluster
clutter94211653clutter
clyster12317453clyster
coaler84121703c_oaler
coater84329553c_oater
coaxer153912783c_oaxer
cobber124116843c_obber
cocker144320393c_ocker
codder104416333c_odder
coder86134213c_o_der
codgers115113923c_odgers
coffer144112863c_offer
coiler84421593c_oiler
coiner84323783c_oiner
colder95121833c_older
colleger11227923colleger
collier93618153collier
cologne1039353cologne_
cologned1237153cologned
colognes11310603colognes
colorer9312523colorer
colourer1037553colourer
colter84625093c_olter
comber125118503c_omber
comer95832693c_o_mer
confer114018683c_onfer
conge85227593c_onge_
congee96024463c_ongee
congers104223233c_ongers
conges94928173c_onges
conker124721553c_onker
conner84423963c_onner
cooer74831013c_o_oer
cooker124722453c_ooker
cooler84824713c_ooler
cooper104221123c_ooper
cooter85128613c_ooter
coper95336093c_o_per
copier103722893c_opier
copper124321893c_opper
copter109822013c_opter
corder94322873c_order
corer75538873c_o_rer
corker124720853c_orker
corner84625623c_orner
cosher114819903c_osher
cosier84423753c_osier
coster84331293c_oster
cotter84926673c_otter
cougar958783c_ougar
cougher133711733cougher
couter84930203c_outer
cover105430773c_o_ver
cower104531773c_o_wer
cowier113616163c_owier
coyer105222843c_o_yer
cozier173315143c_ozier
cragged12479883cragged
craggier12116063craggier
cringer103514243cringer
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
crowder13389843crowder
crower114117553cro_wer
crowner124012593crowner
crozer175112843cro_zer
crozier18369933crozier
dagger95017293_dagger
defogger1443533defogger
digger94616083_digger
dodger95817043_dodger
dogged106017703_dogged
doggers104413433_doggers
doggery13448263_doggery
doggier103810943_doggier
dragger10309163dragger
eclogue1044503eclogue_
eclogues1144573eclogues
egger74414403__egger
eloigner943423eloigner
eloiner7149183eloiner
eloper85414153elo_per
flagged13459633flagged
flaggers13328073flaggers
flaggier13105203flaggier
flanger113412623flanger
flinger113710513flinger
floater104413353floater
flooder11258463flooder
floorer10248073floorer
flopper14328473flopper
flosser10339693flosser
flouter104311343flouter
flower124815503flo_wer
fogged125518373_fogged
foggers124112013_foggers
foggier12349913_foggier
forger104820763_forger
frogged13408493frogged
froggier1354643froggier
gagger95016513_gagger
gloater83711013gloater
glogg837353glogg__
gloggs935033glogg_s
glosser83410813glosser
glover104513533glo_ver
glower105114933glo_wer
glugged11396613glugged
goggler10379323_goggler
gorger86116983_gorger
gouger86014363_gouger
groggery1433513groggery
groggier1134343groggier
hogged125817773_hogged
hoggers124512483_hoggers
hogget114715763_hogget
hugger114713123_hugger
jagger154016003_jagger
jigger155313053_jigger
jogged166015923_jogged
joggers164110693_joggers
joggler16398833_joggler
kegger12388063_kegger
laager74312783_laager
lager65132863_l_ager
lagged95520133_lagged
laggers94216243_laggers
larger74417513_larger
ledger85914363_ledger
leger65721503_l_eger
legged95713083_legged
leggier9368233_leggier
liger65024473_l_iger
linger75226003_linger
loader74316303_loader
loafer93610943_loafer
loaner64416503_loaner
lobber104016603_lobber
locker124019423_locker
lodge76520083_lodge_
lodged913815703_lodged
lodgers95113833_lodgers
lodges86820143_lodges
lofter94614723_lofter
loge56837193_lo_ge_
loges66534203_lo_ges
loggets9378913_loggets
loggia8457053_loggia
loggie84011993_loggie
loggy105714193_logg_y
loiter64619173_loiter
loller63315283_loller
loner55431043_lo_ner
longe66626463_longe_
longed87121373_longed
longers84819543_longers
longes75925573_longes
looker104816953_looker
looper83817113_looper
looser65219943_looser
looter64222323_looter
loper75129233_lo_per
lopper103717203_lopper
loser54728673_lo_ser
lotter64025603_lotter
louder74414603_louder
lounger84610213_lounger
louver94110393_louver
lover85526453_lo_ver
lower85830413_lo_wer
luger65322083_l_uger
lugged94417053_lugged
luggers93713483_luggers
lunger75720423_lunger
mogged115215393_mogged
monger94418333_monger
mugger103914703_mugger
nagger84016123_nagger
nigger89713573_nigger
nogged95716333_nogged
ogler65917443__ogler
ologies8615023ologies
plaguer10328273plaguer
pledger11359153pledger
plodder1146003plodder
plotter94113663plotter
plougher14214463plougher
plover115312613plo_ver
plower114315063plo_wer
plugged12408033plugged
pluggers12297023pluggers
plunger104211233plunger
progged12409793progged
proggers12258163proggers
rigger85616713_rigger
roger64521413_ro_ger
rugger84414513_rugger
sagger84321073_sagger
scroggier1343133scroggier
shogged13397953shogged
slagged104312763slagged
slaggier10126953slaggier
slinger83413833slinger
slobber11388903slobber
sloper84615913slo_per
slotter73314443slotter
slower94016153slo_wer
slugged104410373slugged
sluggers10348483sluggers
smoggier1243973smoggier
smugger11327053smugger
snigger9328373snigger
snogged10417973snogged
snugger9318313snugger
sogged95518523_sogged
soggier93410883_soggier
sponger1038523sponger
stagger94212383stagger
swagger12389333swagger
swigger12338453swigger
tagger84017693_tagger
togged95117513_togged
toggery12505923_toggery
toggler9399193_toggler
tonger74719683_tonger
trigger9329153trigger
tugger84013103_tugger
unclogged1443933unclogged
voguer10468403_voguer
wagger113616013_wagger
wronger11288823wronger

Search took 7 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.1561145455.1
2DLD Change Limit1340274076.33021173.3
3Display Results4074070.1562609.0
 (SQL Overall)1786914076.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.