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

70 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
concentrates1611821(None) 
concentrate15118351concentrate_
concentrated17116731concentrated
concentrator1655332concentrator
concentrators1754992concentrators
deconcentrates1993142deconcentrates
reconcentrates1893482reconcentrates
coelenterates1552853coelenterates
commentates17107613comment_ates
concelebrates19113583concelebrates
concentratedly2262173concentratedly
concentrating1856433concentrating
concentration1758013concentration
concentrations1877073concentrations
concentrative2056213concentrative
condensates1445313conden_sates
confederates1854623confederates
consecrates1548393conse_crates
deconcentrate1873473deconcentrate_
deconcentrated2093003deconcentrated
reconcentrate1793893reconcentrate_
reconcentrated1983343reconcentrated
accentuates1553064_accentuates
coacervates1883594coace_rvates
coelenterate1452704coelenterate_
commemorates1753574commemorates
commentaries1856804commentaries
commentate16108174comment_ate_
commentated1886214comment_ated
compensates1745724compen_sates
concatenates1654534concatenates
concelebrate18103594concelebrate_
concelebrated2093054concelebrated
concenter13312214concen___ter
concentered1645014concent_ered
concenters14410594concent__ers
concentric1346134concentr__ic
concentricities1872914concentricities
concents122516604concen___t_s
conceptacles1773794conceptacles
conceptuses1774514concept_uses
concerted14312114conce__r_ted
concertizes24158584concert_izes
concertmaster1962044concertmaster
concertmasters2061544concertmasters
concertos132711134conce__r_tos
concerts123016064conce__r_t_s
conciliates1546884conc_iliates
concretes13411474conc___retes
condensate1345544conden_sate_
conepates13912284con_e__pates
confederate1754834confederate_
confederated1953994confederated
consecrate1448434conse_crate_
consecrated1646914conse_crated
contemplates1855284contemplates
conventicles1954164conventicles
conventuals1665174conventua_ls
cooperates1469614coope__rates
countertrades1655894countertrades
incinerates1346034_incinerates
intenerates1148084_intenerates
licentiates1354204_licentiates
noncentral1248004noncentra__l
nonentries1048284non_entr_ies
orchestrates1773794_orchestrates
orientates1046044_orient_ates
penetrates1248724pen_e_trates
potentates12106334po_tent_ates
potentiates13114864po_tentiates

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.373479064.3
2DLD Change Limit124790707.86015876.6
3Display Results70700.0461521.7
 (SQL Overall)178691708.27921583.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.