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

83 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
statelessnesses135585(None) 
shamelessnesses18186502shamelessnesses
shapelessnesses18156282shapelessnesses
statelessness1255142statelessne_s_s
stylelessnesses1674702stylelessnesses
tastelessnesses1355262_tastelessnesses
agelessnesses1387613__agelessnesses
blamelessnesses1865703blamelessnesses
carelessnesses1547713_carelessnesses
ceaselessnesses1596153ceaselessnesses
deathlessnesses1885163deathlessnesses
facelessnesses1847313_facelessnesses
gracelessnesses1755893gracelessnesses
namelessnesses1577043_namelessnesses
pathlessnesses1855943_pathlessnesses
saplessnesses1347263s_a_plessnesses
seamlessnesses1446963sea_mlessnesses
senselessnesses055693senselessnesses
spinelessnesses1555483spinelessnesses
spotlessnesses1456263spot_lessnesses
statelinesses1344233statel__inesses
tactlessnesses1546543_tactlessnesses
timelessnesses1547013_timelessnesses
tirelessnesses1357003_tirelessnesses
tonelessnesses13137633_tonelessnesses
waterlessnesses1754713_waterlessnesses
aimlessnesses1487454__aimlessnesses
airlessnesses12117984__airlessnesses
artlessnesses1247654__artlessnesses
bootlessnesses1556434boot_lessnesses
brainlessnesses1665004brainlessnesses
classlessnesses054824classlessnesses
faithlessnesses2074964faithlessnesses
fearlessnesses1666724fea_rlessnesses
fencelessnesses1995344fencelessnesses
flawlessnesses1975444fla_wlessnesses
footlessnesses1656554foot_lessnesses
guilelessnesses15195304guilelessnesses
gutlessnesses1346924_gut_lessnesses
hairlessnesses16126624_hairlessnesses
haplessnesses1747244_ha_plessnesses
harmlessnesses1876404_harmlessnesses
headlessnesses17137054hea_dlessnesses
heartlessnesses1765764heartlessnesses
homelessnesses18137464_homelessnesses
hopelessnesses18147004_hopelessnesses
houselessnesses1665654houselessnesses
landlessnesses1456674_landlessnesses
lawlessnesses1546374_la_wlessnesses
lifelessnesses1646644_lifelessnesses
listlessnesses1266914list_lessnesses
lovelessnesses1646984_lovelessnesses
movelessnesses1846734_movelessnesses
nervelessnesses1754954nervelessnesses
painlessnesses1546724_painlessnesses
pitilessnesses1575734_pitilessnesses
planlessnesses1576294pla_nlessnesses
plotlessnesses1556084plot_lessnesses
raylessnesses1546494_ra_ylessnesses
restlessnesses1257214rest_lessnesses
rootlessnesses1346584root_lessnesses
ruthlessnesses1665364_ruthlessnesses
selflessnesses15115984s_elflessnesses
sexlessnesses1846734s__exlessnesses
shamelessness1754964shamelessne_s_s
shapelessness1754964shapelessne_s_s
shiftlessnesses1954984shiftlessnesses
sightlessnesses1755024sightlessnesses
sinlessnesses1157964s__inlessnesses
skillessnesses1655604s_killessnesses
sleeplessnesses1554674sleeplessnesses
soullessnesses1296484s_oullessnesses
stablenesses1448074sta_ble__nesses
stalenesses11311084sta__le__nesses
stylelessness1553414stylelessne_s_s
tastelessness1254184_tastelessne_s_s
thanklessnesses2154794thanklessnesses
toplessnesses1446564_t_oplessnesses
uselessnesses1147294__uselessnesses
valuelessnesses1764784valuelessnesses
voicelessnesses1955304voicelessnesses
witlessnesses1547224_wit_lessnesses
worthlessnesses2054544worthlessnesses

Search took 3 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 Filter178691435480.0802233637.5
2DLD Change Limit43548832.67016310.1
3Display Results83830.0631317.5
 (SQL Overall)178691832.81363523.3
 
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.