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

96 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
bioavailability2571391bioavailability_
availability2055494___availability_
nonavailability2371954nonavailability_
unavailability2263624_unavailability_
bioavailable196655bioavailab_l___e
availabilities1955756___availabilities
coagulability2153326_coa_gulability_
coilability1847936_co___ilability_
inadvisability2374196_inadvisability_
inevitability2156966_inev_itability_
invariability2155976_i_nvariability_
inviability1978746_i_nv_i_ability_
inviolability2155116_i_nviolability_
mailability1847306____mailability_
navigability2155446__nav_igability_
obtainability2053576__obtainability_
unassailability2072326unassailability_
violability1946276vio____lability_
adaptability2055227___adaptability_
admirability2055717___admirability_
advisability2155067___advisability_
amiability1748747___a_mi_ability_
amicability2047327___a_micability_
appealability2253967_appea_lability_
assimilability2162477_assimilability_
attainability18103987__attainability_
availably1743257___availab_l__y_
bankability2245247b____ankability_
bearability1847337b___ea_rability_
biddability2043847bi____ddability_
breathability2354087b__reathability_
codifiability2473627_codifi_ability_
comparability2454907_compa_rability_
conceivability2663267_conceivability_
damageability2253197__damageability_
dilatability1845457di__la_tability_
dissociability2262997dissoci_ability_
divisibility2153947di__v_isibility_
fatigability2154997__fa_tigability_
formidability2463997_fo_rmidability_
habitability2255097__ha_bitability_
ignitability1856057_i__gnitability_
illimitability2162897_illimitability_
impalpability2454117_i_mpalpability_
impassability2265267_i_mpassability_
implacability2454887_impla_cability_
inalienability1954557_inalienability_
inalterability1954567_inalterability_
inapplicability26102927_inapplicability_
inaudibility1855307_inaudi__bility_
incalculability2462217incalculability_
incapability2156517_i_nca_pability_
indefinability2384797_indefinability_
indomitability2254837_indomitability_
indubitability2264077_indubitability_
ineradicability2383387_ineradicability_
infallibility2164307_i_nfallibility_
inflammability2663467_inflammability_
inheritability2255607_inheritability_
insatiability1856497_i_nsatiability_
insociability2056227_insoci_ability_
intractability2155867_intractability_
invisibility2056037_i_nv_isibility_
irascibility1985417_irasci__bility_
irritability1747487_i__rritability_
livability1886747li__v___ability_
liveability1945797li__v__eability_
localizability3062187_localizability_
lovability18106937_lo_v___ability_
machinability2573917__machinability_
maintainability2261577maintainability_
manageability2153917__manageability_
modifiability2463167_modifi_ability_
modulability2064217_mo__dulability_
movability2077237_mo_v___ability_
palatability1946387__pala_tability_
polarizability3062507_polarizability_
practicability2553327_practicability_
profitability2355137pro__fitability_
programmability27101527programmability_
recallability2054507__recallability_
reconcilability2492417reconcilability_
repairability2055857__repairability_
roadability1757207_ro__a_dability_
salability1548527____sa_lability_
salvageability2361857_salvageability_
sociability1847927_so__ci_ability_
solvability1946417_solv___ability_
stainability1755687___stainability_
survivability2453187_surv_ivability_
sustainability1962347_sustainability_
trafficability2762257_trafficability_
trainability1746857___trainability_
unpalatability2163097unpala_tability_
variability1947527____variability_
viability1767877____v_i_ability_

Search took 9 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 Limit95024968.55011113.9
3Display Results96960.0601600.0
 (SQL Overall)178691968.95319958.8
 
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.