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

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

100 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
availability205549(None) 
mailability1847302_mailability
unavailability2263622unavailability
adaptability2055223adaptability
admirability2055713admirability
advisability2155063advisability
amiability1748743a_mi_ability
amicability2047323a_micability
attainability18103983attainability
availabilities1955753availabilities
availably1743253availab_l__y
bioavailability2571393bioavailability
coilability1847933_coilability
navigability2155443nav_igability
nonavailability2371953nonavailability
salability1548523_sa_lability
stainability1755683stainability
trainability1746853trainability
variability1947523_variability
viability1767883_v_i_ability
violability1946283_violability
actability1749084__actability
adoptability2054764adoptability
adorability1746904a_dorability
affability2145694__affability
agreeability1855164agreeability
alienability1745694alienability
alterability1747124alterability
amenability1847494a_menability
analyzability3053424analyzability
appealability2253964appealability
applicability24114064applicability
arability14411014__a_rability
assignability1962874assignability
assimilability2162474assimilability
assumability1954024assumability
audibility1645834audi__bility
available1444904availab_l__e
bankability2245244_bankability
bearability1847334bea_rability
capability1947594_ca_pability
castability1848414_castability
coagulability2153324coagulability
damageability2253194damageability
decidability2145744decidability
deniability1748734deni_ability
desirability1847274desirability
disability1649784__disability
drapability1986484dra_pability
drapeability2055914drapeability
drillability1854644drillability
drivability2046804_drivability
equitability2645774equitability
erasability1668934era_sability
excitability2655674excitability
fallibility1953894_fallibility
fatigability2154994fatigability
flammability2453904flammability
friability1847894_fri_ability
habitability2255094habitability
heritability2047984heritability
ignitability1856054ignitability
inability14411114___inability
invariability2155974invariability
inviability1978744invi_ability
inviolability2155114inviolability
irritability1747484irritability
lability13710834____lability
leachability2255254leachability
liability14128494__li_ability
likability1996134__likability
livability1886754__livability
machinability2573914machinability
malleability1954844_malleability
manageability2153914manageability
modulability2064214modulability
obtainability2053574obtainability
packability2446044_packability
palatability1946384pala_tability
palpability2046334_palpability
placability2047144pla_cability
playability2146024pla_yability
pliability1748054_pli_ability
readability1748074rea_dability
recallability2054504recallability
reliability1649464reli_ability
repairability2055854repairability
roadability1757204roa_dability
salvageability2361854salvageability
shareability2054924shareability
sociability1847924soci_ability
suitability1647114_suitability
traceability1956534traceability
tractability1947094tractability
unassailability2072324unassailability
visibility1846494_v_isibility
volatility1644864_v_olatility
volubility1844424_v_olubility
washability2245324_washability
wearability1947104wea_rability

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 Filter1786911247900.420425454.8
2DLD Change Limit1247901007.23617245.7
3Display Results1001000.0631587.3
 (SQL Overall)1786911007.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.