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

101 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
tactlessnesses154654(None) 
artlessnesses1247652_artlessnesses
facelessnesses1847312facelessnesses
tactlessness1445402tactlessne_s_s
tastelessnesses1355262tastelessnesses
agelessnesses1387613_agelessnesses
aimlessnesses1487453_aimlessnesses
airlessnesses12117983_airlessnesses
bootlessnesses1556433bootlessnesses
carelessnesses1547713carelessnesses
dauntlessnesses1554803dauntlessnesses
faithlessnesses2074963faithlessnesses
faultlessnesses1754923faultlessnesses
fecklessnesses2255483fecklessnesses
footlessnesses1656553footlessnesses
gracelessnesses1755893gracelessnesses
gutlessnesses1346923_gutlessnesses
hairlessnesses16126623hairlessnesses
haplessnesses1747243ha_plessnesses
harmlessnesses1876403harmlessnesses
heartlessnesses1765763heartlessnesses
landlessnesses1456673landlessnesses
lawlessnesses1546373la_wlessnesses
listlessnesses1266913listlessnesses
namelessnesses1577043namelessnesses
painlessnesses1546723painlessnesses
pathlessnesses1855943pathlessnesses
plotlessnesses1556083plotlessnesses
raylessnesses1546493ra_ylessnesses
recklessnesses1955833recklessnesses
restlessnesses1257213restlessnesses
rootlessnesses1346583rootlessnesses
saplessnesses1347263sa_plessnesses
spotlessnesses1456263spotlessnesses
statelessnesses1355853statelessnesses
thanklessnesses2154793thanklessnesses
timelessnesses1547013timelessnesses
tirelessnesses1357003tirelessnesses
tonelessnesses13137633tonelessnesses
toplessnesses1446563t_oplessnesses
witlessnesses1547223_witlessnesses
artlessness1146424_artlessne_s_s
blamelessnesses1865704blamelessnesses
brainlessnesses1665004brainlessnesses
ceaselessnesses1596154ceaselessnesses
classlessnesses054824classlessnesses
deathlessnesses1885164deathlessnesses
doubtlessnesses1764914doubtlessnesses
endlessnesses1356754_endlessnesses
facelessness1786054facelessne_s_s
facilenesses1756704facile__nesses
factiousnesses1977494factiousnesses
fearlessnesses1666724fearlessnesses
fencelessnesses1995344fencelessnesses
flawlessnesses1975444flawlessnesses
foodlessnesses1755754foodlessnesses
formlessnesses1856104formlessnesses
fruitlessnesses1754864fruitlessnesses
godlessnesses1446574_godlessnesses
guiltlessnesses15174914guiltlessnesses
headlessnesses17137054headlessnesses
heedlessnesses17136214heedlessnesses
helplessnesses1855794helplessnesses
homelessnesses18137464homelessnesses
hopelessnesses18147004hopelessnesses
hornlessnesses1656264hornlessnesses
joblessnesses2155974_joblessnesses
joylessnesses2255634_joylessnesses
lifelessnesses1646644lifelessnesses
limitlessnesses1654274limitlessnesses
lovelessnesses1646984lovelessnesses
mercilessnesses18104524mercilessnesses
mindlessnesses1686004mindlessnesses
movelessnesses1846734movelessnesses
needlessnesses14115684needlessnesses
pitilessnesses1575734pitilessnesses
planlessnesses1576294planlessnesses
pointlessnesses1655434pointlessnesses
ruthlessnesses1665364ruthlessnesses
seamlessnesses1446964seamlessnesses
selflessnesses15115984selflessnesses
sexlessnesses1846734_sexlessnesses
shamelessnesses18186504shamelessnesses
shapelessnesses18156284shapelessnesses
shiftlessnesses1954984shiftlessnesses
sightlessnesses1755024sightlessnesses
sinlessnesses1157964_sinlessnesses
skillessnesses1655604skillessnesses
soullessnesses1296484soullessnesses
stylelessnesses1674704stylelessnesses
tactfulnesses1855254tact_fulnesses
tastelessness1254184tastelessne_s_s
ticklishnesses2352384ticklishnesses
uselessnesses1147294_uselessnesses
valuelessnesses1764784valuelessnesses
voicelessnesses1955304voicelessnesses
waterlessnesses1754714waterlessnesses
winglessnesses1765454winglessnesses
wordlessnesses1775864wordlessnesses
worklessnesses20125474worklessnesses
worthlessnesses2054544worthlessnesses

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.1061685764.2
2DLD Change Limit658741013.14320959.0
3Display Results1011010.0761328.9
 (SQL Overall)1786911013.32553741.7
 
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.