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

77 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
commemoratively267191(None) 
commemorative2163042commemorative__
commemoratives2262422commemorative_s
collaboratively2571544collaboratively
commemorate1653664commemorat__e__
commemorated1852934commemorat__e_d
commemorates1753574commemorat__e_s
commemorating1953074commemorati__ng
commemoration1853884commemorati__on
commemorations1953444commemorati_ons
communicatively2982954communicatively
comparatively2553714co_m_paratively
contemplatively2771894contemplatively
cooperatively2354194coope__ratively
combatively2354645co___m_batively
commemorator1772615commemorat___or
commemorators1862455commemorat__ors
commensurately2361745commensurat__ely
commiseratingly2571265commiseratingly
commiserative2283275commiserative__
competitively2562815compe__titively
connotatively21102685co__nnotatively
conservatively25133875conse_rvatively
correlatively2153215corre__latively
decoratively2154445___decoratively
imperatively2255575_impe__ratively
operatively1946275_o_pe__ratively
pejoratively2753675___pejoratively
adumbratively2462056__adumbratively
coercively2053486co__e__r_cively
collaborative2092386collaborative__
collaboratives21101946collaborative_s
collectively22114626colle___ctively
comfortingly2371876co_m_for_tingly
commercially2354146comme__r_cially
communicative2454666communicative__
commutative2055846co_m_mutative__
commutativity2561976co_m_mutativity
comparative20176216co_m_parative__
comparatives21164856co_m_parative_s
compensative2154656compe_nsative__
concentrative2056216concentrative__
confederative2253756confederative__
connectively2255186conne___ctively
consecrative1957316conse_crative__
consecutively2383256conse__cutively
consumptively2562476consum__ptively
contemplative22123706contemplative__
contemplatives23122776contemplative_s
contemporarily23101976contemporari__ly
contrastively2153866co___ntrastively
cooperative1847056coope__rative__
cooperatives1965556coope__rative_s
corporately1854126co__rporat__ely
corporative1847156co__rporative__
correctively2254866corre___ctively
corroborative2062106corroborative__
creatively1846676c__re___atively
cumulatively2253066c___umulatively
curatively1845736c_____uratively
demonstratively24172506demonstratively
emotively1744406____emo__tively
emulatively1954516____emulatively
evocatively2253686____evocatively
exploratively2862426__exploratively
federatively2253906___federatively
formatively2254526fo__rm__atively
immemorially1862096_immemor__ially
iteratively1745916__ite__ratively
meditatively2153566___meditatively
normatively1954636no__rm__atively
opinionatively2271276_opinionatively
postoperatively2591266postoperatively
preparatively2353646__preparatively
reiteratively1953796reite__ratively
remonstratively23172506remonstratively
remuneratively2262596_remuneratively

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.360496363.9
2DLD Change Limit95024778.33011407.4
3Display Results77770.0461673.9
 (SQL Overall)178691778.73620454.6
 
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.