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

80 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
progressivities2112252(None) 
regressivities1862532_regressivities
aggressivities1961623_aggressivities
progressives1854293progressiv___es
progressivisms2271873progressivi_sms
progressivistic23171883progressivisti_c
progressivists2072213progressivi_sts
progressivity2262953progressivit__y
expressivities2662514_expressivities
progressive1755184progressiv___e_
progressiveness2172864progressiveness
progressivism2162344progressiv__ism
progressivist1962864progressiv__ist
erosivities1455915ero____sivities
passivities1644905p____assivities
prehensilities1962175pr_ehensilities
proclivities1964685pro___clivities
productivities2282595pro_ductivities
progresses1347495progress_____es
progressions1555555progress__i_ons
progressively2263685progressiv__ely
propensities1655265pro_pens__ities
pyrogenicities2263565pyrog_e_nicities
regressivity1962995_regressivit__y
aggressivity2081976_aggressivit__y
coercivities1954246_co__ercivities
collectivities2174166_collectivities
compulsivities2361916_compulsivities
connectivities2164476_connectivities
creativities1755786___creativities
directivities1954196__directivities
domesticities1863806_do_mesticities
emissivities1752956___emissivities
festivities1746586____festivities
forgeabilities2054726forg_eabilities
impassivities2062956__impassivities
ingressives1554256_ingressiv___es
noncreativities2082766noncreativities
objectivities2754316__objectivities
perceptivities2363266p_erceptivities
perfectivities2483876p_erfectivities
porosities12411486p_o_r_os__ities
portabilities17410216p_o_rtabilities
positivities1755456p_o__sitivities
possessives1583156p_ossessiv___es
preferabilities2254616preferabilities
pregnabilities1956576preg_nabilities
prerequisites2461196pr_erequisit_es
primitivities2073566pr__imitivities
privities14312046p___r___ivities
probabilities1958106pro__babilities
processibility2363056pro_cessibility
procrastinates1882236procrastinat_es
professorates1862356pro_fessorat_es
professoriates1961966pro_fessoriates
profitabilities2284596profitabilities
progestins1348666prog_e_s___tins
prognosticates1972596prognosticat_es
progressed1445356progress_____ed
progressing1545776progress____ing
progression1455886progress____ion
progressional1663966progress__ional
prolificities2053476pro__lificities
prolixities2046366pro____lixities
promiscuities1981786pro__miscuities
promotabilities2184556promotabilities
proprieties1556186propr___i_eties
prosperities1655486pro___sperities
proximities2255886pro____ximities
receptivities2053906_r_eceptivities
reflectivities2263626_reflectivities
reflexivities2662066_refle_xivities
refractivities22103976_refractivities
regressive1446496_regressiv___e_
regressiveness1864226_regressiveness
resistivities1694496_r_esistivities
retentivities1654546_r_etentivities
saprogenicities2082466saprog_e_nicities
sessilities1146406____sessilities
unprogressive1962506unprogressiv___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 Limit95024808.25011518.1
3Display Results80800.0461739.1
 (SQL Overall)178691808.63920684.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.