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

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

87 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
progressivities21122521progressivities_
regressivities1862533_regressivities_
aggressivities1961624_aggressivities_
progressiveness2172864progressiv_eness
progressives1854294progressiv___es_
progressivism2162344progressiv__i_sm
progressivisms2271874progressivi_sms_
progressivist1962864progressiv__i_st
progressivistic23171884progressivisti__c
progressivists2072214progressivi_sts_
progressivity2262954progressivit___y
expressivities2662515_expressivities_
progressive1755185progressiv___e__
progressively2263685progressiv___ely
erosivities1455916ero____sivities_
passivities1644906p____assivities_
prehensilities1962176pr_ehensilities_
proclivities1964686pro___clivities_
productivities2282596pro_ductivities_
progresses1347496progress_____es_
progressions1555556progress__i_ons_
propensities1655266pro_pens__ities_
pyrogenicities2263566pyrog_e_nicities_
regressiveness1864226_regressiv_eness
regressivity1963006_regressivit___y
aggressiveness1962667_aggressiv_eness
aggressivity2081987_aggressivit___y
coercivities1954247_co__ercivities_
collectivities2174167_collectivities_
compulsivities2361917_compulsivities_
connectivities2164477_connectivities_
creativities1755787___creativities_
digressiveness1963377_digressiv_eness
directivities1954197__directivities_
domesticities1863807_do_mesticities_
emissivities1752957___emissivities_
festivities1746587____festivities_
forgeabilities2054727forg_eabilities_
impassivities2062957__impassivities_
ingressiveness1864167_ingressiv_eness
ingressives1554257_ingressiv___es_
noncreativities2082767noncreativities_
objectivities2754317__objectivities_
perceptivities2363267p_erceptivities_
perfectivities2483877p_erfectivities_
porosities12411487p_o_r_os__ities_
portabilities17410217p_o_rtabilities_
positivities1755457p_o__sitivities_
possessiveness1763237p_ossessiv_eness
possessives1583157p_ossessiv___es_
preferabilities2254617preferabilities_
pregnabilities1956577preg_nabilities_
prerequisites2461197pr_erequisit_es_
primitivities2073567pr__imitivities_
privities14312047p___r___ivities_
probabilities1958107pro__babilities_
processibility2363057pro_cessibili_ty
procrastinates1882237procrastinat_es_
professorates1862357pro_fessorat_es_
professoriates1961967pro_fessoriates_
profitabilities2284597profitabilities_
progestins1348667prog_e_s___tins_
prognosticates1972597prognosticat_es_
progressed1445357progress_____e_d
progressing1545777progress____i_ng
progression1455887progress____i_on
progressional1663967progress__i_onal
prolificities2053477pro__lificities_
prolixities2046367pro____lixities_
promiscuities1981787pro__miscuities_
promotabilities2184557promotabilities_
proprieties1556187propr___i_eties_
prosperities1655497pro___sperities_
protrusiveness1962967protr_usiv_eness
proximities2255887pro____ximities_
receptivities2053907_r_eceptivities_
reflectivities2263627_reflectivities_
reflexivities2662067_refle_xivities_
refractivities22103977_refractivities_
regressive1446497_regressiv___e__
regressively19124757_regressiv___ely
repressiveness1964817_repressiv_eness
resistivities1694507_r_esistivities_
retentivities1654557_r_etentivities_
saprogenicities2082477saprog_e_nicities_
sessilities1146407____sessilities_
unprogressive1962507unprogressiv___e__

Search took 9 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 Filter178691950240.343520965.0
2DLD Change Limit95024878.01611854.3
3Display Results87870.0761144.7
 (SQL Overall)178691878.43521184.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.