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

44 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
reconsecrate169475(None) 
deconsecrate17114171deconsecrate
reconsecrated1884391reconsecrated
reconsecrates1784421reconsecrates
consecrate1448432__consecrate
deconsecrated19113852deconsecrated
deconsecrates1894042deconsecrates
consecrated1646913__consecrated
consecrates1548393__consecrates
reconcentrate1793893reconcentrate
reconsecrating1954193reconsecrating
reconsecration1885563reconsecration
remonstrate13146413remons_trate
unconsecrated1853303unconsecrated
consecrative1957314__consecrative
consecrator1546384__consecrator
consociate1446854__consociate
deconcentrate1873474deconcentrate
deconsecrating2053634deconsecrating
deconsecration1954784deconsecration
demonstrate14145924demons_trate
desecrate1249084de___secrate
exonerate16107734_exon_e_rate
obsecrate1344644___obsecrate
preponderate17193884preponde_rate
reconcentrated1983344reconcentrated
reconcentrates1893484reconcentrates
reconnect1347044reconnec__t_
reconnected1665104reconnec__ted
reconnects1445134reconnec__ts
reconsecrations1995104reconsecrations
reconsolidate16122294reconsolidate
reconstitute1453894reconstitute
reconvert1449474reconve_r_t_
reconverted1745654reconve_r_ted
reconverts1545724reconve_r_ts
recuperate1445934rec_upe_rate
redintegrate1463184redintegrate
regenerate1147964regen_e_rate
reintegrate1274944re_integrate
remonstrated15145574remons_trated
remonstrates14146054remons_trates
remunerate1266254remun_e_rate
reoperate11410184re_o_pe_rate

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.466383457.1
2DLD Change Limit124790447.68616236.0
3Display Results44440.0162750.0
 (SQL Overall)178691448.16821877.0
 
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.