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

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

155 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
marketabilities2353731marketabilities_
malleabilities1874974malle_abilities_
marketability2454124marketabilit___y
acceptabilities2354225_acceptabilities_
actabilities1649985_a__ctabilities_
adaptabilities1955625_adaptabilities_
adoptabilities1955265_adoptabilities_
affectabilities2553985_affectabilities_
agreeabilities1755345_agreeabilities_
alienabilities1656205_alienabilities_
alterabilities1667335_alterabilities_
amenabilities1778835_a_menabilities_
arabilities13413095_ar___abilities_
bankabilities2145905bank__abilities_
castabilities1748795ca__stabilities_
drapeabilities1955985drape_abilities_
forgeabilities2054725forge_abilities_
habitabilities21125315ha_bitabilities_
heritabilities1958195her_itabilities_
irritabilities1647295_irritabilities_
machinabilities2473085machinabilities_
mailabilities1767695ma__ilabilities_
manageabilities2053515manageabilities_
meltabilities1749865m__eltabilities_
metastabilities1955495metastabilities_
mutabilities1649535m___utabilities_
packabilities2346555pack__abilities_
palatabilities1846785pa_latabilities_
partibilities1748095par__tibilities_
patentabilities1995335patentabilities_
permeabilities2056825perme_abilities_
portabilities17410185por__tabilities_
printabilities1847275_printabilities_
rentabilities15411235__rentabilities_
shareabilities1955215shar_e_abilities_
traceabilities1855865trace_abilities_
tractabilities1846585_tractabilities_
treatabilities1657605_treatabilities_
trustabilities16105815_trustabilities_
variabilities1848635var__iabilities_
workabilities2245675work__abilities_
adjustabilities2563236adjustabilities_
admirabilities1956026_admirabilities_
adorabilities1647806_a_dorabilities_
advisabilities2055546_advisabilities_
affabilities2046946_a__ffabilities_
amiabilities16109876_a__miabilities_
amicabilities19197896_a_micabilities_
appealabilities2163886_appealabilities_
assumabilities1853976_assumabilities_
availabilities1955746_availabilities_
bearabilities1748676bear___abilities_
believabilities22153946believabilities_
breathabilities2253996_breathabilities_
brushabilities2153966_brushabilities_
capabilities1848816ca___pabilities_
changeabilities2362866change_abilities_
computabilities2354536computabilities_
countabilities1856666_countabilities_
credibilities1856066_cr_edibilities_
creditabilities2065276creditabilities_
crossabilities1855686_crossabilities_
curabilities1649386cur___abilities_
cutabilities1649116___cutabilities_
damageabilities2153366damageabilities_
delectabilities2065556delectabilities_
detectabilities2065826detectabilities_
dilatabilities1795936_dilatabilities_
drapabilities1847106_dr_apabilities_
drillabilities1754786_drillabilities_
drinkabilities2155036_drinkabilities_
drivabilities1947246_dr_ivabilities_
driveabilities2055166_driveabilities_
durabilities1549336dur___abilities_
dyeabilities1847866__dye_abilities_
electabilities1857566_electabilities_
enumerabilities1954066enumerabilities_
equitabilities2566016_equitabilities_
erasabilities1549606_er_asabilities_
excitabilities2556316_excitabilities_
exportabilities2654566exportabilities_
fatigabilities2065376fa_tigabilities_
filterabilities2053286filterabilities_
formabilities2046996for__mabilities_
formidabilities2353376formidabilities_
friabilities1789156_fr__iabilities_
germinabilities2084506germinabilities_
hatchabilities2453996ha_tchabilities_
ignitabilities17106306_ignitabilities_
immutabilities2056046_immutabilities_
improbabilities23114296impr_obabilities_
improvabilities24114476impr_ovabilities_
imputabilities2056616_imputabilities_
inevitabilities2055646inevitabilities_
instabilities1549846__instabilities_
likabilities1877276_lik__abilities_
liveabilities1846756_live_abilities_
marginalities1654326margina__lities_
marketable1843226marketab_l___e__
measurabilities1964226measurabilities_
memorabilities20137006m_emorabilities_
mensurabilities1964416mensurabilities_
metabolites1555036m___etabolit_es_
modifiabilities2382846modifiabilities_
modulabilities1954196m_odulabilities_
mortalities1348416mor__ta__lities_
movabilities1978366m___ovabilities_
navigabilities2064956na_vigabilities_
notabilities14410716___notabilities_
openabilities1748616__openabilities_
operabilities17510056__operabilities_
overstabilities2055246overstabilities_
palpabilities1947246pa__lpabilities_
penetrabilities1965326_penetrabilities_
perdurabilities2074436perdurabilities_
perishabilities2255276perishabilities_
potabilities16411296___potabilities_
preferabilities2254606preferabilities_
pregnabilities1956546_pregnabilities_
probabilities1958076_pr_obabilities_
profitabilities2284566profitabilities_
promotabilities2184526promotabilities_
quotabilities2466626__quotabilities_
readabilities1649306__readabilities_
reliabilities15410446__reliabilities_
renewabilities1956206_renewabilities_
repeatabilities1955916repeatabilities_
reputabilities1847426_reputabilities_
resectabilities1956016resectabilities_
reusabilities1549266__reusabilities_
roadabilities1647796__roadabilities_
salabilities1449606sa___labilities_
severabilities1947436_severabilities_
sewabilities1748936___sewabilities_
sinterabilities17114616sinterabilities_
solderabilities1873376solderabilities_
sorbabilities1746996sor__babilities_
spreadabilities2054006spreadabilities_
squeezabilities3562306squeezabilities_
stabilities13511756____stabilities_
suitabilities1548066__suitabilities_
survivabilities2352706survivabilities_
tenabilities14911486___tenabilities_
testabilities1549936__testabilities_
tolerabilities16116606_tolerabilities_
trainabilities1646596_trainabilities_
unreliabilities1754786unreliabilities_
unsuitabilities1754366unsuitabilities_
untenabilities1656996_untenabilities_
venerabilities1967356_venerabilities_
verifiabilities2354436verifiabilities_
vulnerabilities2053086vulnerabilities_
washabilities2145986wa__shabilities_
wearabilities1848416wear___abilities_
wettabilities1847776__wettabilities_

Search took 6 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.1101624463.6
2DLD Change Limit658741555.56311841.5
3Display Results1551550.1401107.1
 (SQL Overall)1786911555.81330739.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.