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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
excusablenesses266401(None) 
excitablenesses2664582excitablenesses
excusableness2454242excusablene_s_s
curablenesses17146993__curablenesses
equablenesses2465533e_qu_ablenesses
execrablenesses2674203execrablenesses
usablenesses1446743___usablenesses
advisablenesses21113954advisablenesses
capablenesses1955454__capablenesses
culpablenesses2053904__culpablenesses
durablenesses16156584__durablenesses
enjoyablenesses2773554enjoyablenesses
enviablenesses1965924e_nviablenesses
equitablenesses26104354equitablenesses
estimablenesses1954094estimablenesses
excessivenesses2675144excessivenesses
excitableness2455394excitablene_s_s
exclusivenesses2764664exclus_ivenesses
excursivenesses2794734excursivenesses
immutablenesses2164164immutablenesses
incapablenesses2184264incapablenesses
inexcusableness26122714inexcusablene_s_s
infusiblenesses2063774infusiblenesses
laudablenesses1754304_laudablenesses
losablenesses1596074__losablenesses
peaceablenesses2184334peac_eablenesses
plausiblenesses1973134plausiblenesses
sociablenesses1855124soc_iablenesses
teachablenesses2283844teac_hablenesses
tunablenesses1555844__tunablenesses
valuablenesses1954694valu_ablenesses
accuratenesses1853085accura_tenesses
admirablenesses2074355admirablenesses
adorablenesses1755445_adorablenesses
agreeablenesses1873365agreeablenesses
amiablenesses1756535__amiablenesses
amicablenesses2055215_amicablenesses
availablenesses2063735availablenesses
curableness1547315__curablene_s_s
damnablenesses1954615_damnablenesses
desirablenesses1855615desirablenesses
doublenesses1546515_dou__blenesses
ediblenesses1545835e___diblenesses
effusivenesses2355745effus_ivenesses
elusivenesses1697705e_lus_ivenesses
equableness22146125e_qu_ablene_s_s
execrableness2454715execrablene_s_s
exquisitenesses3162795exquisitenesses
favorablenesses2354125favorablenesses
habitablenesses2254055habitablenesses
honorablenesses2064205honorablenesses
humblenesses1944975__hu_mblenesses
immovablenesses2493805immovablenesses
ineffablenesses2364015ineffablenesses
invisiblenesses2094215invisiblenesses
irritablenesses1755055irritablenesses
laughablenesses2183145laughablenesses
likablenesses1995445__likablenesses
livablenesses18125845__livablenesses
lovablenesses18115845__lovablenesses
memorablenesses2154835memorablenesses
miserablenesses1954665miserablenesses
movablenesses20135655__movablenesses
notablenesses1546655__notablenesses
palatablenesses1973945palatablenesses
pitiablenesses1855065_pitiablenesses
pliablenesses1756075__pliablenesses
potablenesses1746505__potablenesses
provablenesses2154895_provablenesses
readablenesses1755205_readablenesses
reliablenesses1655815_reliablenesses
removablenesses2264255removablenesses
sensiblenesses1555255_sensiblenesses
separablenesses1954785separablenesses
sizablenesses2445405__sizablenesses
stablenesses1448105___stablenesses
suitablenesses1655435_suitablenesses
superablenesses1964905superablenesses
tenablenesses1546655__tenablenesses
thinkablenesses2463025thinkablenesses
tractablenesses1964055tractablenesses
unstablenesses1656035_unstablenesses
usableness1246505___usablene_s_s
variablenesses1965495_variablenesses
venerablenesses2074805venerablenesses
veritablenesses2055085veritablenesses
violablenesses1984735_violablenesses
visiblenesses1855325__visiblenesses
voidablenesses2054735_voidablenesses
volublenesses1854565volu__blenesses
workablenesses2354445_workablenesses

Search took 5 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.310576422.6
2DLD Change Limit65874914.05016265.2
3Display Results91910.0601516.7
 (SQL Overall)178691914.42040427.8
 
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.