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

170 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
affectability266385(None) 
acceptability2454123acceptability
actability1749083a___ctability
affability2145683aff___ability
affectabilities2553983affectabilities
affectivity25103253affect__ivity
affordability2552653affordability
delectability2155673delectability
detectability2155663detectability
electability1947053_electability
resectability2056093resectability
adaptability2055224a_daptability
adjustability2652984adjustability
adoptability2054764a_doptability
affectable2043614affectab_l__e
agreeability1855164agre_eability
alienability1745694alie_nability
alterability1747124alte_rability
amenability1847494a_me_nability
amicability2047324a_mic_ability
appealability2253964appealability
effectivity25103664effect__ivity
effectuality2382314effect_uality
impeccability2654464impeccability
marketability2454134marke_tability
meltability1848684__meltability
patentability2054784patentability
perfectibility2663264perfectibility
rentability16410194__rentability
repeatability2056244repeatability
respectability2353974respectability
testability1648804__testability
tractability1947094_tractability
trafficability2762254traffic_ability
treatability1747434_treatability
wettability1946484__wettability
absorbability1962895absorbability
accessibility2263185accessibility
accountability2362615accountability
addressability2172175addressability
admirability2055715a_dmirability
adorability1746905a__dorability
advisability2155065a_dvisability
affectation1943845affecta__tion
affectations2043435affectati_ons
affectedly2252155affect_edl__y
affectingly2352395affect__ingly
affectively2553975affect__ively
affectivities2453515affectivities
amiability1748745a___miability
analyzability3053425analyzability
applicability24114065applicability
arability14411015a____rability
assignability1962875assignability
assumability1954025a_ssumability
attainability18103985attainability
availability2055495a_vailability
bearability1847335__bearability
breathability2354085_breathability
castability1848415__castability
cleanability1955225_cleanability
computability2455155computability
countability1956585_countability
creditability2155695creditability
cutability1747865___cutability
decidability2145745__decidability
deductibility2253515deductibility
defeasibility2254205defeasibility
defensibility2254455defensibility
deniability1748725__deniability
dependability2254865dependability
detachability2454315detachability
deterrability1974995deterrability
digestibility2053725digestibility
dilatability1845455_dilatability
dyeability1945885_dye__ability
educability1946245_educ_ability
enforceability2472555enforceability
equability2446745___equability
equitability2645775_equitability
erectility1546265_erect__ility
excitability2655675_excitability
expendability2853845expendability
exportability2774255exportability
extendability2653595extendability
extractability28103555extractability
fatigability2154995_fatigability
feasibility1945955__feasibility
fertility1547205__fert__ility
fishability2245285__fishability
flammability2453905_flammability
flexibility2653295_fle_xibility
forgeability2154575_forgeability
formability2146965__formability
friability1847895__f_riability
habitability2255095_habitability
hatchability2553775_hatchability
heritability2047985_heritability
ignitability1856055_ignitability
immutability2155895_immutability
imputability2146385_imputability
indefectibility2673315indefectibility
ineffability2356395_ineffability
ineffaceability2862285ineffaceability
ineluctability2185055ineluctability
inevitability2156965inevitability
infeasibility2155725infeasibility
infectivity2254705infect__ivity
infertility1755475infert__ility
inheritability2255605inheritability
insociability2056225insociability
instability1649445__instability
integrability1956585integrability
intractability2155865intractability
irrefutability2293405irrefutability
irritability1747485_irritability
leachability2255255_leachability
liveability1945795live__ability
malleability1954845malle__ability
metastability2055575metastability
mutability1748075___mutability
notability1549705___notability
observability2353495observability
openability1846935_ope_nability
operability1848855_ope_rability
overstability21125375overstability
packability2446045__packability
palatability1946385_palatability
penetrability2055215penetrability
placability2047145_plac_ability
portability1849565__portability
potability1749815___potability
predictability2454015predictability
preferability2355255preferability
pregnability2056165_pregnability
presentability2164505presentability
preventability2464065preventability
printability1946865_printability
profitability2355135profitability
promotability2254805promotability
quotability2555595__quotability
readability1748075__readability
reformability2354645reformability
refundability2253945refundability
reliability1649465__reliability
remediability2154685remediability
renewability2055835rene_wability
reputability1946985_reputability
reusability1648475__reusability
sectility1447375__sect__ility
severability2046755seve_rability
sewability1846855__se_wability
sociability1847925__sociability
spreadability2154405spreadability
squeezability3661845squeezability
stability14410085____stability
stretchability2462135stretchability
suitability1647115__suitability
tenability1549125__te_nability
tolerability1776295tole_rability
traceability1956535_traceability
trustability1756135_trustability
unacceptability2681945unacceptability
undecidability2363105undecidability
unreliability1855605unreliability
unsociability2054895unsociability
unsuitability1865135unsuitability
untenability1756425unte_nability
venerability2046775vene_rability
wearability1947105__wearability

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.406440125.6
2DLD Change Limit1247901708.50014681.2
3Display Results1701700.1101545.5
 (SQL Overall)1786911709.01619819.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.