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

143 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
expendability285384(None) 
expandability2853691expandability
extendability2653591extendability
dependability2254862dependability
excludability2852693excludability
expansibility2763473expansibility
expendabilities2774373expendabilities
exportability2774253exportability
extensibility2553903extensibility
extrudability2673143extrudability
openability1846933_open_ability
alienability1745694alien_ability
amenability1847494_amen_ability
appealability2253964appealability
compensability2563534compensability
deniability1748724__deniability
dispensability2263204dispensability
electability1947054e_lectability
employability2553044employability
excitability2655674ex_citability
expandabilities2763874expandabilities
expendable2243874expendab_l__e
expendables2352154expendab_l_es
extendabilities2564164extendabilities
impeccability2654464impeccability
operability1848854_ope_rability
patentability2054784patentability
readability1748074__readability
refundability2253944refundability
rentability16410194__rentability
repeatability2056244repeatability
respectability2353974respectability
spreadability2154404spreadability
tenability1549124__ten_ability
untenability1756424unten_ability
vendibility2054794__vendibility
acceptability2454125acceptability
affectability2663855affectability
affordability2552655affordability
agreeability1855165agre_eability
alterability1747125alte_rability
applicability24114065applicability
bankability2245245__bankability
bearability1847335__bearability
believability2353755belie_vability
biddability2043845__biddability
bipedality1852785bipe_da__lity
capability1947595cap___ability
cleanability1955225_cleanability
countability1956585_countability
credibility1955505_cre_dibility
decidability2145745_decidability
defensibility2254455defensibility
delectability2155675delectability
dependabilities2155245dependabilities
dependably1954545dependab_l__y
detectability2155665detectability
deterrability1974995deterrability
detonability1856145deton_ability
drapeability2055915drape__ability
drinkability2254695_drinkability
dyeability1945885_dye__ability
edibility1546925___e_dibility
educability1946245e__ducability
enumerability2074285enumerability
equability2446745___equability
equitability2645775e_quitability
erasability1668935e__rasability
erodibility1755965e__rodibility
exchangeability33101425exchangeability
expandable2243125expandab_l__e
expansivity2652355expan__sivity
expectably2654225expectab_l__y
extendable2043835extendab_l__e
externality2155045externa__lity
extractability28103555extractability
formidability2463995formidability
germinability2155065germin_ability
hypermobility2863325hypermobility
impalpability2454115impalpability
impassability2265265impassability
impenetrability2462485impenetrability
impermeability2563915impermeability
implacability2454885implacability
imponderability25132145imponderability
impregnability24163235impregnability
improbability2464405improbability
improvability2564595improvability
imputability2146385imp_utability
inability14411105___in_ability
ineffability2356395_ineffability
inexplicability3162645inexplicability
insensibility1875915insensibility
integrability1956585integrability
liveability1945795live__ability
meltability1848685__meltability
observability2353495observability
opposability2154395_opposability
packability2446045__packability
palpability2046335__palpability
penality13310715__pen_a__lity
penetrability2055215penetrability
perdurability2154685__perdurability
permeability2157175__permeability
placability2047145__placability
playability2146025__playability
pliability1748055__p_liability
portability1849565__portability
potability1749815__p_otability
pregnability2056165_pregnability
presentability2164505presentability
preventability2464065preventability
printability1946865_printability
probability2047705__probability
reasonability1854795reason_ability
reliability1649465__reliability
remediability2154685remediability
renewability2055835__renewability
repairability2055855repairability
replicability2255605replicability
reputability1946985rep_utability
resectability2056095resectability
responsibility2162485responsibility
reusability1648475__reusability
roadability1757205__roadability
sensibility1646905__sensibility
separability1946915sep_arability
severability2046755seve_rability
sewability1846855__se_wability
squeezability3661845squeezability
stainability1755685stain_ability
testability1648805__testability
tolerability1776295tole_rability
trainability1746855train_ability
treatability1747435_treatability
tunability1546985__tun_ability
undecidability2363105undecidability
unreliability1855605unreliability
upgradability2253045upgradability
venerability2046775__venerability
vulnerability2153265vulnerability
wearability1947105__wearability
wettability1946485__wettability

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.390458182.1
2DLD Change Limit1247901438.86014084.7
3Display Results1431430.0931537.6
 (SQL Overall)1786911439.34319125.7
 
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.