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

98 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
planlessnesses157630(None) 
flawlessnesses1975452flawlessnesses
landlessnesses1456682_landlessnesses
lawlessnesses1546382_lawlessnesses
painlessnesses1546742painlessnesses
planlessness1444992planlessne_s_s
plotlessnesses1556092plotlessnesses
blamelessnesses1865713blamelessnesses
brainlessnesses1665023brainlessnesses
classlessnesses054833classlessnesses
fearlessnesses1666743fearlessnesses
haplessnesses1747253_haplessnesses
headlessnesses17137063headlessnesses
hornlessnesses1656273hornlessnesses
pathlessnesses1855953pathlessnesses
pitilessnesses1575753pitilessnesses
planenesses1349033plan_e__nesses
pointlessnesses1655443pointlessnesses
raylessnesses1546503_raylessnesses
saplessnesses1347273_saplessnesses
seamlessnesses1446973seamlessnesses
sinlessnesses1157983_sinlessnesses
thanklessnesses2154803thanklessnesses
agelessnesses1387624_agelessnesses
aimlessnesses1487464_aimlessnesses
airlessnesses12117994_airlessnesses
artlessnesses1247664_artlessnesses
bloodlessnesses1764324bloodlessnesses
bootlessnesses1556454bootlessnesses
boundlessnesses1774924boundlessnesses
carelessnesses1547724carelessnesses
ceaselessnesses1596164ceaselessnesses
clannishnesses1952984clannishnesses
cloudlessnesses1764874cloudlessnesses
colorlessnesses1665094colorlessnesses
dauntlessnesses1554814dauntlessnesses
deathlessnesses1885174deathlessnesses
dreamlessnesses17104534dreamlessnesses
endlessnesses1356764_endlessnesses
facelessnesses1847324facelessnesses
fecklessnesses2255494fecklessnesses
flawlessness1854124flawlessne_s_s
foodlessnesses1755764foodlessnesses
footlessnesses1656564footlessnesses
formlessnesses1856124formlessnesses
godlessnesses1446584_godlessnesses
gracelessnesses1755904gracelessnesses
gutlessnesses1346944_gutlessnesses
hairlessnesses16126634hairlessnesses
harmlessnesses1876414harmlessnesses
heartlessnesses1765774heartlessnesses
heedlessnesses17136224heedlessnesses
helplessnesses1855804helplessnesses
homelessnesses18137474homelessnesses
hopelessnesses18147014hopelessnesses
joblessnesses2155994_joblessnesses
joylessnesses2255644_joylessnesses
landlessness1345714_landlessne_s_s
lawlessness1444894_lawlessne_s_s
lifelessnesses1646654lifelessnesses
listlessnesses1266934listlessnesses
lovelessnesses1646994lovelessnesses
mindlessnesses1686014mindlessnesses
movelessnesses1846744movelessnesses
namelessnesses1577054namelessnesses
needlessnesses14115694needlessnesses
painlessness1445444painlessne_s_s
palenesses12312664p_a_le__nesses
plenteousnesses1783984plenteousnesses
pliablenesses1756074pliable__nesses
plotlessness1445084plotlessne_s_s
powerlessnesses1954494powerlessnesses
prankishnesses2353204prankishnesses
recklessnesses1955844recklessnesses
restlessnesses1257234restlessnesses
rootlessnesses1346604rootlessnesses
ruthlessnesses1665384ruthlessnesses
selflessnesses15115994selflessnesses
sexlessnesses1846744_sexlessnesses
shamelessnesses18186514shamelessnesses
shapelessnesses18156294shapelessnesses
skillessnesses1655614skillessnesses
sleeplessnesses1554684sleeplessnesses
soullessnesses1296504soullessnesses
spinelessnesses1555494spinelessnesses
spotlessnesses1456274spotlessnesses
statelessnesses1355864statelessnesses
tactlessnesses1546554tactlessnesses
timelessnesses1547024timelessnesses
tirelessnesses1357014tirelessnesses
tonelessnesses13137654tonelessnesses
toplessnesses1446584_toplessnesses
uselessnesses1147314_uselessnesses
valuelessnesses1764794valuelessnesses
winglessnesses1765464winglessnesses
witlessnesses1547234_witlessnesses
wordlessnesses1775874wordlessnesses
worklessnesses20125484worklessnesses

Search took 4 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.330541487.9
2DLD Change Limit65874983.43619171.7
3Display Results98980.0761289.5
 (SQL Overall)178691983.84246509.9
 
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.