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

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

36 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
commemorates175357(None) 
commemorate1653661commemorate_
commemorated1852931commemorated
commemoratives2262422commemoratives
commemorator1772612commemorator
commemorators1862452commemorators
commemorating1953073commemorating
commemoration1853883commemoration
commemorations1953443commemorations
commemorative2163043commemorative
commentates17107613comme_ntates
commiserates1853603commiserates
camphorates20124764c_amphorates
coelomates1497574co__elomates
collaborates1673684collaborates
commemoratively2671914commemoratively
commensurate1853024commensurate_
commentaries1856804commentaries
commentate16108174comme_ntate_
commentated1886214comme_ntated
commerces17147234comme__r_ces
commiserate1753894commiserate_
commiserated1963064commiserated
commodores1743974commodor__es
commonages1745914co_m_monages
communicates2055614communicates
commutates1646464co_m_mutates
compensates1745724compe_nsates
concentrates16118214concentrates
confederates1854624confederates
consecrates1548394conse_crates
contemplates1855284contemplates
cooperates1469614coope__rates
copemates1549484co_pem__ates
corporates14410734co__rporates
corroborates1652964corroborates

Search took 8 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 Filter1786911247900.393454684.5
2DLD Change Limit124790366.62318841.9
3Display Results36360.0331090.9
 (SQL Overall)178691367.04925349.8
 
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.