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

542 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
madness1031007(None) 
badness1039571badness
sadness8310611sadness
baldness1137042baldness
deadness1039232deadness
farness102912202farness
fatness103311292fatness
gayness1136842gayness
gladness1036152gladness
hardness122411082hardness
harness102413932harness
laxness1436042laxness
maddens11359752maddens
madders113513212madders
maddest112311212maddest
madnesses1239832madnesses
madres93718182madre_s
magnets10311142magnets
maleness10312312maleness
manes76648962ma_ne_s
manless93012932manless
manners93417832manners
manses84225512ma_nses
matiness102114752matiness
matless93014042matless
mazedness2194572mazedness
maziness19239542maziness
meanness1037182meanness
mildness1136522mildness
oddness935312oddness
oldness836402oldness
patness92912282patness
rawness1038152rawness
redness82012442redness
waeness102512782waeness
wanness102610682wanness
abbess10509773_abbess
access1037683_access
acidness1136723acidness
acnes75922623_acne_s
adders84315703_adders
address956103address
adeems946333_adeems
adieus739633_adieus
admass957143_admass
adnexa1433673_adnexa
adzes155913803_adze_s
aeneus61111143_aeneus
agedness1036683agedness
aidless83612073aidless
amines84727983amine_s
anes45255933_a_ne_s
apneas83211383_apneas
aptness9268573aptness
aridness939223aridness
assess65710463_assess
avidness1246113avidness
awayness1443303awayness
awless939263_awless
awnless1035923_awnless
badass949293bad_ass
baddest112611143baddest
badgers114812653badgers
badges103917373badge_s
badnesses1239253badnesses
banders104324563banders
bandiness122310243bandiness
banes74945583ba_ne_s
banners94018713banners
bannets94013843bannets
bareness10912813bareness
barless94317003barless
barneys12569563barneys
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
bawdiness15235543bawdiness
beadiness12249233beadiness
bedless1039703bedless
biasness1035813biasness
bigness1038193bigness
blandness1235973blandness
boldness1136973boldness
broadness1256663broadness
budless1038873budless
cades85440733cad_e_s
cadets96316513cad_ets
cadgers114712003cadgers
cadges104716713cadge_s
cadres94017933cadre_s
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
caners84629203ca_ners
canes75350373ca_ne_s
cannels93413363cannels
canners93822663canners
canoness1039393canoness
capless114312763capless
caress85720263ca_ress
carless95118493carless
carnets93918403carnets
carneys124310543carneys
chadless1436403chadless
coldness1137953coldness
coyness1277323coyness
dadoes85616533dadoe_s
daftness1235533daftness
damners104112113damners
dampness1336073dampness
danders93921183danders
dankness13256693dankness
darkness13247343darkness
darnels83710433darnels
darners83815773darners
datedness1187753datedness
dazedness20114963dazedness
deafness1236213deafness
dearness939973dearness
dimness1038843dimness
drabness1135803drabness
dress65319833__dress
dryness11114783dryness
dueness82310123dueness
dulness8307983dulness
dunness8298983dunness
earless74316073earless
earners74016453earners
earnest7318733earnest
earnests837853earnests
easiness8313043easiness
eldress835003eldress
endless839833endless
eyedness1245103eyedness
fadedness1445613fadedness
fadeless12258323fadeless
faders105117463fad_ers
fades94932863fad_e_s
fadges114814033fadge_s
fainest10417703fainest
fairness1136563fairness
fanes84639893fa_ne_s
fanners103914653fanners
fastness11238763fastness
fatless103212203fatless
fawners13388493fawners
fewness1335003fewness
feyness1334923feyness
fitness10299393fitness
flatness1138153flatness
fondness1237213fondness
fulness10248963fulness
gadders103611503gadders
gadgets10348683gadgets
gainers84214593gainers
gainless9117403gainless
gameness112810693gameness
gaminess112911063gaminess
ganders93521703ganders
ganefs10489203ga_nefs
ganevs10456913ga_nevs
gannets83811443gannets
gapless10349993gapless
garners83815983garners
garnets84115403garnets
gasless8319013gasless
gastness9278473gastness
gaudiness1136253gaudiness
goddess1035263goddess
godless938403godless
goodness1036253goodness
grandness1138303grandness
grayness1235933grayness
haddest122711993haddest
hades96035113had_e_s
hadjees18356383hadjees
hadjes175210403hadje_s
haleness11312623haleness
halfness1435563halfness
handers114224333handers
handiness132110933handiness
handless123512063handless
hanses95022633ha_nses
hapless123311333hapless
hardiness132310363hardiness
hatless103813443hatless
haziness20248513haziness
headiness132510363headiness
headless12289863headless
hipness12277383hipness
hotness1038613hotness
humanness1443793humanness
humidness1544023humidness
iciness938863iciness
illness736473illness
jadedness1844693jadedness
jades135222113jad_e_s
jagless1537103jagless
janes124928123ja_ne_s
jawless1745653jawless
kanes95529373ka_ne_s
kidneys1533423kidneys
kindness13236653kindness
laciness102112553laciness
ladders94115173ladders
ladens74516233lad_ens
laders74927763lad_ers
lades65141273lad_e_s
ladies75124883ladie_s
ladlers84613573ladlers
ladles74619543ladle_s
lameness102612673lameness
landers84026213landers
landless94011173landless
lanes54946793la_ne_s
lankness12237043lankness
lanners73618333lanners
largess8408913largess
lateness82614073lateness
lawless1037033lawless
laziness17239983laziness
leadless9248793leadless
leanness837373leanness
lewdness1254173lewdness
lidless8309273lidless
lioness739103lioness
loudness937013loudness
lowness1037813lowness
mabes96331533ma_be_s
macers105321273ma_cers
maces97139963ma_ce_s
maches134827233mache_s
macles107023223macle_s
madames12310063madames
madams11310943mad_ams
madcaps1435243madcaps
madded113513553madde_d
madden103912523madde_n
madder103515593madde_r
maddish14289483maddish
made75440243mad_e__
madmen113511743madme_n
madonnas1143843madonnas
madras94316433mad_ras
madrasa10387883madrasa
madrasas11317763madrasas
madrases112610003madrases
madrassa11274633madrassa
madre85720173madre__
madrones112912283madrone_s
mads76845373mad___s
madtoms1236923madtoms
maduros1036303maduros
maenads1037373maenads
maes66948403ma__e_s
mages85036023ma_ge_s
maglevs1334693maglevs
magnesia1145723magnesia
magnesias1245693magnesias
magnesic1345753magnesic
magnet9320663magne_t
magneto1046743magneto
magnetos1146263magnetos
magnums1234683magnums
magueys1333943magueys
mahoes11313103mahoe_s
maidens10349663maidens
maihems1444303maihems
mailers94420333mailers
mailes84329113maile_s
mailless10248583mailless
maimers113813043maimers
mains75635113main__s
maizes175115733maize_s
makers123921733ma_kers
makes115336853ma_ke_s
males75049793ma_le_s
malines93625603maline_s
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
malteds10377603malteds
maltiness112910573maltiness
mameys13449523ma_meys
mamies104626243mamie_s
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mamzers20409163mamzers
manas76240433ma_n_as
manats84623463ma_nats
mandrels1137313mandrels
mane65052033ma_ne__
maned86634103ma_ne_d
manege94113203ma_nege
maneges103612143ma_neges
maneless102812343maneless
mangas94122923ma_ngas
mangels103614493mangels
mangers103521263mangers
manges94628943ma_nges
manginess122010413manginess
mangos94319333ma_ngos
manias84029033ma_nias
manics103919933ma_nics
manliness111310123manliness
mannans93611523mannans
mannas85019803ma_nnas
manned94418643manne_d
manner84020513manne_r
mannish121710693mannish
mannose939243mannose
mannoses1039083mannoses
manors84420883ma_nors
manos74933623ma_n_os
mans66354553ma_n__s
manse75528233ma_n_se
mantas85725363ma_ntas
mantels94515043mantels
mantes84430783ma_ntes
mantis83926033ma_ntis
manus75924933ma_n_us
maples104819423maple_s
mappers133313783mappers
marcels113212373marcels
mares76457633ma_re_s
marges94525713marge_s
mariners103113863mariners
marines93928013marine_s
markedness1744023markedness
markers133516103markers
markets133314033markets
marquess19204953marquess
marrers93414313marrers
marses84827113marse_s
martens93714953martens
marvels123810093marvels
masers84623453ma_sers
mashers124621053mashers
mashes115030003mashe_s
maskegs14375413maskegs
maskers133913843maskers
mass66044943ma___ss
masses85028713masse_s
massiness112810143massiness
massless10277113massless
masters94628923masters
mastless102610023mastless
mateless102711293mateless
maters85032393ma_ters
mates75251363ma_te_s
mateyness1444473mateyness
mateys115610943ma_teys
matiest92522453matiest
matinees102110423matinees
matrass939403matrass
matres84522233matre_s
matters94421753matters
mattes85624533matte_s
mattress1036533mattress
maulers94213303maulers
maumets11369693maumets
maunders11348343maunders
maunds9519653maun_ds
mauves113811553mauve_s
mavens114312973ma_vens
mavies114923193mavie_s
mavises122812993mavises
maxes145629533ma_xe_s
maybes1339243maybe_s
mayest114614793ma_yest
mayhems1763413mayhems
mayoress1344383mayoress
mazers173917093ma_zers
mazes165632173ma_ze_s
maziest183613873maziest
mealiness11310063mealiness
mealless10288363mealless
meanders1168833meanders
meaners94415243meaners
meanest9315703meanest
meatiness11311183meatiness
meatless103410863meatless
medleys13115333medleys
meekness1434303meekness
meetness1036653meetness
menders103818803menders
menses84222453m_enses
mesnes85216213mesne_s
mess65932433m___ess
middens11379383middens
midges103516483midge_s
midgets113910253midgets
midlegs1156323midlegs
milnebs11113793milnebs
minders103720123minders
mindless11319443mindless
miners84126633m_iners
mines75651953m_ine_s
miriness10310463miriness
moaners92813553moaners
models94216353mod_els
modems114610763mod_ems
modes85537413mod_e_s
modest93818453mod_est
moldiness12227053moldiness
mondes94322353monde_s
moneys115513623m_oneys
moodiness12197593moodiness
mooners94015343mooners
moonless10278043moonless
mootness1036753mootness
mopiness12259063mopiness
moreness10911573moreness
muchness1534073muchness
mudders113211113mudders
muddiness1334763muddiness
mudhens1335103mudhens
muteness1039013muteness
nakedness1445043nakedness
napless93110283napless
nearness838313nearness
neatness839153neatness
ness45526563___ness
newness1035703newness
nowness1037033nowness
nudeness936733nudeness
oarless73913373oarless
oneness7512143oneness
ovalness1134673ovalness
packness1636933packness
padders113312873padders
padles95221123padle_s
padnags1135083padnags
padres95016983padre_s
painless10108343painless
paleness10312983paleness
panders103423733panders
panels84716523pa_nels
panes76148693pa_ne_s
panners93621273panners
pannes85522853panne_s
pardners11269193pardners
pastness102510503pastness
pawnees12298173pawnees
pawners124311073pawners
rabidness12145263rabidness
raciness102413453raciness
rainless8129703rainless
randiness102511443randiness
ranees64623963ra_nees
rankness12267943rankness
rapidness12155473rapidness
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
rayless10239003rayless
readiness102611853readiness
realness8410443realness
redress82511873redress
roadless937703roadless
rodless8310073rodless
rudeness938083rudeness
saddens9309603saddens
saddest92412383saddest
sades65239893sad_e_s
sadhes104715373sadhe_s
sadnesses10310303sadnesses
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
sanders84025943sanders
sandiness102111713sandiness
sandless93212343sandless
saneness82313723saneness
sanes55649073sa_ne_s
sanest64426693sa_nest
sapless93313443sapless
sawneys13274643sawneys
shadiness1337463shadiness
shyness1344993shyness
slyness1035263slyness
smallness1174513smallness
smartness1136143smartness
smugness1143813smugness
staidness1037033staidness
tallness837103tallness
tameness102411253tameness
tandems1037633tandems
tanners74018393tanners
tannest72617853tannest
tardiness10229923tardiness
tartness82210133tartness
tautness8217183tautness
tawneys13324773tawneys
taxless1436913taxless
tidiness938793tidiness
timidness1244623timidness
toadless936313toadless
tumidness1243843tumidness
undress838893undress
vainest10315763vainest
vainness1136063vainness
validness13125363validness
vanes85130973va_ne_s
vanners103612843vanners
vapidness15144423vapidness
vastness11257293vastness
voidness1235553voidness
wadders123812443wadders
waders109120643wad_ers
wades95634143wad_e_s
wadies105121203wadie_s
wadmels1334303wadmels
wadsets1136443wadsets
wanders114221333wanders
wanes85040883wa_ne_s
wannest103915003wannest
wardless12249303wardless
wardress12256163wardress
wariness11313213wariness
warless104015103warless
warmness1337063warmness
warners103315563warners
waviness1437723waviness
waxiness1836723waxiness
wayless13308243wayless
weakness1535353weakness
wetness10277723wetness
whatness1435093whatness
wideness12259473wideness
wildness1236203wildness
witness103010013witness
woeness1020211543woeness
womanness1444473womanness
wryness13113983wryness
yarners104312203yarners
yawners13367183yawners
zanders173015793zanders
zaniness1738663zaniness

Search took 7 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 Limit1340275426.21621561.6
3Display Results5425420.2032670.0
 (SQL Overall)1786915426.82526181.8
 
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.