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

233 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
puzzled1828665(None) 
guzzled17326261guzzled
muzzled18267751muzzled
nuzzled16276391nuzzled
puzzle16318601puzzle_
puzzler17276961puzzler
puzzles17318971puzzles
buzzed17408472buzz_ed
dazzled1735032dazzled
fizzled19357272fizzled
fuzzed18479252fuzz_ed
guzzle15297912guzzle_
guzzler16286562guzzler
guzzles16328042guzzles
huzzaed1943102huzzaed
mizzled18327632mizzled
muzzle16319392muzzle_
muzzler17257942muzzler
muzzles17299682muzzles
nuzzle14298082nuzzle_
nuzzler15296492nuzzler
nuzzles15298122nuzzles
pizzle16279492pizzle_
pizzles17329272pizzles
puddled123011192puddled
puled84926522pu__led
pulled94322192pu_lled
pungled114210082pungled
purfled13248732purfled
purled94520752pu_rled
purpled12299782purpled
putzed18409112putz_ed
puzzledly2361172puzzledly
puzzlers18295142puzzlers
sizzled16367882sizzled
sozzled16265182sozzled
unpuzzled2042252unpuzzled
zizzled15315852zizzled
bemuzzled2262153bemuzzled
bubbled113612123bubbled
buckled164411883buckled
bugled104918133bu_gled
bulled94626493bu_lled
bumbled144113043bumbled
bundled114011303bundled
bungled114112243bungled
burbled124312673burbled
burgled115511423burgled
burled94825383bu_rled
bustled104011523bustled
butled94818603bu_tled
buzzard1844273buzzard
buzzer16379113buzz_er
buzzes165011173buzz_es
cuddled124110763cuddled
culled94022473cu_lled
cupeled1257793cupeled
curdled113910663curdled
curled95021653cu_rled
cuttled10319933cuttled
dazzle1536853dazzle_
dazzler1634713dazzler
dazzles1636413dazzles
dizzied17236133dizzied
drizzled18284573drizzled
dueled84813663du_eled
duelled9359753duelled
dulled84719423du_lled
fezzed18398243fezz_ed
fizzed18369443fizz_ed
fizzle17369713fizzle_
fizzles18339063fizzles
foozled20346893foozled
frazzled20303993frazzled
frizzled20325703frizzled
fuddled13309393fuddled
fueled104913603fu_eled
fuelled11369193fuelled
fugled114813693fu_gled
fulled103820653fu_lled
fumbled153710493fumbled
furled104717053fu_rled
futzed19418983futz_ed
fuzed185415253fu_z_ed
fuzzes175412253fuzz_es
fuzzier18256523fuzzier
grizzled18334893grizzled
guggled11338563guggled
guiled84315383gu_iled
gulled84521373gu_lled
gurgled10399123gurgled
guttled9378993guttled
guzzlers17274863guzzlers
huddled13349783huddled
hulled103920013hu_lled
humbled153711813humbled
hurdled12379833hurdled
hurled104617453hu_rled
hurtled11339593hurtled
hustled113210133hustled
huzzahed2341503huzzahed
jazzed22416293jazz_ed
juggled17348653juggled
jumbled19379963jumbled
jungled16349643jungled
justled15338093justled
lulled74516443lu_lled
mizzle16279993mizzle_
mizzles17329493mizzles
muddled124111593muddled
muffled16377783muffled
muled85824433mu__led
mulled94721553mu_lled
mumbled143010763mumbled
muraled10410833muraled
muscled1237783muscled
muzzier17326553muzzier
muzzlers18245203muzzlers
nozzle14236633nozzle_
nozzles15276303nozzles
nudzhed2141823nudzhed
nulled74318273nu_lled
nurled74016233nu_rled
nuzzlers16244753nuzzlers
outled74020343ou_tled
paddled123612023paddled
paled85538723p__aled
palled94625163p_alled
paneled10612573paneled
parled94626293p_arled
paroled104217633paroled
pealed95322813p_ealed
pearled10411553pearled
pebbled1445403pebbled
pedaled113711893pedaled
peddled123410543peddled
peeled94119713p_eeled
peopled1238513peopled
periled10316323periled
pestled102711453pestled
petaled103614153petaled
pettled103611513pettled
pickled164011883pickled
piddled123311253piddled
piffled16366403piffled
piled85232993p__iled
pilled94222753p_illed
pimpled14289193pimpled
pled75231433p___led
poled84934843p__oled
polled94022003p_olled
pooled94619813p_ooled
poppled11339243poppled
pozole1758913pozole_
pozoles1839063pozoles
prilled104713003prilled
prized184415393priz_ed
prowled13309913prowled
puddle103914153puddle_
puddler112910753puddler
puddles113613823puddles
puffed153510603pu_ffed
pugged114314533pu_gged
puked124716223pu__ked
pule65040953pu__le_
puler74826623pu__ler
pules74538813pu__les
puller83820813pu_ller
pullet84026333pu_llet
pulley113713403pu_lley
pulped114612533pu_lped
pulsed94013723pu_lsed
pumiced1435173pumiced
pummeled1543373pummeled
pumped133915563pu_mped
punched153512173punched
pungle94413573pungle_
pungles104013713pungles
punned93416193pu_nned
punted94618713pu_nted
pupated12319353pupated
pupped105013273pu_pped
pureed95017813pu_reed
purfle112511183purfle_
purfler12248733purfler
purfles122511853purfles
purged104918263pu_rged
purple102712683purple_
purpler11289273purpler
purples112712833purples
purred94218073pu_rred
pursed95220883pu_rsed
pursued10388133pursued
pushed125017463pu_shed
pusley11379613pu_sley
pussley12375123pussley
pustuled1134953pustuled
putted94220253pu_tted
puttied103811163puttied
putzes174212523putz_es
puzzling19225393puzzling
quailed1737823quailed
quelled17279273quelled
quilled17329283quilled
quizzed2534043quizzed
razzed15478283razz_ed
rubbled124611623rubbled
ruckled144111033ruckled
ruddled103010873ruddled
ruffled14369153ruffled
ruled65822523ru__led
rumbled124514593rumbled
rumpled123810013rumpled
runkled12399013runkled
rustled83311323rustled
sizzle14309613sizzle_
sizzler15266863sizzler
sizzles15349633sizzles
suckled144212513suckled
suppled1248463suppled
swizzled2053013swizzled
teazled17326833teazled
touzled17367153touzled
tumbled123412243tumbled
turtled8309683turtled
tussled835413tussled
unled64021073_u_nled
unmuzzled2062063unmuzzled
unpuzzle1842303unpuzzle_
unpuzzles1941823unpuzzles
uppiled12216593uppiled
zizzle13247313zizzle_
zizzles14307093zizzles

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.406440125.6
2DLD Change Limit1340272338.46615831.2
3Display Results2332330.0802912.5
 (SQL Overall)1786912338.95219961.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.