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

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

80 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
viability176788(None) 
liability14128491liability
ability12311442__ability
amiability1748742amiability
arability14411012arability
disability1649782disability
friability1847892friability
inability14411112inability
inviability1978742inviability
lability13710832_lability
likability1996132likability
livability1886752livability
pliability1748052pliability
stability14410082stability
suability1448592suability
usability1447162usability
vagility1546322v_agility
variability1947522variability
violability1946282violability
virility1447742vi_rility
visibility1846492visibility
actability1749083actability
advisability2155063advisability
affability2145693affability
agility1148653__agility
amicability2047323amicability
anility10312723__anility
availability2055493availability
biddability2043853biddability
capability1947593capability
civility1646133ci_vility
coilability1847933coilability
curability1747863curability
cutability1747863cutability
debility1448643_debility
deniability1748733deniability
drivability2046803drivability
durability1647743durability
dyeability1945893dyeability
edibility1546933edibility
equability2446743equability
facility1638253_facility
fishability2245293fishability
fissility1544623fissility
fragility1645563fragility
gracility1546203gracility
labiality1446363_labiality
liveability1945803liveability
lovability18106933lovability
mailability1847303mailability
mobility1548543_mobility
movability2077233movability
mutability1748073mutability
navigability2155443navigability
nihility1446213ni_hility
nobility1348983_nobility
notability1549703notability
nubility1347793_nubility
potability1749813potability
rabidity1446583_rabidity
reliability1649463reliability
risibility1547553risibility
salability1548523salability
sewability1846853sewability
sociability1847923sociability
suitability1647113suitability
tenability1549123tenability
tunability1546983tunability
validity1545993v_alidity
vapidity1745193v_apidity
viabilities1679683viabilities
viably14199833viab_l__y
vicinity1645823vi_cinity
virginity1642823virginity
viridity1545913vi_ridity
viscidity1843883viscidity
visuality1545453visuality
vitality1458113vi_tality
volatility1644863volatility
volubility1844423volubility

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 Filter1786911486410.436409841.7
2DLD Change Limit148641807.09320956.0
3Display Results80800.0461739.1
 (SQL Overall)178691807.57523589.6
 
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.