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

80 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
detestableness176377(None) 
dependableness2063123dependableness
acceptableness2263264acceptableness
deplorableness1963664deplorableness
desirableness1666954de_sirableness
despicableness2164124despicableness
detestable13136504detestabl__e__
equitableness24105474_equitableness
excitableness2455394_excitableness
execrableness2454714_execrableness
lamentableness1863584lamentableness
presentableness1963304presentableness
respectableness2162764respectableness
stableness1248824____stableness
tenableness1347404__te_nableness
unstableness1457124__unstableness
venerableness1856014vene_rableness
veritableness1856514ve_ritableness
accessibleness2061845accessibleness
advisableness1954415advis_ableness
agreeableness1654105agre_eableness
charitableness2163925charitableness
creditableness1954345creditableness
damnableness1755245d__amnableness
deceitfulness1963545deceitful_ness
deceptiveness2155695decept_iveness
defectiveness2256545defect_iveness
delectables16144335delectabl__e_s
detailedness1453195d__e_tailedness
detectable15136605detectabl__e__
detestably16144395detestabl____y
detestations1347585detestation__s
durableness1446715d___urableness
enjoyableness2554195_enjoyableness
enviableness1756995_e_nviableness
equableness22146125___equableness
estimableness1754755_estimableness
eternalness1153825_eterna_l_ness
excusableness2454245_excusableness
feebleness1544895fe_e___bleness
habitableness2054815_habitableness
immutableness1955035_immutableness
impassableness2063235impassableness
ineffableness2155605_ineffableness
inevitableness1985665inevitableness
inheritableness2064185inheritableness
inimitableness1864995inimitableness
irritableness1576135_irritableness
losableness1346035__los_ableness
memorableness1955635me_morableness
miserableness17145755mise_rableness
notableness1347625___notableness
palatableness1754645_palatableness
peaceableness1955285pe_aceableness
personableness1853965personableness
pitiableness1655525pit__iableness
potableness1547195___potableness
profitableness2173815profitableness
readableness1576265__readableness
reasonableness1663625reasonableness
reliableness1457135__reliableness
remarkableness2283355remarkableness
removableness2054855re_movableness
retentiveness1657165retent_iveness
seasonableness1663325seasonableness
sensibleness1455405se_ns_ibleness
separableness1755675se_parableness
staleness9310785____sta_leness
suitableness1456305__suitableness
superableness17127525supe_rableness
teachableness2054715te_achableness
terminableness1864485terminableness
terribleness1454835__terribleness
tractableness1755035_tractableness
tunableness1345955__t_unableness
undeniableness1764295undeniableness
undesirableness18103625undesirableness
usableness1246505___us_ableness
verifiableness2283325verifiableness
versatileness1654015ve_rsatileness

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.343520965.0
2DLD Change Limit95024806.84313886.3
3Display Results80800.0631269.8
 (SQL Overall)178691807.24924650.4
 
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.