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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
upgradabilities2162461upgradabilities_
spreadabilities2054004spreadabilities_
upgradability2253004upgradabilit___y
agreeabilities1755345_agreeabilities_
appealabilities2163885appealabilities_
drapabilities1847105__drapabilities_
erasabilities1549605__erasabilities_
extrudabilities2552985extrudabilities_
operabilities17510055oper__abilities_
palatabilities1846785_palatabilities_
permeabilities2056825_permeabilities_
placabilities1947615_p_lacabilities_
playabilities2046605_p_layabilities_
portabilities17410185_por_tabilities_
probabilities1958075_p_robabilities_
readabilities1649305__readabilities_
roadabilities1647795__roadabilities_
upgradeability2362405upgradeabilit___y
adorabilities1647806ador__abilities_
affordabilities2453056affordabilities_
applicabilities2353736applicabilities_
arabilities13413096____arabilities_
bearabilities1748676__bearabilities_
biddabilities1944986__biddabilities_
capabilities1848816___capabilities_
cleanabilities1856046_cleanabilities_
comparabilities2374376comparabilities_
credibilities1856066__credibilities_
curabilities1649386_cur__abilities_
decidabilities2046236_decidabilities_
dependabilities2155246dependabilities_
dilatabilities1795936_dilatabilities_
drapeabilities1955986__drapeabilities_
drivabilities1947246__drivabilities_
durabilities1549336_dur__abilities_
erodibilities1656886__erodibilities_
excludabilities27102416excludabilities_
expandabilities2763876expandabilities_
expendabilities2774376expendabilities_
exportabilities2654566expor_tabilities_
extendabilities2564166extendabilities_
forgeabilities2054726_forgeabilities_
formabilities2046996_for_mabilities_
formidabilities2353376formidabilities_
friabilities1789156__fr_iabilities_
gracilities1447676__gr__acilities_
heritabilities1958196_heritabilities_
ignitabilities17106306_ignitabilities_
implacabilities2354016implacabilities_
improbabilities23114296improbabilities_
improvabilities24114476improvabilities_
incapabilities2056206_incapabilities_
incredibilities20113666incredibilities_
invariabilities2055126invariabilities_
irritabilities1647296_irritabilities_
negotiabilities1854036negotiabilities_
openabilities1748616op__enabilities_
opposabilities2054906op_posabilities_
overstabilities2055246overstabilities_
packabilities2346556_p_ackabilities_
palpabilities1947246_p_alpabilities_
partibilities1748096_par_tibilities_
perdurabilities2074436_perdurabilities_
perishabilities2255276_perishabilities_
pliabilities1649386_p__liabilities_
potabilities16411296_p__otabilities_
pregnabilities1956546_pregnabilities_
printabilities1847276_printabilities_
punishabilities2253176punishabilities_
refundabilities2153926refundabilities_
repeatabilities1955916repeatabilities_
salabilities1449606___salabilities_
separabilities1847346_separabilities_
shareabilities1955216shar_eabilities_
sorbabilities1746996_sor_babilities_
traceabilities1855866__traceabilities_
tractabilities1846586__tractabilities_
trainabilities1646596__trainabilities_
treatabilities1657606_treatabilities_
ultravirilities1881686ultravirilities_
unknowabilities2492096unknowabilities_
unreliabilities1754786unreliabilities_
unsociabilities19113996unsociabilities_
unsuitabilities1754366unsuitabilities_
untenabilities1656996u_ntenabilities_
unworkabilities2462856unworkabilities_
upgradable1652806upgradab_l___e__
usabilities1368986u____sabilities_
variabilities1848636_var_iabilities_
wearabilities1848416__wearabilities_
workabilities2245676_wor_kabilities_

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 Limit65874915.84611268.2
3Display Results91910.0761197.4
 (SQL Overall)178691916.01529707.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.