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

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

64 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
stretchability246213(None) 
breathability2354084_breathability
detachability2454314__detachability
hatchability2553774__hatchability
leachability2255254__leachability
serviceability2462864serviceability
spreadability2154404spre_adability
stretchable1852814stretchab_l__e
traceability1956534_tr_aceability
tractability1947094_tr_actability
treatability1747434_tre_atability
affectability2663855affe_ctability
agreeability1855165agre__eability
approachability2961625approachability
brushability2253785_br_ushability
creditability2155695_creditability
delectability2155675dele_ctability
detectability2155665__detectability
detonability1856145__detonability
electability1947055_ele_ctability
extractability28103555extr_actability
foreseeability2262395foreseeability
heritability2047985herit__ability
impeccability2654465impe_ccability
intractability2155865intr_actability
irrefutability2293405irrefutability
irremovability2462945irremovability
irrevocability2482945irrevocability
irritability1747485irrit__ability
marketability2454135market__ability
penetrability2055215penet_rability
perishability2365235per_ishability
portability1849565por_t__ability
predictability2454015_predictability
preferability2355255_preferability
pregnability2056165_pre_gnability
readability1748075__re_adability
reliability1649465__re_liability
removability2255735__removability
renewability2055835__renewability
rentability16410195__re_ntability
reputability1946985__reputability
resectability2056095__resectability
reusability1648475__re_usability
separability1946915s__eparability
severability2046755s__everability
sewability1846855s__e__wability
shareability2054925share___ability
sinterability1855215s_interability
sociability1847925s___ociability
sorbability1846375sor___bability
squeezability3661845sque_ezability
stability14410085s___t__ability
stainability1755685st__ainability
stretchiest1644195stretch__iest_
suitability1647115s_uit__ability
survivability2453185sur_vivability
tenability1549125_t_e__nability
testability1648805_t_e_stability
trainability1746855_tr_ainability
trustability1756135_tr_ustability
unreliability1855605unre_liability
untouchability2462285untouchability
wettability1946485__wet_tability

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 Filter178691950240.360496363.9
2DLD Change Limit95024646.73314113.2
3Display Results64640.0461391.3
 (SQL Overall)178691647.13925030.3
 
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.