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

98 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
tolerability177629(None) 
intolerability1964522intolerability
operability1848852_operability
solderability1963382solderability
alterability1747123alterability
filterability2153703filterability
honorability2055813honorability
openability1846933_openability
severability2046753severability
solvability1946413sol_vability
tenability1549123t__enability
tolerabilities16116603tolerabilities
tolerably1445273tolerab_l__y
venerability2046773venerability
vulnerability2153263vulnerability
admirability2055714admirability
adorability1746904_adorability
agreeability1855164agreeability
alienability1745694alienability
amenability1847494_amenability
arability14411014___arability
bearability1847334_bearability
believability2353754believability
cleanability1955224_cleanability
coilability1847934co_ilability
comparability2454904comparability
countability1956584countability
culpability2045294cul_pability
curability1747864__curability
delectability2155674delectability
deliverability23102674deliverability
desirability1847274desirability
deterrability1974994deterrability
dilatability1845454dilatability
durability1647734__durability
dyeability1945884_dye_ability
electability1947054_electability
enumerability2074284enumerability
flexibility2653294_flexibility
forgeability2154574forgeability
formability2146964fo_rmability
illegibility1854424illegibility
inalterability1954564inalterability
insurability1757224insurability
integrability1956584integrability
lability13710834__l__ability
legibility1645914__legibility
liability14128484__l_iability
likability1996124__likability
livability1886744__livability
liveability1945794live_ability
lovability18106934__lovability
malleability1954844malleability
meltability1848684mel_tability
memorability2146444memorability
modulability2064214modulability
movability2077234mo__vability
notability1549704no__tability
observability2353494observability
overstability21125374_overstability
palatability1946384palatability
palpability2046334pal_pability
penetrability2055214penetrability
placability2047144_placability
playability2146024_playability
pliability1748054_pl_iability
polarizability3062504polarizability
portability1849564po_rtability
potability1749814po__tability
preferability2355254preferability
recoverability2473204recoverability
reliability1649464rel_iability
renewability2055834renewability
roadability1757204ro_adability
salability1548524sal__ability
separability1946914separability
sewability1846854__sewability
shareability2054924shareability
sinterability1855214sinterability
sociability1847924so_ciability
solubility1545274sol__ubility
sorbability1846374so_rbability
testability1648804t_estability
tolerable1147394tolerab_l__e
tolerantly1353654tolerantl__y
traceability1956534traceability
tractability1947094tractability
trainability1746854trainability
treatability1747434treatability
trustability1756134trustability
tunability1546984t__unability
unalterability1963474unalterability
untenability1756424untenability
violability1946274viol__ability
volatility1644864vol__atility
volubility1844414vol__ubility
wearability1947104_wearability
workability2345384wo_rkability

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 Limit124790986.62318841.9
3Display Results98980.0501960.0
 (SQL Overall)178691987.06325299.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.