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

87 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
advisability215506(None) 
admirability2055712admirability
disability1649772_d_isability
inadvisability2374192inadvisability
adaptability2055223adaptability
adjustability2652983adjustability
admissibility2183123admissibility
adoptability2054763adoptability
adorability1746903ad_orability
advisabilities2055573advisabilities
advisably1843073advisab_l__y
amiability1748743a_mi_ability
amicability2047323a_micability
availability2055493availability
divisibility2153943divisibility
drivability2046793_drivability
inviability1978743invi_ability
invisibility2056033invisibility
navigability2155443navigability
viability1767873__vi_ability
visibility1846483__visibility
actability1749084a__ctability
addressability2172174addressability
advisable1544574advisab_l__e
affability2145684a__ffability
agreeability1855164agreeability
alienability1745694alienability
alterability1747124alterability
amenability1847494a_menability
applicability24114064applicability
arability14411014a___rability
assignability1962874assignability
assumability1954024assumability
attainability18103984attainability
audibility1645834audi__bility
coilability1847934_coilability
crossability1956104crossability
decidability2145744decidability
deniability1748724_deniability
desirability1847274desirability
disutility1454624_d_isutility
drapability1986474_drapability
drillability1854634_drillability
drinkability2254694_drinkability
driveability2155094_driveability
durability1647734_d_urability
dyeability1945884_d_yeability
edibility1546924ed_i__bility
educability1946244ed_ucability
equitability2645774equitability
erasability1668934_erasability
excitability2655674excitability
fatigability2154994fatigability
fishability2245284__fishability
friability1847894_fri_ability
habitability2255094habitability
heritability2047984heritability
ignitability1856054ignitability
inability14411104___inability
indivisibility2373664indivisibility
inevitability2156964inevitability
inviolability2155114inviolability
irritability1747484irritability
liability14128484__li_ability
likability1996124__likability
livability1886744__livability
liveability1945794liv_eability
lovability18106934lov__ability
machinability2573914machinability
mailability1847304_mailability
movability2077234mov__ability
opposability2154394opposability
perishability2365234perishability
pliability1748054_pli_ability
punishability2353304punishability
reliability1649464reli_ability
reusability1648474_reusability
risibility1547544__risibility
severability2046754severability
sociability1847924soci_ability
stainability1755684stainability
suitability1647114_suitability
survivability2453184survivability
trainability1746854trainability
usability1447164___usability
variability1947524vari_ability
violability1946274__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 Filter1786911247900.390458182.1
2DLD Change Limit124790876.92018033.2
3Display Results87870.0631381.0
 (SQL Overall)178691877.37324235.9
 
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.