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

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

79 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
programmability27101521programmability_
programmable2162045programmab_l___e
programmables2261375programmab_l__es
flammability2453906___flammability_
formability2146966_fo_r__mability_
inflammability2663466_inflammability_
nonflammability2771516nonflammability_
performability2663036perfor__mability_
permeability2157176p__er_meability_
polarizability3062506p_olarizability_
portability1849566p_o_r__tability_
pregnability2056166preg___nability_
probability2047706pro____bability_
processability2363046pro_cessability_
profitability2355136pro__fitability_
programmatic2163146programma____tic
promotability2254806pro__motability_
roadability1757206_ro__a_dability_
upgradability2253046_upgra_dability_
upgradeability2362436_upgradeability_
adorability1746907ado_r___ability_
agreeability1855167__agr_eeability_
amiability1748747_____amiability_
approachability2961627appro__achability_
bioavailability2571397bioavailability_
breathability2354087br__eathability_
comparability2454907_compa_rability_
confirmability2662597_confirmability_
crossability1956107cro___ssability_
drapability1986477___dra_pability_
drapeability2055917___drapeability_
erasability1668937___era_sability_
extractability28103557_extractability_
forgeability2154577_fo_r_geability_
formidability2463997_fo_rmidability_
grammaticality2471157___grammaticality_
impermeability2563917imper_meability_
intractability2155867_intractability_
irreformability2562037irreformability_
irrefragability2461957irrefra_gability_
irremovability2462947ir__removability_
irritability1747487ir__r_itability_
obtainability2053577__obtainability_
packability2446047p____ackability_
palatability1946387p__ala_tability_
palpability2046337p____alpability_
perdurability2154687p__erdurability_
perishability2365237p__erishability_
placability2047147p___la_cability_
playability2146027p___la_yability_
potability1749817p_o____tability_
practicability2553327pr_acticability_
predictability2454017pr_edictability_
preferability2355257pr__eferability_
presentability2164507pr_esentability_
preservability2453347pr_eservability_
preventability2464067pr_eventability_
printability1946867p___rintability_
processibility2363057pro_cessibility_
programming1954207programm____i_ng
programmings2052547programm____ings
progressivity2262957progr__essivity_
readability1748077_r__ea_dability_
recallability2054507_r_ecallability_
reformability2354647_r_eformability_
refrangibility2382607_refrangibility_
repairability2055857_r_epairability_
repeatability2056247_repea_tability_
reprogrammable2371467reprogrammab_l___e
retrievability2252907_retrievability_
sorbability1846377_so_r__bability_
spreadability2154407spr__ea_dability_
summability2045457____summability_
traceability1956537___traceability_
tractability1947097___tractability_
trainability1746857___trainability_
treatability1747437tr__ea_tability_
unprogrammable2371407unprogrammab_l___e
workability2345387_wo_r__kability_

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.1231452772.4
2DLD Change Limit95024797.69012356.8
3Display Results79790.0601316.7
 (SQL Overall)178691797.87322696.7
 
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.