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 “affectednesses” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
affectednesses238260(None) 
affectedness2153202affectedne_s_s
dejectednesses2553073dejectednesses
directednesses1863383directednesses
effetenesses1854523effe_te_nesses
expectednesses2662953expectednesses
abjectnesses2352564abject__nesses
adaptednesses1772624a_daptednesses
collectednesses2062594collectednesses
connectednesses2063354connectednesses
dementednesses1853814dementednesses
effectivenesses2665104effectivenesses
effectualnesses2391814effectualnesses
fetidnesses1546654__fe_tidnesses
giftednesses1754014gif__tednesses
indebtednesses1853404indebtednesses
unaffectedness2372084unaffectedne_s_s
accursednesses1961775accursednesses
acidnesses1337255a___c_idnesses
acridnesses1445795a___cridnesses
acutenesses13126975a__cute_nesses
adeptnesses1444835a_dept__nesses
adversenesses1753395adverse_nesses
affectionless2161875affectionles_s
affectless1842135affect__le_s_s
affectlessness2271915affect__lessness
agednesses1237415a____gednesses
alertnesses1147235a_lert__nesses
animatenesses1555945animate_nesses
assurednesses1352615a_ssurednesses
astutenesses1245605a_stute_nesses
aversenesses1545665a_verse_nesses
barefacednesses2381185barefacednesses
belatednesses1644335_belatednesses
blessednesses1552855_blessednesses
conceitednesses2063695conceitednesses
concertednesses2064215concertednesses
contentednesses1863745contentednesses
datednesses1357905___datednesses
decidednesses1853895__decidednesses
defectivenesses2496075defectivenesses
dejectedness2353565dejectedne_s_s
deservednesses19163485deservednesses
detachednesses2152015detachednesses
devotednesses1853275_devotednesses
directedness1654265directedne_s_s
directnesses1595285direct__nesses
educatednesses1852835educatednesses
effeteness1643675effe_te_ne_s_s
elatednesses1346115__elatednesses
erectnesses1347475_erect__nesses
expectedness2453325expectedne_s_s
extendednesses2362655extendednesses
eyednesses1445815___e_yednesses
fadednesses16126565__f_adednesses
fatheadednesses2372625fatheadednesses
feeblenesses1745545_feeble_nesses
fervidnesses1943845__fervidnesses
fiercenesses1744315_fierce_nesses
finitenesses1557725_finite_nesses
fixednesses2244855__f_ixednesses
fleetnesses1445485_fle__etnesses
freenesses1339875_fre__e_nesses
jointednesses2174025_jointednesses
limitednesses1654015_limitednesses
notednesses1247795___notednesses
offhandednesses2691705offhandednesses
outdatednesses1652955outdatednesses
peakednesses1945045__peakednesses
perfectnesses2053355perfect__nesses
pervertednesses2162765pervertednesses
pointednesses1654975_pointednesses
relatednesses1445005_relatednesses
reservednesses18163325reservednesses
rootednesses1345335__rootednesses
sacrednesses1544875__sacrednesses
selectnesses1446115select__nesses
spiritednesses1753225spiritednesses
stiltednesses1454015_stiltednesses
stuntednesses1453935_stuntednesses
sveltenesses1545235_svelte_nesses
unsettlednesses16102205unsettlednesses
unwontednesses1853005unwontednesses
uprootednesses1752345uprootednesses
vexednesses2244605__ve_xednesses
wickednesses2243275__wickednesses
wontednesses1645995__wontednesses
wretchednesses2351505wretchednesses

Search took 9 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 Filter178691950240.546327272.9
2DLD Change Limit95024887.39312853.2
3Display Results88880.0631396.8
 (SQL Overall)178691888.00222330.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.