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 “joylessness” 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
joylessness214429(None) 
joblessness2044811joblessness
godlessness1355432godlessness
joylessnesses2255642joylessnesses
raylessness1445112raylessness
toplessness1345402toplessness
agelessness1246073agelessness
aimlessness1345673aimlessness
airlessness1146253airlessness
artlessness1146433artlessness
bootlessness1445453bootlessness
endlessness1245483endlessness
foodlessness1644743foodlessness
footlessness1545613footlessness
formlessness1744713formlessness
gutlessness1246013gutlessness
haplessness1645663haplessness
homelessness1746103homelessness
hopelessness1745753hopelessness
hornlessness1545163hornlessness
joblessnesses2155993joblessnesses
joyousness2043623joy_ousness
lawlessness1444893lawlessness
lovelessness1545733lovelessness
movelessness1745303movelessness
plotlessness1445083plotlessness
rootlessness1245613rootlessness
saplessness1245983saplessness
sexlessness1745313sexlessness
sinlessness1046723sinlessness
soullessness1145543soullessness
spotlessness1345323spotlessness
tonelessness1246243tonelessness
uselessness1075993uselessness
witlessness1446263witlessness
wordlessness1644713wordlessness
worklessness1954103worklessness
bloodlessness1653504bloodlessness
boundlessness1654044boundlessness
boyishness1843964boy_ishness
carelessness1446544carelessness
cloudlessness1653844cloudlessness
colessees11146054co_less_ees
colorlessness1553904colorlessness
coynesses1437574coyness_e_s
dollishness1544014dollishness
doubtlessness1654074doubtlessness
facelessness1786054facelessness
fearlessness1545764fearlessness
fecklessness2154484fecklessness
flawlessness1854124flawlessness
folksiness1743574fo_lksiness
foolishness1744494foolishness
godlessnesses1446584godlessnesses
hairlessness1545304hairlessness
harmlessness1745054harmlessness
headlessness16105964headlessness
heedlessness1685024heedlessness
helplessness1754474helplessness
houselessness15104924houselessness
humorlessness1853164humorlessness
jealousness1845324jealousness
jocoseness1943304jo_coseness
jolliness1636214jo_l_liness
jowliness1934854jowl__iness
joyfulness2343204joy_fulness
joyless17226514joyl____ess
joylessly2242494joyless__ly
landlessness1345714landlessness
lifelessness1545294lifelessness
listlessness1145824listlessness
mindlessness1554854mindlessness
namelessness1445614namelessness
needlessness1374684needlessness
nobleness1147524noble__ness
noblesses1146004nobless_e_s
obeseness1145894_o_beseness
owlishness1644164_owlishness
oyesses1037334_oy_ess_e_s
painlessness1445444painlessness
pathlessness1754904pathlessness
pitilessness1474524pitilessness
planlessness1444994planlessness
pointlessness1554614pointlessness
powerlessness1853194powerlessness
raylessnesses1546504raylessnesses
recklessness1854654recklessness
restlessness1146514restlessness
ruthlessness1554314ruthlessness
seamlessness1355904seamlessness
selflessness1444594selflessness
skillessness1554234skillessness
solemnness1243214so_lemnness
soleness8814264so_le__ness
stylelessness1553414stylelessness
stylishness1743444stylishness
tactlessness1445414tactlessness
timelessness1445784timelessness
tirelessness1245934tirelessness
toplessnesses1446584toplessnesses
voicelessness1854064voicelessness
winglessness1654324winglessness
worthlessness1953654worthlessness

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191037.81319047.6
3Display Results1031030.0631634.9
 (SQL Overall)1786911038.29621539.4
 
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.