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

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

190 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
preferability235525(None) 
preservability2453342preservability
penetrability2055213p_enetrability
perdurability2154683perdurability
performability2663033performability
permeability2157173perme_ability
preferabilities2254613preferabilities
preferably2044683preferab_l__y
pregnability2056163pre_gnability
presentability2164503presentability
preventability2464063preventability
profitability2355133profitability
reformability2354643_reformability
renewability2055833_renewability
severability2046753_severability
venerability2046773_venerability
agreeability1855164agre_e_ability
alterability1747124_alterability
bearability1847334_be_arability
breathability2354084breathability
creditability2155694creditability
desirability1847274_desirability
deterrability1974994_deterrability
drapeability2055914drape_ability
driveability2155104drive_ability
enumerability2074284enumerability
filterability2153704filterability
foreseeability2262394foreseeability
ineffability2356404inef_fability
inexorability2585464inexorability
irreformability2562034irreformability
irrefutability2293404irrefutability
memorability2146444_memorability
operability1848854__operability
perfectibility2663264perfectibility
perishability2365234perishability
pleasurability2171954pleasurability
predictability2454014predictability
preferable1746724preferab_l__e
prehensility20132624prehe_nsility
printability1946864pr_intability
probability2047704pr__obability
processability2363044processability
promotability2254804promotability
readability1748074_re_adability
recoverability2473204_recoverability
refundability2253944_refundability
reliability1649464_re_liability
remediability2154684_remediability
removability2255734_removability
rentability16410194_re_ntability
repairability2055854_repairability
repeatability2056244_repeatability
reputability1946984_reputability
resectability2056094_resectability
reusability1648474_re_usability
reversibility2154424_reversibility
separability1946914_separability
sinterability1855214sinterability
solderability1963384solderability
spreadability2154404spre_adability
tolerability1776294_tolerability
traceability1956534trace_ability
transferability2361934transferability
treatability1747434tre_atability
vulnerability2153264vulnerability
wearability1947104_we_arability
admirability2055715_admirability
adorability1746905__adorability
affability2145695__af_fability
affectability2663855affectability
affordability2552655_affordability
alienability1745695_alienability
amenability1847495__amenability
appealability2253965appe_alability
arability14411015____arability
believability2353755believability
brushability2253785br_ushability
cleanability1955225cle_anability
comparability2454905comparability
confirmability2662595confirmability
credibility1955505cr__edibility
crossability1956105cr_ossability
curability1747865___curability
decidability2145745_decidability
defeasibility2254215_defeasibility
defensibility2254465_defensibility
delectability2155675_delectability
deliverability23102675deliverability
deniability1748735_de_niability
denumerability2262705denumerability
dependability2254865_dependability
detectability2155665_detectability
detonability1856145_detonability
drapability1986485dr__apability
drillability1854645dr_illability
drinkability2254705dr_inkability
drivability2046805dr__ivability
durability1647745___durability
dyeability1945895__dye_ability
educability1946245__educability
electability1947055ele_ctability
ephemerality2262025ephemera__lity
equability2446745__e_quability
erasability1668935__erasability
fertility1547215___fer_tility
forgeability2154575forge_ability
formability2146965___formability
fragility1645565___f_ragility
friability1847895___friability
generality1446195_genera__lity
germinability2155065germinability
heritability2047985_heritability
honorability2055815_honorability
impenetrability2462485impenetrability
impermeability2563915imperme_ability
imponderability25132145imponderability
impregnability24163235impre_gnability
inalterability1954565inalterability
indefinability2384795indefinability
ineducability2155445ineducability
inevitability2156965inevitability
infertility1755485_infer_tility
inseparability2154435inseparability
insurability1757225_insurability
integrability1956585integrability
intolerability1964525intolerability
irrefragability2461955irrefragability
irremovability2462945irremovability
irrepealability2262285irrepealability
irreversibility2372385irreversibility
irrevocability2482945irrevocability
irritability1747485ir_ritability
leachability2255255_leachability
liveability1945805_live_ability
malleability1954845malle_ability
maneuverability2561595maneuverability
marketability2454135marketability
measurability2054475measurability
meltability1848685_me_ltability
mensurability2054385mensurability
observability2353495_observability
openability1846935__openability
overstability21125375overstability
packability2446045p__ackability
palatability1946385p_alatability
palpability2046335p__alpability
patentability2054795patentability
perceptibility2562945perceptibility
perfectivity2563855perfe_ctivity
placability2047145p__lacability
playability2146025p__layability
pliability1748055p___liability
portability1849565p__ortability
potability1749815p___otability
practicability2553325practicability
processibility2363055processibility
puerility1445995p__uer__ility
punishability2353305punishability
reasonability1854795_reasonability
recallability2054505_recallability
reducibility2054175_reducibility
referable1439625_referab_l__e
referentiality2062175_referentiality
refractivity2353515_ref_ractivity
refrangibility2382605_ref_rangibility
rememberability2671495rememberability
replicability2255605_replicability
respectability2353975_respectability
retractility1754005_re_tractility
retrievability2252905_retrievability
roadability1757205_r_oadability
sewability1846855___sewability
shareability2054925share_ability
squeezability3661845squeezability
stretchability2462135stretchability
tenability1549125___tenability
testability1648805_te_stability
tractability1947095tr_actability
trafficability2762255trafficability
trainability1746855tr_ainability
trustability1756135tr_ustability
unalterability1963475unalterability
undesirability2063935undesirability
unreliability1855605unre_liability
untenability1756425_untenability
upgradeability2362435upgrade_ability
verifiability2454445verifiability
weatherability2572865weatherability
wettability1946485_we_ttability

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.423422437.4
2DLD Change Limit1247901908.93613964.9
3Display Results1901900.1431328.7
 (SQL Overall)1786911909.50218805.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.