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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
alterability174712(None) 
alienability1745692alienability
filterability2153702filterability
inalterability1954562inalterability
unalterability1963472unalterability
actability1749083act__ability
admirability2055713admirability
adorability1746903a_dorability
agreeability1855163agreeability
alterabilities1667333alterabilities
alterably1447203alterab_l__y
amenability1847493a_menability
arability14411013a___rability
deterrability1974993deterrability
integrability1956583integrability
malleability1954843malle_ability
operability1848853_operability
severability2046753severability
sinterability1855213sinterability
solderability1963383solderability
tenability1549123__tenability
tolerability1776293tolerability
untenability1756423untenability
venerability2046773venerability
vulnerability2153263vulnerability
absorbability1962894absorbability
acceptability2454124acceptability
adaptability2055224adaptability
adoptability2054764adoptability
advisability2155064advisability
affability2145694a__ffability
affectability2663854affectability
affordability2552654affordability
alterable1149164alterab_l__e
alterity1149854alter____ity
amiability1748744a__miability
amicability2047324a_micability
appealability2253964appealability
assumability1954024assumability
attainability18103984attainability
automobility1993054automobility
availability2055494availability
bearability1847334_bearability
believability2353754believability
castability1848414cast__ability
cleanability1955224cleanability
cultivability2373684cultivability
curability1747864__curability
cutability1747864cut__ability
deliverability23102674deliverability
desirability1847274desirability
detectability2155664detectability
detonability1856144detonability
durability1647744__durability
dyeability1945894_dye_ability
electability1947054electability
enumerability2074284enumerability
extendability2653594extendability
fatigability2154994fatigability
flammability2453904flammability
flexibility2653294fl_exibility
hatchability2553774hatchability
honorability2055814honorability
illegibility1854424illegibility
inalienability1954554inalienability
insurability1757224insurability
intolerability1964524intolerability
lability13710834_l___ability
legibility1645914_l_egibility
liability14128494_l__iability
likability1996134_l_ikability
literality1346904litera__lity
livability1886754_l_ivability
liveability1945804_liveability
lovability18106934_l_ovability
marketability2454134marketability
meltability1848684melt__ability
memorability2146444memorability
mutability1748074mut__ability
notability1549704not__ability
observability2353494observability
openability1846934_openability
palatability1946384pal_atability
palpability2046334pal__pability
patentability2054794patentability
penetrability2055214penetrability
placability2047144pl_acability
playability2146024pl_ayability
pliability1748054pl__iability
potability1749814pot__ability
preferability2355254preferability
renewability2055834renewability
salability1548524sal___ability
separability1946914separability
sewability1846854__sewability
shareability2054924shareability
stability14410084_st__ability
sterility1247764_ster__ility
testability1648804__testability
tunability1546984__tunability
wearability1947104_wearability
weatherability2572864weatherability
wettability1946484wet_tability

Search took 10 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.796224486.2
2DLD Change Limit1247901038.53014629.5
3Display Results1031030.0631634.9
 (SQL Overall)1786911039.38919032.0
 
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.