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

83 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
navigability215544(None) 
fatigability2154992fatigability
advisability2155063advisability
amiability1748743_ami_ability
amicability2047323_amicability
availability2055493_availability
habitability2255093habitability
inadvisability2374193inadvisability
inevitability2156963inevitability
inviability1978743invi_ability
mailability1847303ma_ilability
navigabilities2064963navigabilities
navigably1843433navigab_l__y
unavailability2263623unavailability
variability1947523vari_ability
viability1767873__vi_ability
actability1749084_a_ctability
admirability2055714admirability
adorability1746904_adorability
affability2145684_a_ffability
alienability1745694_alienability
amenability1847494_amenability
analyzability3053424analyzability
arability14411014_a__rability
assignability1962874assignability
bankability2245244ba_nkability
capability1947594ca__pability
castability1848414ca_stability
coilability1847934_coilability
damageability2253194damageability
decidability2145744decidability
deniability1748724deni_ability
desirability1847274desirability
disability1649774__disability
divisibility2153944divisibility
drivability2046794_drivability
driveability2155094driveability
eligibility1754834_eligibility
equitability2645774equitability
excitability2655674excitability
friability1847894_fri_ability
hatchability2553774hatchability
heritability2047984heritability
ignitability1856054ignitability
inability14411104___inability
inalienability1954554inalienability
ineligibility1955204ineligibility
insatiability1856494insati_ability
invariability2155974invariability
inviolability2155114inviolability
invisibility2056034invisibility
irritability1747484irritability
liability14128484__li_ability
likability1996124__likability
livability1886744__livability
liveability1945794liv_eability
lovability18106934lov__ability
machinability2573914machinability
malleability1954844malleability
manageability2153914manageability
movability2077234mov__ability
navigable1544744navigab_l__e
negligibility2063164negligibility
nonavailability2371954nonavailability
notability1549704n__otability
packability2446044pa_ckability
palatability1946384palatability
palpability2046334pa_lpability
pliability1748054_pli_ability
reliability1649464reli_ability
salability1548524sa__lability
salvageability2361854salvageability
severability2046754severability
sociability1847924soci_ability
stainability1755684stainability
suitability1647114_suitability
survivability2453184survivability
tangibility1754914ta_ngibility
trainability1746854trainability
unsuitability1865134unsuitability
violability1946274__violability
visibility1846484__visibility
washability2245324wa_shability

Search took 7 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 Limit124790836.21620075.6
3Display Results83830.0501660.0
 (SQL Overall)178691836.65626846.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.