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

54 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
excitableness245539(None) 
equitableness24105472equitableness
excitablenesses2664582excitablenesses
excusableness2454242excusableness
enviableness1756993envi_ableness
estimableness1754753estimableness
execrableness2454713execrableness
habitableness2054813habitableness
irritableness1576133irritableness
sociableness1655753soci_ableness
suitableness1456303_suitableness
veritableness1856513veritableness
acceptableness2263264acceptableness
admirableness1855144admirableness
advisableness1954414advisableness
amiableness1547164_ami_ableness
amicableness1856164_amicableness
availableness1854254availableness
capableness1745884__capableness
charitableness2163924charitableness
creditableness1954344creditableness
curableness1547314__curableness
desirableness1666954desirableness
despicableness2164124despicableness
detestableness1763774detestableness
edibleness1345294e_di__bleness
enjoyableness2554194enjoyableness
equableness22146124e__quableness
equitablenesses26104354equitablenesses
excitable2056244excitabl__e__
excusablenesses2664014excusablenesses
immutableness1955034immutableness
incapableness1975234incapableness
inevitableness1985664inevitableness
inexcusableness26122714inexcusableness
inimitableness1864994inimitableness
likableness1755334__likableness
livableness1645914__livableness
notableness1347624__notableness
palatableness1754644palatableness
peaceableness1955284peac_eableness
pitiableness1655524__pitiableness
pliableness1546604_pli_ableness
potableness1547194__potableness
profitableness2173814profitableness
reliableness1457134reli_ableness
sizableness2265594__sizableness
stableness1248824___stableness
teachableness2054714teac_hableness
terminableness1864484terminableness
tractableness1755034tractableness
unstableness1457124_unstableness
variableness1756434vari_ableness
voidableness1854944_voidableness

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 Filter178691950240.360496363.9
2DLD Change Limit95024544.57620765.7
3Display Results54540.0331636.4
 (SQL Overall)178691544.96935961.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.