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

177 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
milkiness153652(None) 
silkiness1337251silkiness
balkiness1556902balkiness
bulkiness1555932bulkiness
filminess1435982filminess
hilliness1248922hilliness
ickiness1436752_ickiness
inkiness1238692_inkiness
kinkiness1235762kinkiness
maltiness112910572maltiness
miffiness1734522miffiness
mildness1136522mil_dness
milkiest142911082milki_est
milkinesses1786792milkinesses
milkless1434772milk_less
milliners11289952milliners
millines102718062milline_s
miriness10310462mi_riness
mistiness111911632mistiness
moldiness12227052moldiness
murkiness15206292murkiness
muskiness15237442muskiness
oiliness8311562oil_iness
pickiness1737622pickiness
riskiness1336962riskiness
silliness9510362silliness
sulkiness1347352sulkiness
talkiness1356912talkiness
wiliness1139112wil_iness
airiness8412213ai_riness
alikeness1336333alikeness
alkines114415733_alkine_s
balminess1356593balminess
bittiness11228333bittiness
boskiness15196513boskiness
bulginess1245633bulginess
cakiness1449553_cakiness
chilliness1555313chilliness
cockiness17248783cockiness
corkiness152810443corkiness
dailiness1038673dail_iness
diakineses1543693diakineses
diakinesis1542733diakinesis
dinginess1137823dinginess
dippiness1435973dippiness
dirtiness1039473dirtiness
ditsiness1048143ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
dorkiness14248053dorkiness
duskiness14216683duskiness
fieriness1238623fieriness
filthiness1643713filthiness
fishiness1537343fishiness
flakiness1636473flakiness
flukiness1635453flukiness
folksiness1743573folksiness
forkiness16268703forkiness
friskiness1744453friskiness
funkiness16226873funkiness
gawkiness1734753gawkiness
geekiness1435413geekiness
giddiness1234683giddiness
gluiness937363_gluiness
guiltiness1144193guiltiness
hippiness1635463hippiness
hokiness152510183_hokiness
holiness112512503hol_iness
huskiness16206583huskiness
iciness938863_i_ciness
iffiness1435023_iffiness
illness736473_il_lness
jerkiness20175643jerkiness
jokiness19227393_jokiness
jolliness1636213jolliness
kookiness1235563kookiness
lankiness1338053lankiness
larkiness1338113larkiness
leakiness1337503leakiness
likeness12229863li_keness
liminess10510643li_miness
lippiness1335413lippiness
luckiness1596573luckiness
maleness10312313mal_eness
malines93625603mal_ine_s
malkins133311803malkin__s
manginess122010413manginess
manliness111310123manliness
massiness112810143massiness
matiness102114753m_atiness
maziness19239543m_aziness
mealiness11310063mealiness
meatiness11311183meatiness
meekness1434303meek_ness
merriness1138293merriness
messiness11248223messiness
midlines112613333midline_s
mightiness1645093mightiness
milieus939803mil_i_eus
milkers134411613milk__ers
milkier133411163milki_e_r
milking143712763milkin__g
milksheds1941733milksheds
milkweeds1942783milkweeds
milliers102611903milli_ers
millimes122411373millime_s
milline92519113milline__
milliner102811863milline_r
millinery14336103millinery
millings113712583millin_gs
millipeds1444703millipeds
millirems1344323millirems
milnebs11113793mil__nebs
miltiest103015173milti_est
mirkiest142910253mirki_est
moodiness12197593moodiness
mooniness11157863mooniness
mopiness12259063m_opiness
mossiness11258323mossiness
mousiness11219023mousiness
muddiness1334763muddiness
mugginess1354633mugginess
mushiness14248223mushiness
mussiness11238303mussiness
mustiness112211663mustiness
muzziness1933143muzziness
niftiness1236363niftiness
nippiness1334713nippiness
pawkiness1835443pawkiness
perkiness15209163perkiness
peskiness15216523peskiness
pigginess1375453pigginess
pinkness1436513pink_ness
pipiness1238003pi_piness
pithiness1437563pithiness
pixiness1736093pi_xiness
pokiness14219863_pokiness
porkiness15249193porkiness
pulpiness1335603pulpiness
punkiness15226983punkiness
quakiness2236073quakiness
quirkiness2342823quirkiness
riminess10510093ri_miness
ritziness1835823ritziness
rockiness15237833rockiness
saltiness93312113saltiness
shakiness1637083shakiness
sickliness1645003sickliness
sickness1437833sick_ness
silkies113715693silki_e_s
silkiest123212853silki_est
silkinesses1557903silkinesses
sissiness8217963sissiness
siziness1737423si_ziness
sliminess1137423sliminess
slinkiness1445153slinkiness
smokiness1535543smokiness
snakiness1367473snakiness
spikiness1536313spikiness
stickiness1635903stickiness
tackiness1557693tackiness
tidiness938793ti_diness
tininess8310633ti_niness
tinniness936093tinniness
tipsiness1135703tipsiness
trickiness1666353trickiness
ugliness936863ugl_iness
vileness1139983vil_eness
villainess1343853villainess
wackiness1836523wackiness
wildness1236203wil_dness
wimpiness1635293wimpiness
windiness1337373windiness
wiriness1138953wi_riness
wispiness1435633wispiness
wittiness12197223wittiness
yuckiness1874923yuckiness

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411776.90621523.5
3Display Results1771770.0762328.9
 (SQL Overall)1786911777.40524131.1
 
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.