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
capableness1745884__cap_ableness
creditableness1954334_creditableness
culpableness1853954_culp_ableness
detestableness1763754detestableness
excitableness2455364exc_itableness
incapableness1975234incap_ableness
lamentableness1863584lamentableness
susceptibleness2171644susceptibleness
accentless1442565accent__l__ess
acceptabilities2354225acceptabilities
acceptably2153385acceptabl____y
acceptances1653175accepta___nces
acceptations1864505acceptation__s
acceptees15113695accept___e_e_s
accidentalness1971125accidenta_l_ness
accurateness1652885acc_ura_teness
acetylenes1552845a_ce_t_ylene_s
admirableness1855135a_dmirableness
adorableness1556045a__dorableness
advisableness1954405a_dvisableness
amiableness1547155a___miableness
amicableness1856145a__micableness
availableness1854245a_vailableness
charitableness2163915charitableness
comparableness2263545_comparableness
compatibleness2262605_compatibleness
conceivableness24102335conceivableness
curableness1547305__c_urableness
deceptiveness2155695decept_iveness
dependableness2063125dependableness
equableness22146095___equableness
equitableness24105425_equitableness
excusableness2454235exc_usableness
execrableness2454705_execrableness
habitableness2054795_habitableness
immutableness1955025_immutableness
ineffableness2155605_ineffableness
inevitableness1985655inevitableness
inheritableness2064185inheritableness
inimitableness1864985inimitableness
inscrutableness1963315inscrutableness
inseparableness1963685inseparableness
irreparableness1962795irreparableness
irritableness1576115_irritableness
miserableness17145755mise_rableness
notableness1347615___notableness
palatableness1754635_palatableness
peaceableness1955285peace__ableness
potableness1547185___potableness
presentableness1963305presentableness
profitableness2173805profitableness
readableness1576265__readableness
receptiveness2056125recept_iveness
reliableness1457125__reliableness
respectableness2162765respectableness
separableness1755675__separableness
sociableness1655745soc__iableness
stableness1248815____stableness
suitableness1456265__suitableness
superableness17127525supe_rableness
tenableness1347395__te_nableness
tractableness1755025_tractableness
undeniableness1764295undeniableness
unstableness1457105__unstableness
venerableness1856015vene_rableness
veritableness1856495_veritableness
warrantableness2062055warrantableness

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 Filter178691950240.1231452772.4
2DLD Change Limit95024738.30011448.7
3Display Results73730.0601216.7
 (SQL Overall)178691738.48321064.6
 
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.