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

73 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
acceptableness226326(None) 
accessibleness2061843accessibleness
accountableness2161833accountableness
acceptable1844294acceptabl__e__
acceptingness2061734accept_ingness
agreeableness1654104agre_eableness
capableness1745894__cap_ableness
creditableness1954344_creditableness
culpableness1853964_culp_ableness
detestableness1763774detestableness
excitableness2455394exc_itableness
incapableness1975234incap_ableness
lamentableness1863584lamentableness
susceptibleness2171654susceptibleness
accentless1442565accent__l__ess
acceptabilities2354235acceptabilities
acceptably2153385acceptabl____y
acceptances1653175accepta___nces
acceptations1864505acceptation__s
acceptees15113715accept___e_e_s
accidentalness1971125accidenta_l_ness
accurateness1652885acc_ura_teness
acetylenes1552855a_ce_t_ylene_s
admirableness1855145a_dmirableness
adorableness1556045a__dorableness
advisableness1954415a_dvisableness
amiableness1547175a___miableness
amicableness1856165a__micableness
availableness1854265a_vailableness
charitableness2163925charitableness
comparableness2263545_comparableness
compatibleness2262615_compatibleness
conceivableness24102335conceivableness
curableness1547325__c_urableness
deceptiveness2155695decept_iveness
dependableness2063125dependableness
equableness22146125___equableness
equitableness24105475_equitableness
excusableness2454245exc_usableness
execrableness2454715_execrableness
habitableness2054815_habitableness
immutableness1955035_immutableness
ineffableness2155605_ineffableness
inevitableness1985665inevitableness
inheritableness2064185inheritableness
inimitableness1864995inimitableness
inscrutableness1963325inscrutableness
inseparableness1963685inseparableness
irreparableness1962795irreparableness
irritableness1576135_irritableness
miserableness17145755mise_rableness
notableness1347625___notableness
palatableness1754655_palatableness
peaceableness1955285peace__ableness
potableness1547205___potableness
presentableness1963305presentableness
profitableness2173815profitableness
readableness1576265__readableness
receptiveness2056125recept_iveness
reliableness1457135__reliableness
respectableness2162765respectableness
separableness1755685__separableness
sociableness1655755soc__iableness
stableness1248825____stableness
suitableness1456305__suitableness
superableness17127525supe_rableness
tenableness1347405__te_nableness
tractableness1755035_tractableness
undeniableness1764295undeniableness
unstableness1457125__unstableness
venerableness1856015vene_rableness
veritableness1856515_veritableness
warrantableness2062055warrantableness

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.360496363.9
2DLD Change Limit95024736.65614276.4
3Display Results73730.0631158.7
 (SQL Overall)178691737.07925242.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.