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

130 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
drizzled1828457(None) 
drizzle16285911drizzle_
drizzles17295291drizzles
frizzled20325701frizzled
grizzled18334891grizzled
dazzled1735032d_azzled
dizzied17236132d_izzied
dribbled14376592dribbled
drilled94711672dri_lled
driveled1374972driveled
drizzlier18122302drizzlier
drizzly19364552drizzl_y
fizzled19357272_fizzled
frazzled20303992frazzled
frizzed19375972frizz_ed
frizzle18367042frizzle_
frizzler19345842frizzler
frizzles19297282frizzles
grizzle16306112grizzle_
grizzler17335032grizzler
grizzles17286192grizzles
mizzled18327632_mizzled
sizzled16367882_sizzled
swizzled2053012swizzled
zizzled15315852_zizzled
ariled75620323ari__led
bridled113611143bri_dled
brindled12407853brindled
bristled11187343bristled
brittled11186093brittled
cribbled15305803cribbled
crimpled15366933crimpled
crinkled15357153crinkled
crippled15336793crippled
dazzle1536853d_azzle_
dazzler1634713d_azzler
dazzles1636413d_azzles
dialed84716453d_i_aled
dialled9510133d_ialled
dibbled133510843d_ibbled
diddled114212053d_iddled
dilled84122223d_i_lled
dimpled132810303d_impled
dindled104412723d_indled
dirled84514903d_i_rled
dizened18267333d_izened
dizzier16317543d_izzier
dizzies16279753d_izzies
doiled84817293doi__led
drabbled14367053drabbled
draggled1254673draggled
drawled12368343dr_awled
dribbed13326753dri_bbed
dribble12368603dribble_
dribbler13316313dribbler
dribbles13348393dribbles
dribblet13347543dribblet
driblet103712243dri_blet
dried75321383dri___ed
drifted12367953dri_fted
driller84311883dri_ller
dripped13408083dri_pped
driveler1284693driveler
drivelled1443983drivelled
drizzliest19122533drizzliest
drizzling1943023drizzling
drolled93810223dr_olled
drooled9369203dr_ooled
drumbled14266033drumbled
dwindled14385023dwindled
fizzed18369443_fizz_ed
fizzle17369713_fizzle_
fizzles18339063_fizzles
frazzle18305223frazzle_
frazzles19284813frazzles
fribbled16305743fribbled
frilled113911603fri_lled
frivoled1534043frivoled
frized193510683fri_z_ed
frizzer18446893frizz_er
frizzes18338183frizz_es
frizzier19284813frizzier
frizzies19315933frizzies
frizzlers20293673frizzlers
frizzlier20122883frizzlier
frizzly21455793frizzl_y
griddled1244203griddled
grilled94012833gri_lled
grizzlers18253233grizzlers
grizzlier18112453grizzlier
grizzlies18123193grizzlies
grizzly19354473grizzl_y
guzzled17326263_guzzled
mizzle16279993_mizzle_
mizzles17329493_mizzles
muzzled18267753_muzzled
nuzzled16276393_nuzzled
pizzle16279493_pizzle_
pizzles17329273_pizzles
prickled17358073prickled
prilled104713003pri_lled
prized184415393pri_z_ed
puzzled18286653_puzzled
quizzed2534043quizz_ed
razzed15478283_razz_ed
riddled103012043_riddled
riffled14338603_riffled
rifled104115003_ri_fled
riled65833253_ri__led
rilled74525653_ri_lled
rimpled123311423_rimpled
rippled123110273_rippled
rivaled1138933_rivaled
sizzle14309613_sizzle_
sizzler15266863_sizzler
sizzles15349633_sizzles
sozzled16265183_sozzled
swizzle1854103swizzle_
swizzler1963223swizzler
swizzles1953783swizzles
trickled152610433trickled
trifled113711963tri_fled
trilled84116313tri_lled
trindled10388693trindled
tripled104113833tri_pled
whizzed2234063whizz_ed
wriggled14284663wriggled
wrinkled16275353wrinkled
zizzle13247313_zizzle_
zizzles14307093_zizzles

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621307.00020880.3
3Display Results1301300.0632063.5
 (SQL Overall)1786911307.48323879.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.