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

78 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
commemoratively2671911commemoratively_
commemorative2163043commemorative___
commemoratives2262423commemorative__s
collaboratively2571545collaboratively_
commemorate1653665commemorat__e___
commemorated1852935commemorat__e__d
commemorates1753575commemorat__e__s
commemorating1953075commemorati___ng
commemoration1853885commemorati___on
commemorations1953445commemorati__ons
communicatively2982955communicatively_
comparatively2553715co_m_paratively_
contemplatively2771895contemplatively_
cooperatively2354195coope__ratively_
combatively2354646co___m_batively_
commemorator1772616commemorat____or
commemorators1862456commemorat___ors
commensurately2361746commensurat__ely_
commiseratingly2571266commiseratingly_
commiserative2283276commiserative___
competitively2562816compe__titively_
connotatively21102686co__nnotatively_
conservatively25133876conse_rvatively_
correlatively2153216corre__latively_
decoratively2154446___decoratively_
imperatively2255576_impe__ratively_
operatively1946276_o_pe__ratively_
pejoratively2753676___pejoratively_
adumbratively2462057__adumbratively_
coercively2053487co__e__r_cively_
collaborative2092387collaborative___
collaboratives21101947collaborative__s
collectively22114627colle___ctively_
comfortingly2371877co_m_for_tingly_
commercially2354147comme__r_cially_
communicative2454667communicative___
commutative2055847co_m_mutative___
commutativity2561977co_m_mutativity_
comparative20176217co_m_parative___
comparatives21164857co_m_parative__s
compensative2154657compe_nsative___
concentrative2056217concentrative___
confederative2253757confederative___
connectively2255187conne___ctively_
consecrative1957317conse_crative___
consecutively2383257conse__cutively_
consumptively2562477consum__ptively_
contemplative22123707contemplative___
contemplatives23122777contemplative__s
contemporarily23101977contemporari__ly_
contrastively2153867co___ntrastively_
cooperative1847057coope__rative___
cooperatives1965557coope__rative__s
corporately1854127co__rporat__ely_
corporative1847157co__rporative___
correctively2254867corre___ctively_
corroborative2062107corroborative___
creatively1846677c__re___atively_
cumulatively2253067c___umulatively_
curatively1845737c_____uratively_
demonstratively24172507demonstratively_
emotively1744407____emo__tively_
emulatively1954517____emulatively_
evocatively2253687____evocatively_
exploratively2862427__exploratively_
federatively2253907___federatively_
formatively2254527fo__rm__atively_
immemorially1862097_immemor__ially_
iteratively1745917__ite__ratively_
meditatively2153567___meditatively_
memorabilia1762227___memorabi__lia
normatively1954637no__rm__atively_
opinionatively2271277_opinionatively_
postoperatively2591267postoperatively_
preparatively2353647__preparatively_
reiteratively1953797reite__ratively_
remonstratively23172507remonstratively_
remuneratively2262597_remuneratively_

Search took 10 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.373479064.3
2DLD Change Limit95024788.89310685.3
3Display Results78780.0601300.0
 (SQL Overall)178691789.32619160.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.