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]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

189 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
abjectness2152186abject____ness
actresses1137936a___ctress_e_s
adeptnesses1444836a_deptness_e_s
affectations2043436affectation__s
affecters1763936affect_____ers
affectioned2052456affect__ione_d
affections1845896affect__ion__s
affectivities2453516affectivitie_s
agelessnesses1387626a_ge__lessnesses
alertnesses1147236a_lertness_e_s
ancestresses1493276ancestress_e_s
artlessnesses1247666a___rtlessnesses
blamelessness1754546_blamelessness
bloodlessness1653506_bloodlessness
bottomlessness1891406bottomlessness
boundlessness1654046_boundlessness
brainlessness1554186_brainlessness
ceaselessness1455116_ceaselessness
changelessness2062776changelessness
childlessness1963876_childlessness
classlessness1353736_classlessness
cloudlessness1653846_cloudlessness
colorlessness1553906_colorlessness
defectiveness2256546defect_iveness
dejectedness2353566deject_e_dness
directedness1654266direct_e_dness
directnesses1595286directness_e_s
directresses15123086directress_e_s
effectualnesses2391816effectualness_e_s
effetenesses1854526effeteness_e_s
electresses1345966_electress_e_s
erectnesses1347476_erectness_e_s
exhaustlessness2461086exhaustlessness
expectedness2453326expect_e_dness
facelessnesses1847326__facelessnesses
facetiousness18106076face_tiousness
facileness1545506__facile__ness
factiousness1787796__factiousness
farfetchedness2671106farfetche_dness
faultlessnesses1754936_faultlessnesses
fearlessnesses1666746__fearlessnesses
feebleness1544896__feeble__ness
femaleness1545766__female__ness
fencelessnesses1995356_fencelessnesses
fertileness1447576__fertile__ness
fickleness1943666__fickle__ness
fleetnesses1445486_fleetness_e_s
footlessnesses1656566__footlessnesses
fractiousness1856876_fractiousness
fruitlessnesses1754896_fruitlessnesses
futurelessness1761956futurelessness
gentleness1145596__gentle__ness
godlessness1355436___godlessness
groundlessness16102596groundlessness
guilelessness1453926_guilelessness
hairlessness1545306__hairlessness
haplessness1645666___haplessness
harmlessness1745056__harmlessness
hornlessness1545166__hornlessness
houselessness15104926_houselessness
humorlessness1853166_humorlessness
joblessness2044816___joblessness
joylessness2144296___joylessness
landlessness1345716__landlessness
lawlessness1444896___lawlessness
lifelessnesses1646656life__lessnesses
mindlessness1554856__mindlessness
motherlessness1952236motherlessness
motionlessness16122156motionlessness
nervelessness1653726_nervelessness
officiousness2154736offic_iousness
painlessness1445446__painlessness
pathlessness1754906__pathlessness
perfectnesses2053356perfectness_e_s
pitilessness1474526__pitilessness
planlessness1444996__planlessness
raylessness1445116___raylessness
recklessnesses1955846__recklessnesses
regardlessness1662126regardlessness
restlessnesses1257236__restlessnesses
ruthlessness1554316__ruthlessness
saplessness1245986___saplessness
selectnesses1446116selectness_e_s
senselessness1154736_senselessness
shamelessness1754966_shamelessness
shapelessness1754966_shapelessness
sinlessness1046726___sinlessness
skillessness1554236__skillessness
soullessness1145546__soullessness
spinelessness1454406_spinelessness
statelessness1255146_statelessness
stylelessness1553416_stylelessness
tactlessnesses1546556__tactlessnesses
thanklessness2053836_thanklessness
thoughtlessness2271336thoughtlessness
toplessness1345406___toplessness
unsettledness1462446unsettle_dness
winglessness1654326__winglessness
wordlessness1644716__wordlessness
worklessness1954106__worklessness
worthlessness1953656_worthlessness

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901899.31313399.5
3Display Results1891890.1231536.6
 (SQL Overall)1786911899.82618185.5
 
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.