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

136 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
grizzled1833489(None) 
drizzled18284571drizzled
frizzled20325701frizzled
grizzle16306111grizzle_
grizzler17335031grizzler
grizzles17286191grizzles
drizzle16285912drizzle_
drizzles17295292drizzles
fizzled19357272_fizzled
frazzled20303992frazzled
frizzed19375972frizz_ed
frizzle18367042frizzle_
frizzler19345842frizzler
frizzles19297282frizzles
griddled1244202griddled
grilled94012832gri_lled
grizzlers18253232grizzlers
grizzlier18112452grizzlier
grizzlies18123192grizzlies
grizzly19354472grizzl_y
guzzled17326262g_uzzled
mizzled18327632_mizzled
sizzled16367882_sizzled
swizzled2053012swizzled
zizzled15315852_zizzled
ariled75620323ari__led
bridled113611143bri_dled
brindled12407853brindled
bristled11187343bristled
brittled11186093brittled
cribbled15305803cribbled
crimpled15366933crimpled
crinkled15357153crinkled
crippled15336793crippled
dazzled1735033_dazzled
dizzied17236133_dizzied
dribbled14376593dribbled
drilled94711673dri_lled
driveled1374973driveled
drizzlier18122303drizzlier
drizzly19364553drizzl_y
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
giggled114010073g_iggled
gilled84521633g_i_lled
girdled10217453g_irdled
gizzard17114203g_izzard
glitzed18375493glitz_ed
grabbled14327373grabbled
grappled14336093grappled
graveled13417363graveled
grazed174115913gr_az_ed
gribble12297273gribble_
gribbles13307363gribbles
gridded11387583gri_dded
griddle1035503griddle_
griddles1145753griddles
grided95117043gri__ded
grieved1235283gri_eved
grifted12379583gri_fted
grille74315743gri_lle_
griller84513353gri_ller
grilles83715023gri_lles
grimaced1463313grimaced
grimed104714093gri__med
grinded104210633gri_nded
grinned9378553gri_nned
griped104114713gri__ped
gripped13419343gri_pped
gripple12416613gripple_
gristle8169223gristle_
gristles9189203gristles
gritted94110903gri_tted
grizzliest19152823grizzliest
grizzling1942843grizzling
groveled13345453groveled
growled12278173gr_owled
grueled937133gr_ueled
gruelled1034893gruelled
grumbled14256753grumbled
gruntled10274943gruntled
guiled84315383gui__led
guzzle15297913g_uzzle_
guzzler16286563g_uzzler
guzzles16328043g_uzzles
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.423422437.4
2DLD Change Limit1461621366.73321708.3
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.21924752.9
 
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.