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

117 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
preventability246406(None) 
presentability2164501presentability
patentability2054783p_atentability
predictability2454013predictability
preferability2355253prefe_rability
pregnability2056163pre_gn_ability
preservability2453343preservability
printability1946863pr__intability
rentability16410193_r__entability
repeatability2056243_repeatability
resectability2056093_resectability
creditability2155694cre_ditability
delectability2155674_delectability
dependability2254864_dependability
detectability2155664_detectability
driveability2155094drive__ability
electability1947054__electability
inevitability2156964inev_itability
penetrability2055214p_enetrability
perceptibility2562944perceptibility
perfectibility2663264perfectibility
permeability2157174perme__ability
prehensility20132624prehen__sility
presentably1855284presentab_l__y
preventable1844984preventab_l__e
processability2363044processability
profitability2355134pr_ofitability
promotability2254804pr_omotability
refundability2253944_refundability
remediability2154684_remediability
renewability2055834_rene_wability
reputability1946984_re_putability
respectability2353974_respectability
reversibility2154424_reversibility
severability2046754_seve_rability
treatability1747434tr__eatability
acceptability2454125_acceptability
accountability2362615accountability
affectability2663855_affectability
agreeability1855165agre_e__ability
alienability1745695_alien_ability
amenability1847495__amen_ability
breathability2354085bre_athability
cleanability1955225cle_an_ability
compensability2563535compensability
convertibility2463275convertibility
countability1956585__countability
defensibility2254455_defensibility
deniability1748725___deniability
deterrability1974995_deterrability
detonability1856145_deton_ability
dispensability2263205dispensability
drapeability2055915drape__ability
drinkability2254695dr__inkability
drivability2046795driv___ability
equitability2645775__equitability
eventuality1753325__event_uality
excitability2655675__excitability
expendability2853845_expendability
extendability2653595_extendability
foreseeability2262395forese_eability
germinability2155065germin_ability
heritability2047985_he_ritability
impregnability24163235impre_gn_ability
ineluctability2185055ineluctability
irrefutability2293405irrefutability
irrepealability2262285irrepealability
irreversibility2372385irreversibility
irrevocability2482945irrev_ocability
irritability1747485ir__ritability
liveability1945795_live__ability
marketability2454135marke_tability
meltability1848685___meltability
merchantability2791825merchantability
metastability2055575_metastability
openability1846935__open_ability
overstability21125375ove_rstability
palatability1946385p__alatability
perdurability2154685p_erdurability
performability2663035performability
perishability2365235p_erishability
pleasurability2171955pleasurability
portability1849565p___ortability
potability1749815p____otability
practicability2553325practicability
preestablish1962495pre_estab_lish
presentable1546035presentab_l__e
preventative2054315preventa__tive
preventatives2152935preventati_ves
preventible1854425preventib_l__e
preventively2354705prevent__ively
probability2047705pr___obability
processibility2363055processibility
readability1748075_r__eadability
reasonability1854795_reasonability
recallability2054505_recallability
recoverability2473205_recove_rability
reformability2354645_reformability
reliability1649465_r__eliability
removability2255735_re_movability
repairability2055855_repairability
replicability2255605_replicability
resistibility1864375_resistibility
retentivity1754175_retent__ivity
reusability1648475_r__eusability
serviceability2462865serviceability
spreadability2154405spr__eadability
tenability1549125___ten_ability
testability1648805___testability
traceability1956535trace__ability
tractability1947095tr__actability
trainability1746855tr_ain_ability
trustability1756135tr__ustability
untenability1756425_unten_ability
vendibility2054795___vendibility
venerability2046775___venerability
wettability1946485___wettability

Search took 7 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 Limit950241176.15615436.0
3Display Results1171170.0801462.5
 (SQL Overall)1786911176.59627090.8
 
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.