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) 
demonstrate14145921demonstrate_
demonstrated16134891demonstrated
remonstrates14146051remonstrates
demonstratives2063202demonstratives
demonstrator1573922demonstrator
demonstrators1673412demonstrators
remonstrate13146412remonstrate_
remonstrated15145572remonstrated
deconsecrates1894043deconsecrates
defenestrates1762463defenestrates
demonstrable1753183demonstrable
demonstrably2052673demonstrably
demonstrating17104763demonstrating
demonstration16126283demonstration
demonstrations1795673demonstrations
demonstrative1964213demonstrative
denitrates1169513de__nitrates
remonstrances1752993remonstrances
remonstrants1473533remonstrants
remonstrator1474083remonstrator
remonstrators1583563remonstrators
administrates1662394administrates
deconcentrates1993144deconcentrates
deconsecrate17114174deconsecrate_
deconsecrated19113854deconsecrated
deconstructed1953704deconstructed
deconstructs1753714deconstructs
decorates12314744deco___rates
defenestrate1662644defenestrate_
defenestrated1862144defenestrated
degenerates1346454degen_erates
democrats1446204demo__crat_s
demodulates1543754demo_dulates
demonetizes2344704demonet_izes
demonstratively24172504demonstratively
denigrates1298114de__nigrates
denitrate10810534de__nitrate_
denitrated1298034de__nitrated
detonates10310434deton___ates
devastates1444664de_vast_ates
downstates1444344d_ownst_ates
exonerates17107344_exon_erates
hemostases1545494hemo_st_ases
hemostats1446394hemo_st_at_s
menstruates1343984__menstruates
monstrances1545014__monstrances
penetrates1248724pe__netrates
prostrates12411994_pro_strates
reconsecrates1784424reconsecrates
reinstates1048294re_inst_ates
remonstrance1653404remonstrance
remonstrant1364634remonstra_nt
remonstrantly1862274remonstrantly
remonstrating1695554remonstrating
remonstration15117124remonstration
remonstrations16116484remonstrations
remonstrative1874574remonstrative
remunerates1375944remun_erates
sequestrates2152484sequestrates

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.390458182.1
2DLD Change Limit124790606.64018793.7
3Display Results60600.0331818.2
 (SQL Overall)178691607.06325299.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.