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

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

103 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
harmlessnesses187641(None) 
aimlessnesses1487462_aimlessnesses
artlessnesses1247672_artlessnesses
carelessnesses1547722carelessnesses
formlessnesses1856122formlessnesses
hairlessnesses16126632hairlessnesses
haplessnesses1747252ha_plessnesses
harmlessness1745052harmlessne_s_s
heartlessnesses1765772heartlessnesses
hornlessnesses1656272hornlessnesses
agelessnesses1387633_agelessnesses
airlessnesses12118003_airlessnesses
facelessnesses1847323facelessnesses
fearlessnesses1666743fear_lessnesses
headlessnesses17137063headlessnesses
heedlessnesses17136223heedlessnesses
helplessnesses1855803helplessnesses
homelessnesses18137473homelessnesses
hopelessnesses18147013hopelessnesses
landlessnesses1456683landlessnesses
lawlessnesses1546383la_wlessnesses
namelessnesses1577053namelessnesses
painlessnesses1546743painlessnesses
pathlessnesses1855953pathlessnesses
raylessnesses1546503ra_ylessnesses
saplessnesses1347273sa_plessnesses
seamlessnesses1446973seamlessnesses
shamelessnesses18186513shamelessnesses
shapelessnesses18156293shapelessnesses
tactlessnesses1546553tactlessnesses
thanklessnesses2154803thanklessnesses
tirelessnesses1357013tirelessnesses
wordlessnesses1775873wordlessnesses
worklessnesses20125483worklessnesses
aimlessness1345674_aimlessne_s_s
artlessness1146444_artlessne_s_s
blamelessnesses1865714blamelessnesses
bootlessnesses1556454bootlessnesses
brainlessnesses1665024brainlessnesses
carelessness1446544carelessne_s_s
ceaselessnesses1596164ceaselessnesses
cheerlessnesses1954544cheerlessnesses
childlessnesses20104944childlessnesses
classlessnesses054834classlessnesses
dauntlessnesses1554814dauntlessnesses
deathlessnesses1885174deathlessnesses
dreamlessnesses17104534dreamlessnesses
earnestnesses1353664ear_nestnesses
endlessnesses1356764_endlessnesses
faithlessnesses2074974faithlessnesses
faultlessnesses1754934faultlessnesses
fecklessnesses2255494fecklessnesses
flawlessnesses1975454flawlessnesses
foodlessnesses1755764foodlessnesses
footlessnesses1656564footlessnesses
formlessness1744714formlessne_s_s
godlessnesses1446584_godlessnesses
gracelessnesses1755904gracelessnesses
gutlessnesses1346944_gutlessnesses
hairlessness1545304hairlessne_s_s
halenesses13312044ha__le__nesses
haplessness1645664ha_plessne_s_s
harmfulnesses2164304harm_fulnesses
harshnesses1745854har___shnesses
heartlessness1665174heartlessne_s_s
hornlessness1545164hornlessne_s_s
houselessnesses1665674houselessnesses
humorlessnesses1954184humorlessnesses
joblessnesses2155994_joblessnesses
joylessnesses2255644_joylessnesses
lifelessnesses1646654lifelessnesses
listlessnesses1266934listlessnesses
lovelessnesses1646994lovelessnesses
mercilessnesses18104534mercilessnesses
mindlessnesses1686014mindlessnesses
movelessnesses1846744movelessnesses
needlessnesses14115694needlessnesses
nervelessnesses1754984nervelessnesses
pitilessnesses1575754pitilessnesses
planlessnesses1576304planlessnesses
plotlessnesses1556094plotlessnesses
recklessnesses1955844recklessnesses
restlessnesses1257234restlessnesses
rootlessnesses1346604rootlessnesses
ruthlessnesses1665384ruthlessnesses
selflessnesses15115994selflessnesses
sexlessnesses1846744_sexlessnesses
shiftlessnesses1954994shiftlessnesses
sinlessnesses1157984_sinlessnesses
skillessnesses1655614skillessnesses
soullessnesses1296504soullessnesses
spotlessnesses1456274spotlessnesses
statelessnesses1355864statelessnesses
tastelessnesses1355274tastelessnesses
timelessnesses1547024timelessnesses
tonelessnesses13137654tonelessnesses
toplessnesses1446584_toplessnesses
uselessnesses1147314_uselessnesses
valuelessnesses1764794valuelessnesses
waterlessnesses1754724waterlessnesses
winglessnesses1765464winglessnesses
witlessnesses1547234_witlessnesses
worthlessnesses2054554worthlessnesses

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 Filter178691658741.046170832.7
2DLD Change Limit658741035.75011456.3
3Display Results1031030.0761355.3
 (SQL Overall)1786911036.87226002.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.