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 “excusableness” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
excusableness245424(None) 
excitableness2455392excitableness
excusablenesses2664012excusablenesses
inexcusableness26122712inexcusableness
curableness1547313__curableness
equableness22146123e_qu_ableness
execrableness2454713execrableness
usableness1246503___usableness
advisableness1954414advisableness
capableness1745884__capableness
culpableness1853964__culpableness
durableness1446714__durableness
enjoyableness2554194enjoyableness
enviableness1756994e_nviableness
equitableness24105474equitableness
estimableness1754754estimableness
excessiveness2554964excessiveness
excitablenesses2664584excitablenesses
exclusiveness2554494exclus_iveness
excursiveness2554564excursiveness
excusable2044374excusabl__e__
immutableness1955034immutableness
incapableness1975234incapableness
infusibleness1874364infusibleness
laudableness1554734_laudableness
losableness1346034__losableness
peaceableness1955284peac_eableness
plausibleness1762994plausibleness
sociableness1655754soc_iableness
teachableness2054714teac_hableness
tunableness1345954__tunableness
valuableness1754784valu_ableness
acceptableness2263265acceptableness
accessibleness2061845accessibleness
accountableness2161835accountableness
accurateness1652885accura_teness
admirableness1855145admirableness
adorableness1556045_adorableness
agreeableness1654105agreeableness
amiableness1547165__amiableness
amicableness1856165_amicableness
availableness1854255availableness
curablenesses17146995__curablenesses
damnableness1755245_damnableness
dependableness2063125dependableness
deplorableness1963665deplorableness
desirableness1666955desirableness
despicableness2164125despicableness
detestableness1763775detestableness
doubleness1345785_dou__bleness
edibleness1345295e___dibleness
effusiveness2154935effus_iveness
elusiveness1466605e_lus_iveness
equablenesses2465535e_qu_ablenesses
excisable2045055excisabl__e__
excusably2343215excusabl____y
execrablenesses2674205execrablenesses
exhaustiveness2762795exhaustiveness
exquisiteness2962565exquisiteness
favorableness2154555favorableness
habitableness2054815habitableness
honorableness1854525honorableness
humbleness1744625__hu_mbleness
immovableness2254435immovableness
impassableness2063235impassableness
ineffableness2155605ineffableness
inexorableness2365035inex_orableness
inscrutableness1963325inscrutableness
invisibleness1854855invisibleness
irritableness1576135irritableness
laughableness1963115laughableness
likableness1755335__likableness
livableness1645915__livableness
lovableness1645595__lovableness
memorableness1955635memorableness
miserableness17145755miserableness
movableness1855735__movableness
notableness1347625__notableness
palatableness1754645palatableness
percussiveness2193735percussiveness
personableness1853965personableness
pitiableness1655525_pitiableness
pleasurableness1992155pleasurableness
pliableness1546605__pliableness
potableness1547195__potableness
provableness1955515_provableness
readableness1576265_readableness
reasonableness1663625reasonableness
reliableness1457135_reliableness
remarkableness2283355remarkableness
removableness2054855removableness
seasonableness1663325seasonableness
sensibleness1455405_sensibleness
separableness1755675separableness
sizableness2265595__sizableness
stableness1248825___stableness
suitableness1456305_suitableness
superableness17127525superableness
tenableness1347405__tenableness
terminableness1864485terminableness
thinkableness2253325thinkableness
tractableness1755035tractableness
unendurableness1872465unendurableness
unstableness1457125_unstableness
usablenesses1446745___usablenesses
variableness1756435_variableness
venerableness1856015venerableness
verifiableness2283325verifiableness
veritableness1856515veritableness
violableness1754885_violableness
visibleness1654815__visibleness
voidableness1854945_voidableness
volubleness1653695volu__bleness
workableness2154395_workableness

Search took 9 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 Filter1786911247900.406440125.6
2DLD Change Limit1247901148.00015598.8
3Display Results1141140.0801425.0
 (SQL Overall)1786911148.48621057.2
 
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.