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

145 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
affectabilities255398(None) 
acceptabilities2354223acceptabilities
actabilities1649983a___ctabilities
affabilities2046943aff___abilities
affectability2663853affectabilit__y
affectivities2453513affect__ivities
affordabilities2453053affordabilities
delectabilities2065553delectabilities
detectabilities2065823detectabilities
electabilities1857563_electabilities
resectabilities1956013resectabilities
adaptabilities1955624a_daptabilities
adjustabilities2563234adjustabilities
adoptabilities1955264a_doptabilities
agreeabilities1755344agre_eabilities
alienabilities1656204alie_nabilities
alterabilities1667334alte_rabilities
amenabilities1778834a_me_nabilities
amicabilities19197894a_mic_abilities
appealabilities2163884appealabilities
effectivities2453854effect__ivities
effectualities2262204effect_ualities
impeccabilities2584724impeccabilities
marketabilities2353734marke_tabilities
meltabilities1749864__meltabilities
patentabilities1995334patentabilities
rentabilities15411234__rentabilities
repeatabilities1955914repeatabilities
testabilities1549934__testabilities
tractabilities1846584_tractabilities
treatabilities1657604_treatabilities
wettabilities1847774__wettabilities
absorbabilities181675135absorbabilities
accessibilities2162975accessibilities
admirabilities1956025a_dmirabilities
adorabilities1647805a__dorabilities
advisabilities2055545a_dvisabilities
affectable2043615affectab_l___e_
amiabilities16109875a___miabilities
analyzabilities2952715analyzabilities
applicabilities2353735applicabilities
arabilities13413095a____rabilities
assignabilities1853075assignabilities
assumabilities1853975a_ssumabilities
attainabilities1753755attainabilities
availabilities1955745a_vailabilities
bearabilities1748675__bearabilities
breathabilities2253995_breathabilities
castabilities1748795__castabilities
cleanabilities1856045_cleanabilities
computabilities2354535computabilities
countabilities1856665_countabilities
creditabilities2065275creditabilities
cutabilities1649115___cutabilities
decidabilities2046235__decidabilities
deductibilities2183065deductibilities
defeasibilities2153815defeasibilities
defensibilities2164045defensibilities
deniabilities1649765__deniabilities
dependabilities2155245dependabilities
detachabilities2354145detachabilities
deterrabilities1875385deterrabilities
digestibilities1963285digestibilities
dilatabilities1795935_dilatabilities
dyeabilities1847865_dye__abilities
educabilities1857065_educ_abilities
equabilities2348155___equabilities
equitabilities2566015_equitabilities
erectilities1447105_erect__ilities
excitabilities2556315_excitabilities
expendabilities2774375expendabilities
exportabilities2654565exportabilities
extendabilities2564165extendabilities
fatigabilities2065375_fatigabilities
feasibilities1866565__feasibilities
fertilities1448815__fert__ilities
fishabilities2146285__fishabilities
flammabilities2363945_flammabilities
flexibilities2564015_fle_xibilities
forgeabilities2054725_forgeabilities
formabilities2046995__formabilities
friabilities1789155__f_riabilities
habitabilities21125315_habitabilities
hatchabilities2453995_hatchabilities
heritabilities1958195_heritabilities
ignitabilities17106305_ignitabilities
immutabilities2056045_immutabilities
imputabilities2056615_imputabilities
ineffabilities2256155_ineffabilities
inevitabilities2055645inevitabilities
infeasibilities2064715infeasibilities
infectivities2155125infect__ivities
infertilities1656205infert__ilities
insociabilities19105025insociabilities
instabilities1549845__instabilities
integrabilities1885505integrabilities
irritabilities1647295_irritabilities
leachabilities2155535_leachabilities
liveabilities1846755live__abilities
malleabilities1874975malle__abilities
metastabilities1955495metastabilities
mutabilities1649535___mutabilities
notabilities14410715___notabilities
observabilities2293745observabilities
openabilities1748615_ope_nabilities
operabilities17510055_ope_rabilities
overstabilities2055245overstabilities
packabilities2346555__packabilities
palatabilities1846785_palatabilities
penetrabilities1965325penetrabilities
placabilities1947615_plac_abilities
portabilities17410185__portabilities
potabilities16411295___potabilities
preferabilities2254605preferabilities
pregnabilities1956545_pregnabilities
printabilities1847275_printabilities
profitabilities2284565profitabilities
promotabilities2184525promotabilities
quotabilities2466625__quotabilities
readabilities1649305__readabilities
reformabilities2264535reformabilities
refundabilities2153925refundabilities
reliabilities15410445__reliabilities
remediabilities2054615remediabilities
renewabilities1956205rene_wabilities
reputabilities1847425_reputabilities
reusabilities1549265__reusabilities
sectilities1348685__sect__ilities
severabilities1947435seve_rabilities
sewabilities1748935__se_wabilities
sociabilities1748385__sociabilities
spreadabilities2054005spreadabilities
squeezabilities3562305squeezabilities
stabilities13511755____stabilities
suitabilities1548065__suitabilities
tenabilities14911485__te_nabilities
tolerabilities16116605tole_rabilities
traceabilities1855865_traceabilities
trustabilities16105815_trustabilities
unreliabilities1754785unreliabilities
unsociabilities19113995unsociabilities
unsuitabilities1754365unsuitabilities
untenabilities1656995unte_nabilities
venerabilities1967355vene_rabilities
wearabilities1848415__wearabilities

Search took 5 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 Filter178691658740.0931921408.6
2DLD Change Limit658741454.56314436.6
3Display Results1451450.1101318.2
 (SQL Overall)1786911454.76637492.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.