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

137 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
acceptabilities2354221acceptabilities_
acceptability2454124acceptabilit___y
accessibilities2162974accessibilities_
actabilities1649984a_c__tabilities_
adaptabilities1955624a_daptabilities_
adoptabilities1955264a_doptabilities_
affectabilities2553984affectabilities_
acceptableness2263265acceptab_l_eness
adjustabilities2563235adjustabilities_
agreeabilities1755345agre_eabilities_
alienabilities1656205alie_nabilities_
alterabilities1667335alte_rabilities_
amenabilities1778835a_me_nabilities_
appealabilities2163885appealabilities_
capabilities1848815__cap_abilities_
castabilities1748795__castabilities_
cleanabilities1856045_cleanabilities_
computabilities2354535_computabilities_
countabilities1856665_countabilities_
creditabilities2065275_creditabilities_
culpabilities1946005_culp_abilities_
cutabilities1649115__c_utabilities_
delectabilities2065555delectabilities_
detectabilities2065825detectabilities_
electabilities1857565_electabilities_
excitabilities2556315exc_itabilities_
incapabilities2056205incap_abilities_
marketabilities2353735marke_tabilities_
meltabilities1749865__meltabilities_
patentabilities1995335patentabilities_
rentabilities15411235__rentabilities_
repeatabilities1955915repeatabilities_
reputabilities1847425__reputabilities_
resectabilities1956015resectabilities_
testabilities1549935__testabilities_
treatabilities1657605_treatabilities_
wettabilities1847775__wettabilities_
absorbabilities181675136absorbabilities_
acceptable1844296acceptab_l___e__
acetanilides1561836a_ce_tanili_des_
admirabilities1956026a_dmirabilities_
adorabilities1647806a__dorabilities_
advisabilities2055546a_dvisabilities_
affabilities2046946a___ffabilities_
affordabilities2453056affordabilities_
amiabilities16109876a___miabilities_
amicabilities19197896a__micabilities_
analyzabilities2952716analyzabilities_
applicabilities2353736applicabilities_
arabilities13413096a____rabilities_
assignabilities1853076assignabilities_
assumabilities1853976a_ssumabilities_
attainabilities1753756attainabilities_
availabilities1955746a_vailabilities_
bearabilities1748676__bearabilities_
breathabilities2253996_breathabilities_
coilabilities1748076__coilabilities_
comparabilities2374376_comparabilities_
compatibilities2363606_compatibilities_
credibilities1856066_cre_dibilities_
crossabilities1855686_crossabilities_
curabilities1649386__c_urabilities_
decidabilities2046236dec_idabilities_
deniabilities1649766__deniabilities_
dependabilities2155246dependabilities_
deterrabilities1875386deterrabilities_
digestibilities1963286digestibilities_
dilatabilities1795936_dilatabilities_
drapabilities1847106_drap_abilities_
drapeabilities1955986_drapeabilities_
dyeabilities1847866_dye__abilities_
eccentricities1792166eccent_ricities_
equabilities2348156___equabilities_
equitabilities2566016_equitabilities_
excludabilities27102416excludabilities_
expendabilities2774376expendabilities_
exportabilities2654566exportabilities_
extendabilities2564166extendabilities_
habitabilities21125316_habitabilities_
hatchabilities2453996hatc__habilities_
heritabilities1958196_heritabilities_
ignitabilities17106306_ignitabilities_
immutabilities2056046_immutabilities_
impeccabilities2584726impeccabilities_
imputabilities2056616_imputabilities_
ineffabilities2256156_ineffabilities_
inevitabilities2055646inevitabilities_
instabilities1549846__instabilities_
integrabilities1885506integrabilities_
irritabilities1647296_irritabilities_
liveabilities1846756live__abilities_
machinabilities2473086machinabilities_
malleabilities1874976malle__abilities_
metastabilities1955496metastabilities_
mutabilities1649536___mutabilities_
notabilities14410716___notabilities_
observabilities2293746observabilities_
openabilities1748616_ope_nabilities_
operabilities17510056_ope_rabilities_
overstabilities2055246overstabilities_
packabilities2346556pac__kabilities_
palatabilities1846786_palatabilities_
palpabilities1947246_palp_abilities_
penetrabilities1965326penetrabilities_
portabilities17410186__portabilities_
potabilities16411296___potabilities_
pregnabilities1956546_pregnabilities_
printabilities1847276_printabilities_
profitabilities2284566profitabilities_
promotabilities2184526promotabilities_
quotabilities2466626__quotabilities_
readabilities1649306__readabilities_
recallabilities1963956recallabilities_
receptivities2053906recept__ivities_
reliabilities15410446__reliabilities_
remediabilities2054616remediabilities_
renewabilities1956206rene_wabilities_
reusabilities1549266__reusabilities_
separabilities1847346__separabilities_
severabilities1947436seve_rabilities_
sewabilities1748936__se_wabilities_
sociabilities1748386soc__iabilities_
spreadabilities2054006spreadabilities_
squeezabilities3562306squeezabilities_
stabilities13511756____stabilities_
suitabilities1548066__suitabilities_
tenabilities14911486__te_nabilities_
tolerabilities16116606tole_rabilities_
traceabilities1855866trace__abilities_
tractabilities1846586_tractabilities_
trustabilities16105816_trustabilities_
unacceptability2681936unacceptabilit___y
unreliabilities1754786unreliabilities_
unsuitabilities1754366unsuitabilities_
untenabilities1656996unte_nabilities_
venerabilities1967356vene_rabilities_
wearabilities1848416__wearabilities_

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 Filter178691658740.0931921408.6
2DLD Change Limit658741375.81311332.2
3Display Results1371370.1101245.5
 (SQL Overall)1786911376.01629702.6
 
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.