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

60 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
demonstrates1515560(None) 
demonstrate14145911demonstrate_
demonstrated16134891demonstrated
remonstrates14146051remonstrates
demonstratives2063192demonstratives
demonstrator1573912demonstrator
demonstrators1673402demonstrators
remonstrate13146402remonstrate_
remonstrated15145572remonstrated
deconsecrates1894043deconsecrates
defenestrates1762463defenestrates
demonstrable1753183demonstrable
demonstrably2052673demonstrably
demonstrating17104763demonstrating
demonstration16126283demonstration
demonstrations1795673demonstrations
demonstrative1964203demonstrative
denitrates1169503de__nitrates
remonstrances1752993remonstrances
remonstrants1473523remonstrants
remonstrator1474073remonstrator
remonstrators1583553remonstrators
administrates1662394administrates
deconcentrates1993134deconcentrates
deconsecrate17114174deconsecrate_
deconsecrated19113854deconsecrated
deconstructed1953694deconstructed
deconstructs1753704deconstructs
decorates12314734deco___rates
defenestrate1662644defenestrate_
defenestrated1862144defenestrated
degenerates1346444degen_erates
democrats1446204demo__crat_s
demodulates1543754demo_dulates
demonetizes2344694demonet_izes
demonstratively24172504demonstratively
denigrates1298104de__nigrates
denitrate10810534de__nitrate_
denitrated1298034de__nitrated
detonates10310424deton___ates
devastates1444664de_vast_ates
downstates1444344d_ownst_ates
exonerates17107334_exon_erates
hemostases1545494hemo_st_ases
hemostats1446394hemo_st_at_s
menstruates1343984__menstruates
monstrances1545004__monstrances
penetrates1248714pe__netrates
prostrates12411984_pro_strates
reconsecrates1784414reconsecrates
reinstates1048284re_inst_ates
remonstrance1653394remonstrance
remonstrant1364614remonstra_nt
remonstrantly1862274remonstrantly
remonstrating1695554remonstrating
remonstration15117124remonstration
remonstrations16116484remonstrations
remonstrative1874564remonstrative
remunerates1375924remun_erates
sequestrates2152474sequestrates

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790608.20315212.7
3Display Results60600.0461304.3
 (SQL Overall)178691608.38921300.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.