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 “affectlessness” 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
affectlessness227191(None) 
affectedness2153203affect_e_dness
effortlessness2061893effortlessness
fecklessness2154483__fecklessness
objectlessness2561543objectlessness
affectless1842134affectl____ess
agelessness1246074a_ge__lessness
artlessness1146434a___rtlessness
facelessness1786054__facelessness
faultlessness1653944_faultlessness
fearlessness1545764__fearlessness
fencelessness1854074_fencelessness
footlessness1545614__footlessness
fruitlessness1654194_fruitlessness
lifelessness1545294life__lessness
recklessness1854654__recklessness
relentlessness1452614relentlessness
restlessness1146514__restlessness
speechlessness2081604speechlessness
tactlessness1445414__tactlessness
abjectnesses2352565abjectness_e_s
affectednesses2382605affect_e_dnesses
affectionless2161875affect_ionless
aimlessness1345675a___imlessness
airlessness1146255a___irlessness
bootlessness1445455__bootlessness
breathlessness1952795_breathlessness
carelessness1446545care__lessness
cheerlessness1853705_cheerlessness
dauntlessness1453775_dauntlessness
deathlessness1754325__deathlessness
defenselessness1861425defenselessness
doubtlessness1654075_doubtlessness
dreamlessness1673815_dreamlessness
effectiveness2455675effect_iveness
effectualness2171935effect_ualness
effeteness1643675effe_t_e__ness
endlessness1245485___endlessness
faithlessness1953975_faithlessness
fathomlessness2261555fathomlessness
fecklessnesses2255495__fecklessnesses
flawlessness1854125__flawlessness
foodlessness1644745__foodlessness
formlessness1744715__formlessness
friendlessness1852205friendlessness
gracelessness1664765_gracelessness
guiltlessness1453775_guiltlessness
gutlessness1246015___gutlessness
headlessness16105965__headlessness
heartlessness1665175_heartlessness
heedlessness1685025__heedlessness
helplessness1754475__helplessness
homelessness1746105home__lessness
hopelessness1745755hope__lessness
infectiousness1954305infectiousness
limitlessness1553345_limitlessness
listlessness1145825__listlessness
lovelessness1545735love__lessness
mercilessness1753465_mercilessness
movelessness1745305move__lessness
namelessness1445615name__lessness
needlessness1374685__needlessness
plotlessness1445085__plotlessness
pointlessness1554615_pointlessness
powerlessness1853195powe_rlessness
resistlessness1282605resistlessness
rootlessness1245615__rootlessness
seamlessness1355905__seamlessness
selflessness1444595__selflessness
sexlessness1745315__se_xlessness
shiftlessness1854005_shiftlessness
sightlessness1654155_sightlessness
sleeplessness1453555_sleeplessness
spiritlessness1582565spiritlessness
spotlessness1345325__spotlessness
stresslessness061775stresslessness
tastelessness1254195taste__lessness
thriftlessness2062255thriftlessness
timelessness1445785time__lessness
tirelessness1245935tire__lessness
tonelessness1246245tone__lessness
unaffectedness2372085unaffect_e_dness
uselessness1075995_use__lessness
valuelessness1653455value__lessness
voicelessness1854065_voicelessness
waterlessness1653855wate_rlessness
weightlessness2162425weightlessness
witlessness1446265___witlessness

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 Filter178691950240.360496363.9
2DLD Change Limit95024886.34314980.9
3Display Results88880.0631396.8
 (SQL Overall)178691886.76626410.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.