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

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
programmability2710152(None) 
programmable2162044programmab_l__e
programmables2261374programmab_l_es
flammability2453905___flammability
formability2146965_fo_r__mability
inflammability2663465_inflammability
nonflammability2771515nonflammability
performability2663035perfor__mability
permeability2157175p__er_meability
polarizability3062505p_olarizability
portability1849565p_o_r__tability
pregnability2056165preg___nability
probability2047705pro____bability
processability2363045pro_cessability
profitability2355135pro__fitability
programmatic2163145programma__ti_c
promotability2254805pro__motability
roadability1757205_ro__a_dability
upgradability2253045_upgra_dability
upgradeability2362435_upgradeability
adorability1746906ado_r___ability
agreeability1855166__agr_eeability
amiability1748746_____amiability
approachability2961626appro__achability
bioavailability2571396bioavailability
breathability2354086br__eathability
comparability2454906_compa_rability
confirmability2662596_confirmability
crossability1956106cro___ssability
drapability1986476___dra_pability
drapeability2055916___drapeability
erasability1668936___era_sability
extractability28103556_extractability
forgeability2154576_fo_r_geability
formidability2463996_fo_rmidability
grammaticality2471156___grammaticality
impermeability2563916imper_meability
intractability2155866_intractability
irreformability2562036irreformability
irrefragability2461956irrefra_gability
irremovability2462946ir__removability
irritability1747486ir__r_itability
obtainability2053576__obtainability
packability2446046p____ackability
palatability1946386p__ala_tability
palpability2046336p____alpability
perdurability2154686p__erdurability
perishability2365236p__erishability
placability2047146p___la_cability
playability2146026p___la_yability
potability1749816p_o____tability
practicability2553326pr_acticability
predictability2454016pr_edictability
preferability2355256pr__eferability
presentability2164506pr_esentability
preservability2453346pr_eservability
preventability2464066pr_eventability
printability1946866p___rintability
processibility2363056pro_cessibility
programming1954206programm____ing
programmings2052546programm__i_ngs
progressivity2262956progr__essivity
readability1748076_r__ea_dability
recallability2054506_r_ecallability
reformability2354646_r_eformability
refrangibility2382606_refrangibility
repairability2055856_r_epairability
repeatability2056246_repea_tability
reprogrammable2371466reprogrammab_l__e
retrievability2252906_retrievability
sorbability1846376_so_r__bability
spreadability2154406spr__ea_dability
summability2045456____summability
traceability1956536___traceability
tractability1947096___tractability
trainability1746856___trainability
treatability1747436tr__ea_tability
unprogrammable2371406unprogrammab_l__e
workability2345386_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.343520965.0
2DLD Change Limit95024796.62614341.1
3Display Results79790.0601316.7
 (SQL Overall)178691797.02925422.0
 
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.