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
programmability27101511programmability_
programmable2162035programmab_l___e
programmables2261365programmab_l__es
flammability2453896___flammability_
formability2146956_fo_r__mability_
inflammability2663456_inflammability_
nonflammability2771506nonflammability_
performability2663026perfor__mability_
permeability2157166p__er_meability_
polarizability3062496p_olarizability_
portability1849556p_o_r__tability_
pregnability2056156preg___nability_
probability2047696pro____bability_
processability2363036pro_cessability_
profitability2355126pro__fitability_
programmatic2163136programma____tic
promotability2254796pro__motability_
roadability1757196_ro__a_dability_
upgradability2253036_upgra_dability_
upgradeability2362426_upgradeability_
adorability1746897ado_r___ability_
agreeability1855157__agr_eeability_
amiability1748737_____amiability_
approachability2961617appro__achability_
bioavailability2571387bioavailability_
breathability2354077br__eathability_
comparability2454897_compa_rability_
confirmability2662587_confirmability_
crossability1956097cro___ssability_
drapability1986467___dra_pability_
drapeability2055907___drapeability_
erasability1668927___era_sability_
extractability28103547_extractability_
forgeability2154567_fo_r_geability_
formidability2463987_fo_rmidability_
grammaticality2471147___grammaticality_
impermeability2563907imper_meability_
intractability2155857_intractability_
irreformability2562027irreformability_
irrefragability2461947irrefra_gability_
irremovability2462937ir__removability_
irritability1747477ir__r_itability_
obtainability2053567__obtainability_
packability2446037p____ackability_
palatability1946377p__ala_tability_
palpability2046327p____alpability_
perdurability2154677p__erdurability_
perishability2365227p__erishability_
placability2047137p___la_cability_
playability2146017p___la_yability_
potability1749807p_o____tability_
practicability2553317pr_acticability_
predictability2454007pr_edictability_
preferability2355247pr__eferability_
presentability2164497pr_esentability_
preservability2453337pr_eservability_
preventability2464057pr_eventability_
printability1946857p___rintability_
processibility2363047pro_cessibility_
programming1954197programm____i_ng
programmings2052537programm____ings
progressivity2262947progr__essivity_
readability1748067_r__ea_dability_
recallability2054497_r_ecallability_
reformability2354637_r_eformability_
refrangibility2382597_refrangibility_
repairability2055847_r_epairability_
repeatability2056237_repea_tability_
reprogrammable2371457reprogrammab_l___e
retrievability2252897_retrievability_
sorbability1846367_so_r__bability_
spreadability2154397spr__ea_dability_
summability2045447____summability_
traceability1956527___traceability_
tractability1947087___tractability_
trainability1746847___trainability_
treatability1747427tr__ea_tability_
unprogrammable2371397unprogrammab_l___e
workability2345377_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.1061685764.2
2DLD Change Limit95024797.76612235.9
3Display Results79790.0631254.0
 (SQL Overall)178691797.93522519.3
 
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.