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

354 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
maddest11231121(None) 
baddest112611141baddest
haddest122711991haddest
saddest92412381saddest
addrest958632_addrest
baldest102313532baldest
faddiest1338112faddiest
faddist12289642faddist
gladdest11145842gladdest
hardest113118412hardest
madded113513552madde_d
madden103912522madde_n
maddens11359752maddens
madder103515592madde_r
madders113513212madders
maddish14289482maddish
madness10310072madness
madres93718182madres_
matiest92522452matiest
mayest114614792ma_yest
maziest183613872maziest
mildest102812062mildest
modest93818452m_odest
muddiest12298732muddiest
oddest81710862_oddest
reddest9311952reddest
ablest84721833_ablest
added84918433_adde_d
addend9458453_addend
adder75419593_adde_r
adders84315703_adders
addict10711203_addict
addles84216603_addles_
address956103_address
adds67622453_add_s_
adduct1087373_adduct
adept81219643_a_dept
adjust1447183_adjust
adust64117453_a_dust
advect12309123_advect
advent102613753_advent
advert103215783_advert
adzes155913803_adzes_
aedes64625153_aedes_
aides65336603_aides_
airest63825263_airest
amides95722663amides_
amidst94913233amid_st
amplest11312333amplest
aptest82917513_aptest
ardent73022613_ardent
aridest8316143aridest
arrest63722633_arrest
attest62618613_attest
auldest839893auldest
babiest114414753babiest
badder103817513badde_r
baddies114017873baddies_
badges103917373badges_
badness1039573badness
bardes95026933bardes_
barest85327693ba_rest
basest84720493ba_sest
bawdiest14398673bawdiest
beadiest113815533beadiest
blandest113811043blandest
boldest102613063boldest
caddies113718383caddies_
caddis104613383caddis_
caddish143810123caddish
cadent94120363ca_dent
cades85440733ca_des_
cadet85339343ca_de_t
cadets96316513ca_dets
cadges104716713cadges_
cadres94017933cadres_
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
candent10417363candent
candidest1346533candidest
coldest102514763coldest
crudest104510333crudest
dadaist9310103dadaist
daddies103414943daddies_
daddles104213803daddles_
dadoes85616533dadoes_
daftest11248943daftest
damndest1276003damndest
dampest12411043dampest
dandiest103415033dandiest
dankest122611673dankest
darkest122512623darkest
darndest1067223darndest
deadest93014883deadest
doest65829523__doest
drest65530343__drest
earnest7318733earnest
easiest72318773easiest
eldest72912683_eldest
fabbest1438033fabbest
faddish15359003faddish
faddism14356723faddism
faddists13235543faddists
fades94932863fa_des_
fadges114814033fadges_
fainest10417703fainest
fairest10412293fairest
falsest10310013falsest
fastest102413723fastest
fattest102913063fattest
fondest11312403fondest
gabfest1336453gabfest
gadded103913173gadde_d
gadder93714713gadde_r
gadders103611503gadders
gaddis94211373gaddis_
gadget93616183gadge_t
gadgets10348683gadgets
gamest94919923ga_mest
gamiest102816223gamiest
gashest114813413gashest
gaudiest1039393gaudiest
gayest104314333ga_yest
giddiest11298553giddiest
gladiest101710333gladiest
goddess1035263goddess
goldest92411173goldest
grandest10311573grandest
hades96035113ha_des_
hadjes175210403hadjes_
hadst93220223ha_d_st
halest94823273ha_lest
handiest123417773handiest
handset113016823handset
hardiest123416333hardiest
hardset113415833hardset
harvest132112753harvest
haziest193313003haziest
headiest123015553headiest
headrest122910203headrest
idlest74014863_idlest
immodest1344543immodest
jades135222113ja_des_
kaddish16317973kaddish
kindest12311503kindest
laciest93819033laciest
ladder84617623ladde_r
ladders94115173ladders
laddies93715053laddies_
laddish12299723laddish
lades65141273la_des_
ladies75124883ladies_
ladles74619543ladles_
lakiest113517263lakiest
lamest84722763la_mest
lankest112714113lankest
lardiest93813883lardiest
largest83715103largest
latest63822703la_test
laxest134913363la_xest
laziest163814473laziest
leadiest93314983leadiest
lewdest1136283lewdest
loudest839933loudest
mabes96331533ma_bes_
maces97139963ma_ces_
maches134827233maches_
macles107023223macles_
madames12310063madames_
madams11310943madams_
maddened1334893maddened
madding123711993madding
made75440243ma_de__
madmen113511743madme_n
madras94316433madras_
madrasa10387883madrasa
madre85720173madre__
mads76845373ma_d_s_
madwort13611363madwort
maes66948403ma__es_
mages85036023ma_ges_
magnet9320663magne_t
magnets10311143magnets
mahoes11313103mahoes_
maiden93512283maide_n
maidens10349663maidens
maidish13239553maidish
maids86327143maid_s_
mailes84329113mailes_
maist75535683ma__ist
maizes175115733maizes_
majesty1943503ma_jesty
makes115336853ma_kes_
males75049793ma_les_
mallet84433053malle_t
mallets93318493mallets
malmiest123211023malmiest
maltiest102916193maltiest
mamies104626243mamies_
mammet94319253mamme_t
mammets103911113mammets
manes76648963ma_nes_
manges94628943manges_
mangiest112815903mangiest
manifest1339503manifest
manless93012933manless
manliest102314943manliest
manses84225513manses_
mantes84430783mantes_
maples104819423maples_
mares76457633ma_res_
margent10316693margent
marges94525713marges_
market123226043marke_t
markets133314033markets
marliest102415183marliest
marses84827113marses_
mashes115030003mashes_
masses85028713masses_
massiest103314423massiest
mast65959963ma___st
mates75251363ma_tes_
matless93014043matless
matres84522233matres_
mattes85624533mattes_
maturest1039693maturest
mauds85519273maud_s_
maumet103518883maume_t
maumets11369693maumets
mauves113811553mauves_
mavies114923193mavies_
maxes145629533ma_xes_
maybes1339243maybes_
mayst106622673ma__yst
mazes165632173ma_zes_
mealiest102215973mealiest
meanest9315703meanest
meatiest102816793meatiest
meddles113213253meddles_
meekest1336893meekest
merdes94518603merdes_
merest84725113m_erest
midden104112853midde_n
middens11379383middens
middies113116153middies_
middles113415303middles_
midges103516483midges_
midget103718453midge_t
midgets113910253midgets
midlist10312513midlist
midmost1246153midmost
midst85922553m_id_st
mindset10313343mindset
miriest93619823miriest
mirkest13309723mirkest
mitiest93520053mitiest
modes85537413m_odes_
modesty13476983m_odesty
moldiest11249693moldiest
molest85022743m_olest
mondes94322353mondes_
moodiest112712183moodiest
mopiest113014293mopiest
mordent10313993mordent
mostest9314793mostest
mudded114511383mudde_d
mudder104413493mudde_r
mudders113211113mudders
muddies113513953muddies_
muddles112914353muddles_
murkest133110203murkest
mutest84218053m_utest
naivest10309473naivest
nakedest1345473nakedest
nudest74113833_nudest
oakiest112913923oakiest
oldest72114093_oldest
paciest112917803paciest
padded114113503padde_d
padder103415493padde_r
padders113312873padders
paddies113715723paddies_
paddles113515643paddles_
padles95221123padles_
padres95016983padres_
palest83926223pa_lest
paliest93021603paliest
pandect12310953pandect
raciest92820013raciest
radded94716493radde_d
raddles93615703raddles_
randiest93418773randiest
rankest112713813rankest
rapidest1138543rapidest
rarest65725483ra_rest
rashest103916873rashest
rawest93615063ra_west
readiest93719043readiest
ruddiest10278543ruddiest
rudest74016313_rudest
sadden83212403sadde_n
saddens9309603saddens
sadder82916973sadde_r
saddles95415743saddles_
sades65239893sa_des_
sadhes104715373sadhes_
sadist74221353sa_dist
sadness8310613sadness
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saltest71916513saltest
sandiest93218683sandiest
sanest64426693sa_nest
sawdust1154533sawdust
sayest94217743sa_yest
shadiest121711273shadiest
smallest1039403smallest
smartest10310183smartest
snidest8310913snidest
staidest939803staidest
tallest7317093tallest
tamest85721293ta_mest
tannest72617853tannest
tardiest93515243tardiest
tartest72517533tartest
tautest72612443tautest
tidiest83514873tidiest
undrest8313013undrest
vaguest1137333vaguest
vainest10315763vainest
vastest102911513vastest
wackest164710863wackest
wadded124014173wadde_d
wadder114215483wadde_r
wadders123812443wadders
waddies124214753waddies_
waddles124314843waddles_
wades95634143wa_des_
wadies105121203wadies_
wadset10314303wadse_t
wadsets1136443wadsets
waniest103819113waniest
wannest103915003wannest
wariest105122503wariest
warmest123113033warmest
wattest102412153wattest
waviest134513073waviest
waxiest173510883waxiest
widest104517003_widest
wildest113311273wildest
yarest95018913ya_rest
zaniest163214773zaniest

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.406440125.6
2DLD Change Limit1340273546.51620568.9
3Display Results3543540.1402528.6
 (SQL Overall)1786913547.06225303.2
 
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.