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

214 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
mildness113652(None) 
wildness1236201wildness
baldness1137042baldness
boldness1136972boldness
coldness1137952coldness
illness736472_illness
kindness13236652kindness
madness10310072m_adness
maleness10312312maleness
mildens10339932mild_ens
mildest102812062mild_est
mildews13365882mild_ews
mildnesses1397392mildnesses
milkiness1536522milkiness
milkless1434772milkless
milnebs11113792mil_nebs
mindless11319442mindless
miriness10310462miriness
moldiness12227052moldiness
oiliness8311562oiliness
oldness836402_oldness
vileness1139982vileness
wiliness1139112wiliness
acidness1136723acidness
agedness1036683agedness
agileness1046493agileness
aidless83612073ai_dless
airiness8412213airiness
ampleness1345303ampleness
aridness939223aridness
avidness1246113avidness
badness1039573_badness
biasness1035813biasness
bigness1038193bi_gness
blindness1235343blindness
calmness1236643calmness
childless1543813childless
chillness1455373chillness
dailiness1038673dailiness
dailyness1343643dailyness
deadness1039233deadness
dildoes9229243dildoe_s
dimness1038843di_mness
direness9311303direness
dullness934873dullness
dulness8307983dul_ness
eldress835003_eldress
evilness1135043evil_ness
eyedness1245103eyedness
fellness1135913fellness
filminess1435983filminess
filmless1344553filmless
fineness11310643fineness
firmness1334743firmness
fitness10299393fi_tness
fixedness2043713fixedness
fondness1237213fondness
fullness1135443fullness
fulness10248963ful_ness
gelidness1144473gelidness
giddiness1234683giddiness
gilders94212463gild_ers
gillnets934733gillnets
gladness1036153gladness
glibness1134133glibness
goodness1036253goodness
haleness11312623haleness
halfness1435563halfness
hardness122411083hardness
highness1536053highness
hilliness1248923hilliness
hiltless11297123hiltless
hipness12277383hi_pness
holiness112512503holiness
humidness1544023humi_dness
iciness938863_iciness
idleness936843idleness
kidneys1533423ki_dneys
kindless13289243kindless
lewdness1254173lewdness
lidless8309273li_dless
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
lioness739103li_oness
liteness82213213liteness
liveness112411393liveness
lividness1344713lividness
loudness937013loudness
mailless10248583mail_less
malines93625603maline_s
maltiness112910573maltiness
manliness111310123manliness
matiness102114753matiness
mazedness2194573mazedness
maziness19239543maziness
mealiness11310063mealiness
meanness1037183meanness
meekness1434303meekness
meetness1036653meetness
melders103213913meld_ers
middens11379383mi_ddens
middies113116153middie_s
middlers123410193middlers
middles113415303middle_s
midges103516483mi_dge_s
midgets113910253mi_dgets
midlegs1156323mi_dlegs
midlines112613333midline_s
miffiness1734523miffiness
miladies1139923miladie_s
milages103114403milage_s
milded104416153mild_e_d
milden94113153mild_e_n
mildened1235773mildened
milder93818453mild_e_r
mildew12319043mild_e_w
mildewy16353533mild_ewy
milds86422053mild___s
milers84625163mil__ers
miles74645073mil__e_s
milieus939803mil_ieus
milkers134411613mil_kers
milkiest142911083milkiest
millers93621343mil_lers
milles84526563mil_le_s
millets94216843mil_lets
milliers102611903milliers
milliners11289953milliners
millines102718063milline_s
milneb1095953mil_ne_b
milreis937323mil_reis
milters93619093mil_ters
miltiest103015173miltiest
mindedness1445143mindedness
minders103720123mind_ers
mindsets1135683mindsets
miners84126633mi__ners
mines75651953mi__ne_s
minidress1243583minidress
misdeeds12276813misdeeds
misdeems13255653misdeems
misdoers1137103misdoers
misdoes10312493misdoe_s
misguess1134643misguess
mistiness111911633mistiness
mistress10310703mistress
moistness1146343moistness
molders103315553mold_ers
moldiest11249693moldiest
moodiness12197593moodiness
mootness1036753mootness
mopiness12259063mopiness
moreness10911573moreness
muchness1534073muchness
muddiness1334763muddiness
muteness1039013muteness
niceness1039843niceness
nighness1236103nighness
oddness935313_oddness
paleness10312983paleness
pileless1088623pileless
pilsners1035533pilsners
pinkness1436513pinkness
pipiness1238003pipiness
pixiness1736093pixiness
redness82012443_redness
richness1337433richness
rifeness1138583rifeness
rigidness1145123rigidness
riminess10510093riminess
rindless92510193rindless
ripeness1039363ripeness
sadness8310613_sadness
saltness82610243saltness
selfness1135153selfness
sickness1437833sickness
sidedness1146783sidedness
silanes72517163silane_s
silkiness1337253silkiness
silliness9510363silliness
siziness1737423siziness
slimness1036523slimness
slyness1035263_slyness
smallness1174513smallness
smileless1134693smileless
soleness8814263soleness
solidness1036903solidness
stillness936103stillness
tallness837103tallness
tidiness938793tidiness
tildes74513963tild_e_s
timidness1244623timidness
tininess8310633tininess
tiredness1036933tiredness
titaness836723titaness
tumidness1243843tumi_dness
ugliness936863ugliness
validness13125363validness
vividness1643933vividness
voidness1235553voidness
weirdness1343593weirdness
weldless12285813weldless
wellness1135793wellness
wideness12259473wideness
wilderness1443513wilderness
wilders113513503wild_ers
wildest113311273wild_est
wildnesses14157363wildnesses
windiness1337373windiness
windless123310863windless
wiriness1138953wiriness
wiseness112010753wiseness
witness103010013wi_tness

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.483369960.7
2DLD Change Limit1461622146.65621959.4
3Display Results2142140.0932301.1
 (SQL Overall)1786912147.23224708.4
 
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.