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

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

99 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
hornlessnesses165627(None) 
formlessnesses1856122formlessnesses
harmlessnesses1876412harmlessnesses
homelessnesses18137472homelessnesses
hopelessnesses18147012hopelessnesses
hornlessness1545162hornlessne_s_s
wordlessnesses1775872wordlessnesses
worklessnesses20125482worklessnesses
airlessnesses12117993air_lessnesses
artlessnesses1247663_artlessnesses
bootlessnesses1556453bootlessnesses
boundlessnesses1774923boundlessnesses
carelessnesses1547723carelessnesses
foodlessnesses1755763foodlessnesses
footlessnesses1656563footlessnesses
godlessnesses1446583go_dlessnesses
hairlessnesses16126633hairlessnesses
haplessnesses1747253h_aplessnesses
headlessnesses17137063headlessnesses
heartlessnesses1765773heartlessnesses
heedlessnesses17136223heedlessnesses
helplessnesses1855803helplessnesses
hornednesses1645513horn_e_dnesses
houselessnesses1665673houselessnesses
humorlessnesses1954183humor_lessnesses
joblessnesses2155993jo_blessnesses
joylessnesses2255643jo_ylessnesses
lovelessnesses1646993lovelessnesses
movelessnesses1846743movelessnesses
painlessnesses1546743painlessnesses
planlessnesses1576303planlessnesses
pointlessnesses1655443pointlessnesses
rootlessnesses1346603rootlessnesses
sinlessnesses1157983_sinlessnesses
soullessnesses1296503soullessnesses
tirelessnesses1357013tirelessnesses
tonelessnesses13137653tonelessnesses
toplessnesses1446583to_plessnesses
worthlessnesses2054553worthlessnesses
agelessnesses1387624_agelessnesses
aimlessnesses1487464_aimlessnesses
bloodlessnesses1764324bloodlessnesses
brainlessnesses1665024brainlessnesses
cheerlessnesses1954544cheerlessnesses
childlessnesses20104944childlessnesses
cloudlessnesses1764874cloudlessnesses
colorlessnesses1665094colorlessnesses
dauntlessnesses1554814dauntlessnesses
doubtlessnesses1764934doubtlessnesses
earnestnesses1353664earn_estnesses
endlessnesses1356764_endlessnesses
facelessnesses1847324facelessnesses
fearlessnesses1666744fearlessnesses
fecklessnesses2255494fecklessnesses
flawlessnesses1975454flawlessnesses
formlessness1744714formlessne_s_s
gutlessnesses1346944_gutlessnesses
harmlessness1745054harmlessne_s_s
homelessness1746104homelessne_s_s
hopelessness1745754hopelessne_s_s
horninesses1459004horn___inesses
horsinesses1439554hor___sinesses
landlessnesses1456684landlessnesses
lawlessnesses1546384_lawlessnesses
lifelessnesses1646654lifelessnesses
listlessnesses1266934listlessnesses
mercilessnesses18104534mercilessnesses
mindlessnesses1686014mindlessnesses
namelessnesses1577054namelessnesses
needlessnesses14115694needlessnesses
nervelessnesses1754984nervelessnesses
ornerinesses1246574_orn_erinesses
pathlessnesses1855954pathlessnesses
pitilessnesses1575754pitilessnesses
plotlessnesses1556094plotlessnesses
powerlessnesses1954494powerlessnesses
raylessnesses1546504_raylessnesses
recklessnesses1955844recklessnesses
restlessnesses1257234restlessnesses
ruthlessnesses1665384ruthlessnesses
saplessnesses1347274_saplessnesses
seamlessnesses1446974seamlessnesses
selflessnesses15115994selflessnesses
sexlessnesses1846744_sexlessnesses
shamelessnesses18186514shamelessnesses
shapelessnesses18156294shapelessnesses
shiftlessnesses1954994shiftlessnesses
skillessnesses1655614skillessnesses
spinelessnesses1555494spinelessnesses
spotlessnesses1456274spotlessnesses
tactlessnesses1546554tactlessnesses
thanklessnesses2154804thanklessnesses
timelessnesses1547024timelessnesses
uselessnesses1147314_uselessnesses
voicelessnesses1955314voicelessnesses
winglessnesses1765464winglessnesses
witlessnesses1547234_witlessnesses
wordlessness1644714wordlessne_s_s
worklessness1954104worklessne_s_s

Search took 5 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 Filter178691658740.326548131.9
2DLD Change Limit65874993.67317934.7
3Display Results99990.0761302.6
 (SQL Overall)178691994.07543850.6
 
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.