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

141 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
saplessnesses134726(None) 
haplessnesses1747241haplessnesses
lawlessnesses1546372lawlessnesses
raylessnesses1546492raylessnesses
saplessness1245982saplessne_s_s
seamlessnesses1446962seamlessnesses
sexlessnesses1846732sexlessnesses
shapelessnesses18156282shapelessnesses
sinlessnesses1157962sinlessnesses
toplessnesses1446562toplessnesses
agelessnesses1387613agelessnesses
aimlessnesses1487453aimlessnesses
airlessnesses12117983airlessnesses
artlessnesses1247653artlessnesses
carelessnesses1547713carelessnesses
endlessnesses1356753endlessnesses
facelessnesses1847313facelessnesses
fearlessnesses1666723fearlessnesses
flawlessnesses1975443flawlessnesses
godlessnesses1446573godlessnesses
gutlessnesses1346923gutlessnesses
hairlessnesses16126623hairlessnesses
haplessness1645663haplessne_s_s
harmlessnesses1876403harmlessnesses
headlessnesses17137053headlessnesses
helplessnesses1855793helplessnesses
hopelessnesses18147003hopelessnesses
joblessnesses2155973joblessnesses
joylessnesses2255633joylessnesses
landlessnesses1456673landlessnesses
namelessnesses1577043namelessnesses
painlessnesses1546723painlessnesses
pathlessnesses1855943pathlessnesses
planlessnesses1576293planlessnesses
selflessnesses15115983selflessnesses
shamelessnesses18186503shamelessnesses
skillessnesses1655603skillessnesses
sleeplessnesses1554673sleeplessnesses
soullessnesses1296483soullessnesses
spotlessnesses1456263spotlessnesses
statelessnesses1355853statelessnesses
tactlessnesses1546543tactlessnesses
uselessnesses1147293uselessnesses
witlessnesses1547223witlessnesses
alertnesses1147224_a_lertnesses
amplenesses1585704ample__nesses
apishnesses1646374_ap_ishnesses
bassnesses1136834ba___ssnesses
blamelessnesses1865704blamelessnesses
bootlessnesses1556434bootlessnesses
brainlessnesses1665004brainlessnesses
callousnesses1556444callousnesses
ceaselessnesses1596154ceaselessnesses
classlessnesses054824classlessnesses
dappernesses1743244dappe_rnesses
dauntlessnesses1554804dauntlessnesses
deathlessnesses1885164deathlessnesses
dreamlessnesses17104524dreamlessnesses
earnestnesses1353644earnestnesses
faithlessnesses2074964faithlessnesses
falsenesses1446744fa_l_senesses
faultlessnesses1754924faultlessnesses
fecklessnesses2255484fecklessnesses
foodlessnesses1755754foodlessnesses
footlessnesses1656554footlessnesses
formlessnesses1856104formlessnesses
gracelessnesses1755894gracelessnesses
halenesses13312034ha_le__nesses
heartlessnesses1765764heartlessnesses
heedlessnesses17136214heedlessnesses
homelessnesses18137464homelessnesses
hornlessnesses1656264hornlessnesses
lawlessness1444894lawlessne_s_s
lifelessnesses1646644lifelessnesses
listlessnesses1266914listlessnesses
lovelessnesses1646984lovelessnesses
malenesses12312204ma_le__nesses
mindlessnesses1686004mindlessnesses
movelessnesses1846734movelessnesses
needlessnesses14115684needlessnesses
palenesses12312654pa_le__nesses
paperinesses1646044pap_erinesses
pitilessnesses1575734pitilessnesses
plotlessnesses1556084plotlessnesses
plushnesses1645574__plushnesses
raylessness1445104raylessne_s_s
recklessnesses1955834recklessnesses
repletenesses1554474repletenesses
restlessnesses1257214restlessnesses
rootlessnesses1346584rootlessnesses
ruthlessnesses1665364ruthlessnesses
sacrednesses1544864sacre_dnesses
safenesses1349374sa_fe__nesses
sagenesses11510824sa_ge__nesses
sallownesses1542734sa_llownesses
saltinesses11311444sa_l_tinesses
saltnesses10310164sa_l__tnesses
samenesses12410854sa_me__nesses
sanenesses10412694sa_ne__nesses
sappinesses1567564sap__pinesses
sassinesses999314sa__ssinesses
seamlessness1355894seamlessne_s_s
selectnesses1446104s_electnesses
senselessnesses055694senselessnesses
sexlessness1745314sexlessne_s_s
shapelessness1754964shapelessne_s_s
shapelinesses1843414shap_elinesses
shiftlessnesses1954984shiftlessnesses
sightlessnesses1755024sightlessnesses
silentnesses1275444s_ilentnesses
simplenesses1645614simple__nesses
sinlessness1046714sinlessne_s_s
sleeknesses1545274s__leeknesses
snappishnesses2052264snappishnesses
solemnnesses1443634s_olemnnesses
solenesses10412704s_ole__nesses
sparenesses1339174spare__nesses
sparsenesses1345804s_parsenesses
speedinesses1545594s_peedinesses
spinelessnesses1555484spinelessnesses
splashinesses1742734s_plashinesses
stablenesses1448074stable__nesses
stalenesses11311084stale__nesses
stylelessnesses1674704stylelessnesses
stylishnesses1843404stylishnesses
sullennesses1244344sulle_nnesses
superbnesses1695564sup_erbnesses
supplenesses1643974supple__nesses
supremenesses1753174supremenesses
tastelessnesses1355264tastelessnesses
thanklessnesses2154794thanklessnesses
timelessnesses1547014timelessnesses
tirelessnesses1357004tirelessnesses
tonelessnesses13137634tonelessnesses
toplessness1345384toplessne_s_s
usablenesses1446714usable__nesses
valuelessnesses1764784valuelessnesses
waterlessnesses1754714waterlessnesses
winglessnesses1765454winglessnesses
wordlessnesses1775864wordlessnesses
worklessnesses20125474worklessnesses

Search took 8 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.1231452772.4
2DLD Change Limit950241417.05013478.6
3Display Results1411410.0931516.1
 (SQL Overall)1786911417.26624592.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.