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

85 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
unavailability226362(None) 
availability2055492__availability
nonavailability2371952nonavailability
unassailability2072322unassailability
bioavailability2571393bioavailability
navigability2155443_nav_igability
inadvisability2374194inadvisability
inevitability2156964inev_itability
invariability2155974in_variability
inviability1978744in_v_i_ability
inviolability2155114in_violability
mailability1847304___mailability
unalterability1963474unalterability
unavailable1654684unavailab_l__e
undecidability2363104undecidability
undesirability2063934undesirability
unflappability2682334unflappability
unpalatability2163094unpala_tability
unreliability1855604unreli_ability
unsociability2054894unsoci_ability
unsuitability1865134un_suitability
adaptability2055225__adaptability
admirability2055715__admirability
advisability2155065__advisability
amiability1748745__a_mi_ability
amicability2047325__a_micability
analyzability3053425ana_lyzability
appealability2253965appea_lability
assimilability2162475assimilability
attainability18103985_attainability
availabilities1955755__availabilities
availably1743255__availab_l__y
coagulability2153325coa_gulability
coilability1847935___coilability
damageability2253195_damageability
fatigability2154995_fa_tigability
habitability2255095_ha_bitability
inalienability1954555inalienability
inalterability1954565inalterability
inapplicability26102925inapplicability
inaudibility1855305inaudi__bility
incalculability2462215incalculability
incapability2156515in_ca_pability
indefinability2384795indefinability
indomitability2254835indomitability
indubitability2264075indubitability
ineradicability2383385ineradicability
infallibility2164305in_fallibility
inflammability2663465inflammability
inheritability2255605inheritability
insatiability1856495in_satiability
insociability2056225insoci_ability
intractability2155865intractability
invisibility2056035in_v_isibility
machinability2573915_machinability
manageability2153915_manageability
manipulability2362035manipulability
obtainability2053575_obtainability
palatability1946385_pala_tability
practicability2553325practicability
recallability2054505_recallability
repairability2055855_repairability
salability1548525___sa_lability
salvageability2361855salvageability
stainability1755685__stainability
survivability2453185surv_ivability
sustainability1962345sustainability
trafficability2762255trafficability
trainability1746855__trainability
unacceptability2681945unacceptability
unanswerability2362105unanswerability
unassailably1762425unassailab_l__y
unavailingly1951755unavail__ingly
unavoidably2052645unavoidab_l__y
unchangeability2672025unchangeability
unknowability2572345un_knowability
untenability1756425un__tenability
unthinkability2662355unthinkability
untouchability2462285untouchability
unworkability2552905un_workability
upgradability2253045upgra_dability
upgradeability2362435upgradeability
variability1947525___variability
viability1767875___v_i_ability
violability1946275___violability

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.360496363.9
2DLD Change Limit95024856.67014246.5
3Display Results85850.0631349.2
 (SQL Overall)178691857.09325192.6
 
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.