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

111 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
absorbabilities18167510(None) 
sorbabilities1746952__sorbabilities
absorbability1962873absorbabilit__y
adorabilities1647763a_dor_abilities
affordabilities2453013affordabilities
observabilities2293713observabilities
abnormalities1752554abnorma__lities
absorptivities2161884absor_ptivities
admirabilities1955984admir_abilities
adoptabilities1955254a_doptabilities
alterabilities1667304alter_abilities
arabilities13413054a___r_abilities
assignabilities1853064assignabilities
assumabilities1853954a_ssumabilities
bearabilities1748624_bear_abilities
desirabilities1747464desir_abilities
exportabilities2654544exportabilities
formabilities2046954__formabilities
honorabilities1955924honor_abilities
improbabilities23114274improbabilities
insociabilities19105004insociabilities
insurabilities1676854insur_abilities
memorabilities20136964memor_abilities
portabilities17410144__portabilities
probabilities1958044_pro_babilities
reformabilities2264484reformabilities
sociabilities1748344__sociabilities
solvabilities1846854__solvabilities
unsociabilities19113974unsociabilities
unworkabilities2462834unworkabilities
workabilities2245644__workabilities
absorbable1343315absorbab_l___e_
absorbancies1852185absorba___ncies
acceptabilities2354195acceptabilities
actabilities1649955a___ctabilities
adaptabilities1955615a_daptabilities
adjustabilities2563215adjustabilities
advisabilities2055535a_dvisabilities
affabilities2046925a___ffabilities
affectabilities2553945affectabilities
agreeabilities1755315a_greeabilities
alienabilities1656165a_lienabilities
amenabilities1778795a__menabilities
amiabilities16109855a___miabilities
amicabilities19197875a__micabilities
amoralities1347415a_mor_a__lities
analyzabilities2952705analyzabilities
appealabilities2163855appealabilities
applicabilities2353695applicabilities
associativities2091505associativities
attainabilities1753745attainabilities
automobilities1862875auto_mobilities
availabilities1955735a_vailabilities
bankabilities2145895_b_ankabilities
biddabilities1944975_b_iddabilities
brushabilities2153955_brushabilities
castabilities1748785cas__tabilities
coilabilities1748045__coilabilities
crossabilities1855675_crossabilities
curabilities1649335__cur_abilities
deterrabilities1875335deterrabilities
detonabilities1756675deto_nabilities
disabilities15411055dis___abilities
disposabilities2053525disposabilities
durabilities1549285__dur_abilities
fishabilities2146265fis__habilities
forgeabilities2054705__forgeabilities
friabilities1789105___friabilities
habitabilities21125285hab__itabilities
immovabilities2355275immo_vabilities
improvabilities24114455improvabilities
inexorabilities2454655inexor_abilities
insatiabilities1775505insatiabilities
insolubilities1654545inso_lubilities
instabilities1549835ins__tabilities
invariabilities2055105invariabilities
lovabilities1787975__lo_vabilities
measurabilities1964195measur_abilities
mensurabilities1964385mensur_abilities
movabilities1978345__mo_vabilities
negotiabilities1854005negotiabilities
notabilities14410695__no_tabilities
obtainabilities1963395obtainabilities
operabilities17510015_oper_abilities
opposabilities2054885oppo_sabilities
potabilities16411255__po_tabilities
quotabilities2466595_quo_tabilities
reasonabilities1754625reaso_nabilities
removabilities2186265remo_vabilities
resectabilities1955945resectabilities
roadabilities1647755__roadabilities
salabilities1449585__s_alabilities
separabilities1847305separ_abilities
severabilities1947385sever_abilities
sewabilities1748895__s_ewabilities
shareabilities1955195_shareabilities
solubilities1445975__so_lubilities
sorbability1846325__sorbabilit__y
stabilities13511725__s__tabilities
suabilities13610755__s__uabilities
suitabilities1548035__suitabilities
summabilities1975605__summabilities
testabilities1549895tes__tabilities
tolerabilities16116565toler_abilities
unsuitabilities1754335unsuitabilities
usabilities1368965_us___abilities
variabilities1848595__variabilities
venerabilities1967295vener_abilities
violabilities1856785_vio_labilities
washabilities2145985was__habilities
wearabilities1848365_wear_abilities

Search took 4 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.0762351197.4
2DLD Change Limit658741113.48618896.7
3Display Results1111110.0761460.5
 (SQL Overall)1786911113.63849117.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2023  |  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.