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

88 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
arability1441101(None) 
ability12311442__ability
actability1749082actability
adorability1746902adorability
affability2145682affability
amiability1748742amiability
bearability1847332bearability
capability1947592capability
curability1747862curability
durability1647732durability
fragility1645552fragility
friability1847892friability
gracility1546202gracility
inability14411102inability
lability13710832_lability
liability14128482liability
rabidity1446582_rabidity
salability1548522salability
stability14410082stability
suability1448592suability
usability1447162usability
variability1947522variability
viability1767872viability
wearability1947102wearability
admirability2055713admirability
agility1148653__agility
agreeability1855163agreeability
alterability1747123alterability
amenability1847493amenability
amicability2047323amicability
anality10313633ana__lity
anility10312723__anility
arabicize2254873arabicize
arabilities13413103arabilities
arabizing2147963arabizing
aridity11510113ar__idity
audibility1645833audibility
aurality1139223aura__lity
bankability2245243bankability
castability1848413castability
cutability1747863cutability
debility1448633_debility
disability1649773disability
drapability1986473drapability
drivability2046793drivability
dyeability1945883dyeability
edibility1546923edibility
equability2446743equability
erasability1668933erasability
facility1638243_facility
formability2146963formability
frailty1335663fra_il_ty
gravidity1743533gravidity
labiality1446363_labiality
likability1996123likability
livability1886743livability
lovability18106933lovability
mailability1847303mailability
mobility1548543_mobility
movability2077233movability
mutability1748073mutability
nobility1348983_nobility
notability1549703notability
nubility1347783_nubility
operability1848853operability
orality101111683ora__lity
packability2446043packability
palpability2046333palpability
partibility1847113partibility
placability2047143placability
playability2146023playability
pliability1748053pliability
portability1849563portability
potability1749813potability
probability2047703probability
rabbity14266303_rab_bity
rapidity1446273_rapidity
readability1748073readability
roadability1757203roadability
separability1946913separability
sewability1846853sewability
shareability2054923shareability
sorbability1846373sorbability
tenability1549123tenability
tunability1546983tunability
vagility1546323_vagility
washability2245323washability
workability2345383workability

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.423422437.4
2DLD Change Limit148641887.26320465.5
3Display Results88880.0501760.0
 (SQL Overall)178691887.73623098.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.