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]

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

28 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_

Search took 5 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 Filter178691658740.330541487.9
2DLD Change Limit65874284.29615333.8
3Display Results28280.0161750.0
 (SQL Overall)178691284.64238494.4
 
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.