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

220 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
guzzled1732626(None) 
guzzle15297911guzzle_
guzzler16286561guzzler
guzzles16328041guzzles
muzzled18267751muzzled
nuzzled16276391nuzzled
puzzled18286651puzzled
buzzed17408472buzz_ed
dazzled1735032dazzled
fizzled19357272fizzled
fuzzed18479252fuzz_ed
grizzled18334892grizzled
guggled11338562guggled
guiled84315382gu_iled
gulled84521372gu_lled
gurgled10399122gurgled
guttled9378992guttled
guzzlers17274862guzzlers
huzzaed1943102huzzaed
mizzled18327632mizzled
muzzle16319392muzzle_
muzzler17257942muzzler
muzzles17299682muzzles
nuzzle14298082nuzzle_
nuzzler15296492nuzzler
nuzzles15298122nuzzles
puzzle16318602puzzle_
puzzler17276962puzzler
puzzles17318972puzzles
sizzled16367882sizzled
sozzled16265182sozzled
zizzled15315852zizzled
bemuzzled2262153bemuzzled
bubbled113612123bubbled
buckled164411883buckled
bugled104918133bu_gled
bulled94626493bu_lled
bumbled144113043bumbled
bundled114011303bundled
bungled114112243bungled
burbled124312673burbled
burgled115511423burgled
burled94825383bu_rled
bustled104011513bustled
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
gabbled134112453gabbled
gabled105518453g_abled
gaggled11359913gaggled
galled84622863g_alled
gambled134112163gambled
gaoled84814503g_aoled
garbled114512803garbled
gargled104210673gargled
gaveled12399133gaveled
gazed165520333g_az_ed
gelled84718893g_elled
gentled9389093gentled
giggled114010073giggled
gilled84521633g_illed
girdled10217453girdled
gizzard17114203gizzard
glazed174711773glaz_ed
gled65631143g___led
glozed173711223gloz_ed
gnarled9287723gnarled
goaled85014363g_oaled
gobbled134010253gobbled
goggled11348953goggled
grazed174115913graz_ed
grilled94012833grilled
grizzle16306113grizzle_
grizzler17335033grizzler
grizzles17286193grizzles
growled12278163growled
grueled937133grueled
gruelled1034893gruelled
grumbled14256753grumbled
gruntled10274943gruntled
guarded1036153guarded
guessed9176603guessed
guested9157713guested
guggle94110433guggle_
guggles103410543guggles
guglet84018223gu_glet
guided94014113gu_ided
guild75312753gu_il_d
guile64521133gu_ile_
guiles73919283gu_iles
guised84612173gu_ised
gules64831043gu__les
gulfed114810013gu_lfed
gullet74924833gu_llet
gulley104213163gu_lley
gullied93812063gullied
gulped104610373gu_lped
gummed123811663gu_mmed
gumweed1433943gumweed
gunned83513093gu_nned
gurged95513363gu_rged
gurgle83912473gurgle_
gurgles94312873gurgles
gurglet94412033gurglet
gushed114816243gu_shed
gussied9267193gussied
gusted84316723gu_sted
gutted84716363gu_tted
guttle74111973guttle_
guttler8369163guttler
guttles83011933guttles
guyed1049893gu__yed
guzzling18225063guzzling
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
pizzle16279493pizzle_
pizzles17329273pizzles
puddled123011193puddled
puled84926523pu__led
pulled94322193pu_lled
pungled114210083pungled
purfled13248723purfled
purled94520743pu_rled
purpled12299763purpled
putzed18409113putz_ed
puzzledly2361163puzzledly
puzzlers18295143puzzlers
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
unpuzzled2042253unpuzzled
zizzle13247313zizzle_
zizzles14307093zizzles

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 Filter1786911340270.263679433.5
2DLD Change Limit1340272207.09318895.7
3Display Results2202200.0932365.6
 (SQL Overall)1786912207.44923988.6
 
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.