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

261 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
mizzled1832763(None) 
fizzled19357271fizzled
mizzle16279991mizzle_
mizzles17329491mizzles
muzzled18267751muzzled
sizzled16367881sizzled
zizzled15315851zizzled
dazzled1735032dazzled
dizzied17236132dizzied
drizzled18284572drizzled
fizzed18369442fizz_ed
fizzle17369712fizzle_
fizzles18339062fizzles
frizzled20325702frizzled
grizzled18334892grizzled
guzzled17326262guzzled
miauled1036662miauled
middled123311892middled
milled94326172mi_lled
mingled113612732mingled
misled94719312mi_sled
mispled12310462mispled
mizzen16447952mizz_en
mizzly19256102mizzl_y
muzzle16319392muzzle_
muzzler17257942muzzler
muzzles17299682muzzles
nuzzled16276392nuzzled
pizzle16279492pizzle_
pizzles17329272pizzles
puzzled18286652puzzled
sizzle14309612sizzle_
sizzler15266862sizzler
sizzles15349632sizzles
sozzled16265182sozzled
swizzled2053012swizzled
zizzle13247312zizzle_
zizzles14307092zizzles
ailed66240283ai__led
aisled74516183ai_sled
bemuzzled2262153bemuzzled
billed94224903bi_lled
birled94416993bi_rled
bizzes163910843bizz_es
buzzed17408473buzz_ed
circled1237583circled
dazzle1536853dazzle_
dazzler1634713dazzler
dazzles1636413dazzles
dialed84716453di_aled
dialled9510133dialled
dibbled133510843dibbled
diddled114212053diddled
dilled84122223di_lled
dimpled132810303dimpled
dindled104412723dindled
dirled84514903di_rled
dizened18267333dizened
dizzier16317543dizzier
dizzies16279753dizzies
drizzle16285913drizzle_
drizzles17295293drizzles
embezzled2241733embezzled
fezzed18398243fezz_ed
fiddled13329633fiddled
filed95331903fi__led
filled104922263fi_lled
fizzer17369383fizz_er
fizzes174512553fizz_es
fizzier18326713fizzier
foozled20346893foozled
frazzled20303993frazzled
frizzed19375973frizz_ed
frizzle18367043frizzle_
frizzler19345843frizzler
frizzles19297283frizzles
fuzzed18479253fuzz_ed
giggled114010073giggled
gilled84521633gi_lled
girdled10217453girdled
gizzard17114203gizzard
grizzle16306113grizzle_
grizzler17335033grizzler
grizzles17286193grizzles
guzzle15297913guzzle_
guzzler16286563guzzler
guzzles16328043guzzles
higgled13339073higgled
hilled104022223hi_lled
hirpled13157133hirpled
hirsled11118113hirsled
huzzaed1943103huzzaed
idled74915213_i_dled
impaled12288503impaled
impled113812503_impled
isled64615993_i_sled
izzard15135243_izzard
jazzed22416293jazz_ed
jiggled17358843jiggled
jingled164111063jingled
kibbled16367983kibbled
killed113918773ki_lled
kindled133410543kindled
kirtled12287033kirtled
kittled12388193kittled
libeled10249413libeled
mackled164111913mackled
macled116718113m_acled
maculed123510053maculed
mailed95326753m_ailed
malled94626103m_alled
mangled113615253mangled
mantled104113393mantled
marbled123212113marbled
marled95523163m_arled
mauled94817823m_auled
mazed175523873m_az_ed
mazzard1844463mazzard
measled10339303measled
medaled113411603medaled
meddled123210023meddled
melled95023023m_elled
metaled102913873metaled
mettled103510543mettled
mewled123710053m_ewled
miaoued1034583miaoued
miaowed1333883miaowed
miched143913393mi_ched
mickle143715133mickle_
mickler153310233mickler
mickles153415003mickles
middle103414983middle_
middler112712273middler
middles113415303middles
midleg1038553mi_dleg
miffed15398713mi_ffed
miggle104012113miggle_
miggles113512033miggles
miked125020453mi__ked
mild75330843mi__l_d
milded104416153mi_lded
mile66352563mi__le_
miler75733063mi__ler
miles74645073mi__les
milked134612573mi_lked
mille75029133mi_lle_
miller84625413mi_ller
milles84526563mi_lles
millet84030743mi_llet
milted93919943mi_lted
mimed105622733mi__med
mimeoed1235193mimeoed
minced114114913mi_nced
minded103817833mi_nded
mined85333353mi__ned
mingle93518783mingle_
mingler104213833mingler
mingles103719003mingles
minored10310103minored
minted94220583mi_nted
minuted10329503minuted
mired85729223mi__red
miscued1239293miscued
misdeed113211053misdeed
misfed124113023mi_sfed
misfeed13389683misfeed
misfiled14278653misfiled
mislead10419973mi_slead
misplead1345023misplead
misruled1137083misruled
missed94423603mi_ssed
misted93625823mi_sted
misused104111273misused
mitered103213233mitered
mitred94414343mi_tred
mixed155717253mi__xed
mizen164815273mi_z_en
mizzens17366123mizzens
mizzling19255443mizzling
mobled113213183m_obled
modeled1139453modeled
moguled1135923moguled
moiled94318863m_oiled
mottled10409973mottled
muddled124111583muddled
muffled16377783muffled
muled85824433m__uled
mulled94721553m_ulled
mumbled143010763mumbled
muraled10410823muraled
muscled1237783muscled
muzzier17326553muzzier
muzzlers18245203muzzlers
nibbled12389073nibbled
nickled144010443nickled
niggled10319203niggled
nilled73919453ni_lled
nippled12307643nippled
nozzle14236633nozzle_
nozzles15276303nozzles
nuzzle14298083nuzzle_
nuzzler15296493nuzzler
nuzzles15298123nuzzles
oiled64429473oi__led
pickled164011883pickled
piddled123311253piddled
piffled16366403piffled
piled85232993pi__led
pilled94222753pi_lled
pimpled14289183pimpled
puzzle16318603puzzle_
puzzler17276963puzzler
puzzles17318973puzzles
quizzed2534043quizz_ed
razzed15478283razz_ed
riddled103012043riddled
riffled14338603riffled
rifled104115003ri_fled
riled65833253ri__led
rilled74525653ri_lled
rimpled123311423rimpled
rippled123110273rippled
rivaled1138933rivaled
sickled144713433sickled
sidled84215173si_dled
singled93914683singled
sized155519243si_z_ed
sizzlers16274753sizzlers
smiled93716433smi__led
swizzle1854103swizzle_
swizzler1963223swizzler
swizzles1953783swizzles
teazled17326833teazled
tickled144313133tickled
tiled64832943ti__led
tilled74722953ti_lled
tingled93712793tingled
tinkled123910473tinkled
tippled12358393tippled
tirled74714363ti_rled
titled73815003ti_tled
tizzies15287893tizzies
touzled17367153touzled
unmuzzled2062063unmuzzled
vialed105112593vi_aled
vialled1156843vialled
vittled11347343vittled
vizored2034133vizored
whizzed2234063whizz_ed
widdled133511233widdled
wiggled13299603wiggled
wiled95231553wi__led
willed104722453wi_lled
wimbled15298143wimbled
wimpled15338823wimpled
windled123713483windled
winkled15299593winkled
wintled11339843wintled
wizened20275423wizened
wizzen17387203wizz_en
wizzes175110773wizz_es

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.1561145455.1
2DLD Change Limit1340272617.43618024.1
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.68523251.9
 
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.