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 “joylessnesses” 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.

97 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
joylessnesses225563(None) 
joblessnesses2155971joblessnesses
godlessnesses1446572godlessnesses
joylessness2144282joylessne_s_s
raylessnesses1546492raylessnesses
toplessnesses1446562toplessnesses
agelessnesses1387613agelessnesses
aimlessnesses1487453aimlessnesses
airlessnesses12117983airlessnesses
artlessnesses1247653artlessnesses
bootlessnesses1556433bootlessnesses
endlessnesses1356753endlessnesses
foodlessnesses1755753foodlessnesses
footlessnesses1656553footlessnesses
formlessnesses1856103formlessnesses
gutlessnesses1346923gutlessnesses
haplessnesses1747243haplessnesses
homelessnesses18137463homelessnesses
hopelessnesses18147003hopelessnesses
hornlessnesses1656263hornlessnesses
joblessness2044793joblessne_s_s
joyousnesses2244663joy_ousnesses
lawlessnesses1546373lawlessnesses
lovelessnesses1646983lovelessnesses
movelessnesses1846733movelessnesses
plotlessnesses1556083plotlessnesses
rootlessnesses1346583rootlessnesses
saplessnesses1347263saplessnesses
sexlessnesses1846733sexlessnesses
sinlessnesses1157963sinlessnesses
soullessnesses1296483soullessnesses
spotlessnesses1456263spotlessnesses
tonelessnesses13137633tonelessnesses
uselessnesses1147293uselessnesses
witlessnesses1547223witlessnesses
wordlessnesses1775863wordlessnesses
worklessnesses20125473worklessnesses
bloodlessnesses1764314bloodlessnesses
boundlessnesses1774904boundlessnesses
boyishnesses2044034boy_ishnesses
carelessnesses1547714carelessnesses
cloudlessnesses1764854cloudlessnesses
colorlessnesses1665084colorlessnesses
dollishnesses1744374dollishnesses
doubtlessnesses1764914doubtlessnesses
facelessnesses1847314facelessnesses
fearlessnesses1666724fearlessnesses
fecklessnesses2255484fecklessnesses
flawlessnesses1975444flawlessnesses
folksinesses1964064fo_lksinesses
foolishnesses1944454foolishnesses
godlessness1355414godlessne_s_s
hairlessnesses16126624hairlessnesses
harmlessnesses1876404harmlessnesses
headlessnesses17137054headlessnesses
heedlessnesses17136214heedlessnesses
helplessnesses1855794helplessnesses
houselessnesses1665654houselessnesses
humorlessnesses1954174humorlessnesses
jealousnesses2056304jealousnesses
jocosenesses2143974jo_cosenesses
jollinesses1836724jo_l_linesses
jowlinesses2135324jowl__inesses
joyfulnesses2553504joy_fulnesses
landlessnesses1456674landlessnesses
lifelessnesses1646644lifelessnesses
listlessnesses1266914listlessnesses
mindlessnesses1686004mindlessnesses
namelessnesses1577044namelessnesses
needlessnesses14115684needlessnesses
noblenesses1348054noble__nesses
obesenesses1346744_o_besenesses
owlishnesses1844644_owlishnesses
painlessnesses1546724painlessnesses
pathlessnesses1855944pathlessnesses
pitilessnesses1575734pitilessnesses
planlessnesses1576294planlessnesses
pointlessnesses1655434pointlessnesses
powerlessnesses1954474powerlessnesses
raylessness1445104raylessne_s_s
recklessnesses1955834recklessnesses
restlessnesses1257214restlessnesses
ruthlessnesses1665364ruthlessnesses
seamlessnesses1446964seamlessnesses
selflessnesses15115984selflessnesses
skillessnesses1655604skillessnesses
solemnnesses1443634so_lemnnesses
solenesses10412704so_le__nesses
stylelessnesses1674704stylelessnesses
stylishnesses1843404stylishnesses
tactlessnesses1546544tactlessnesses
timelessnesses1547014timelessnesses
tirelessnesses1357004tirelessnesses
toplessness1345384toplessne_s_s
voicelessnesses1955304voicelessnesses
winglessnesses1765454winglessnesses
worthlessnesses2054544worthlessnesses

Search took 6 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.1261418182.5
2DLD Change Limit95024975.14018487.2
3Display Results97970.0631539.7
 (SQL Overall)178691975.32933531.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.