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

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

56 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
duplicate144700(None) 
duplicated1655831duplicated
duplicates1546631duplicates
delicate11315492d_elicate
duplicative1954172duplicative
duplicator1544802duplicator
duplicity1744662duplicity
explicate20117492explicate
implicate1547272implicate
plicate11314512__plicate
reduplicate1654042reduplicate
replicate13410042replicate
supplicate1644522supplicate
auspicate1345743auspicate
busticate1357753busticate
complicate1847623complicate
conduplicate1952613conduplicate
dedicate12312803d_edicate
delicates12314313d_elicates
depilate11311703dep_ilate
deprecate1477433deprecate
diplomate1476343diplomate
dislocate1289133dislocate
duplicating1745403duplicating
duplication1647293duplication
duplicators1644293duplicators
duplicities1645333duplicities
explicated22106103explicated
explicates2196663explicates
implicated1745973implicated
implicates1646783implicates
lubricate1346443lubricate
muricate12311113mu_ricate
placate11312433__placate
plicae10410953__plica_e
plicated13310643__plicated
reduplicated1853703reduplicated
reduplicates1753813reduplicates
replicase1344803replicase
replicated1548773replicated
replicates1449453replicates
rubricate1346483rubricate
rusticate1149033rusticate
silicate10312623_silicate
spicate113214193_sp_icate
sublimate1347433sublimate
sulcate9314423su_l_cate
supinate10310313sup_inate
supplicated1843733supplicated
supplicates1744133supplicates
suricate10312613su_ricate
triplicate1445323triplicate
tunicate103310043tu_nicate
unduplicated1853683unduplicated
urticate1049863_urticate
vellicate1446433vellicate

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641566.26623721.8
3Display Results56560.0301866.7
 (SQL Overall)178691566.71926594.9
 
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.