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

117 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
mildened123577(None) 
mildewed1543761mildewed
maddened1334892maddened
milded104416152mild__ed
milden94113152milden__
mildens10339932milden_s
milleped1335172milleped
misdeed113211052misde_ed
mittened1136362mittened
moldered1237172moldered
widened12328052wi_dened
wildered1336632wildered
aliened81011743_aliened
billeted1137643billeted
burdened1236423burdened
cindered1239793cindered
deadened1137233deadened
diademed1344153diademed
dizened18267333di_zened
emboldened1652043emboldened
fileted1159093fil_eted
filleted1236603filleted
filtered12259043filtered
gardened1137003gardened
gilded94413223gild__ed
goldener1045403goldener
hardened1338613hardened
hindered1339453hindered
hoidened1335653hoidened
hoydened1644643hoydened
imboldened1651603imboldened
indeed83913563_inde_ed
indene73215373_indene_
indenes82916253_indenes
indented101811733_indented
indexed16347363_indexed
kilned11368393kil__ned
kittened1334523kittened
ladened979053_ladened
leadened1036153leadened
lichened1435753lichened
likened12267353li_kened
lippened13255223lippened
listened9168813listened
livened11238933li_vened
loudened1044693loudened
maligned1285773maligned
melded104714713meld__ed
midden104112853midden__
middens11379383midden_s
middled123311903mi_ddled
midland1136613midlan_d
midline102315103midline_
midlines112613333midlines
mildening1345673mildening
milder93818453mild__er
mildest102812063milde_st
mildew12319043mild__ew
mildews13365883milde_ws
mildewy16353533milde_wy
milding113615453mildin_g
mildness1136523mildness
milked134612573mil__ked
milkshed1842943milkshed
milkweed1843353milkweed
milled94326173mil__led
millepede1442983millepede
millepeds1443223millepeds
milline92519113milline_
milliner102811863milliner
millines102718063millines
milliped1337383milliped
milneb1095953mil__neb
milted93919943mil__ted
mimeoed1235193mi_meoed
minded103817833mind__ed
mined85333353mi___ned
minuend1035383minuen_d
miocene1147923miocene_
misdated121211123misdated
misdeeds12276813misde_eds
misdeem12217873misde_em
misdeemed1544603misdeemed
misdefined1743423misdefined
misdone10310863misdone_
misfeed13389683misfe_ed
mispenned1445413mispenned
missend104411373missen_d
mistend103812523misten_d
mistended13137333mistended
mistuned1157723mistuned
mitered103213233mi_tered
modeled1139463m_odeled
modemed1336723m_odemed
moistened1246003moistened
molded104414083mold__ed
mouldered1343753mouldered
murdered1236023murdered
oilseed835783oilse_ed
pilfered1435853pilfered
pilsener1044753pilsener
pinkened1535753pinkened
pollened1157783pollened
reddened1136423reddened
richened1435953richened
ripened1038203ri_pened
saddened1135343saddened
sickened1546783sickened
silenced1136273sil_enced
silvered12237563silvered
smoldered1343793smoldered
soddened1144643soddened
soldered1038153soldered
tillered937443tillered
widener11318693wi_dener
wilded113714503wild__ed
wizened20275423wi_zened

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.436409841.7
2DLD Change Limit1461621177.26620115.9
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.74823062.9
 
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.