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

66 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
concentrated1711673(None) 
concentrate15118351concentrate_
concentrates16118211concentrates
concentratedly2262172concentratedly
concentrator1655332concentrator
deconcentrated2093002deconcentrated
reconcentrated1983342reconcentrated
commentated1886213comment_ated
concelebrated2093053concelebrated
concentered1645003concent_ered
concentrating1856433concentrating
concentration1758013concentration
concentrative2056213concentrative
concentrators1754993concentrators
concerted14312113conce__r_ted
confederated1953993confederated
consecrated1646913conse_crated
deconcentrate1873473deconcentrate_
deconcentrates1993143deconcentrates
reconcentrate1793893reconcentrate_
reconcentrates1893483reconcentrates
accentuated1652704_accentuated
coelenterate1452704coelenterate_
coelenterates1552854coelenterates
commemorated1852934commemorated
commentate16108174comment_ate_
commentates17107614comment_ates
compensated1844864compen_sated
concatenated1753524concatenated
concealed1458134conce___aled
conceited14310424conce___ited
concelebrate18103594concelebrate_
concelebrates19113584concelebrates
concenter13312214concen___ter
concentrations1877074concentrations
concentric1346134concentr__ic
concerned1438644conce__r_ned
concertized25146364concert_ized
concertmaster1962044concertmaster
conciliated1645644conc_iliated
concreted1439414conc___reted
condensate1345544conden_sate_
condensates1445314conden_sates
confederate1754834confederate_
confederates1854624confederates
consecrate1448434conse_crate_
consecrates1548394conse_crates
consented12311944consen___ted
contemplated1954444contemplated
contented12313044conten___ted
contracted1549824co___ntracted
contrasted1348574co___ntrasted
convented15410754conven___ted
converted15311564conve__r_ted
cooperated1567334coope__rated
fenestrated1554244fen_estrated
incinerated1445034_incinerated
intenerated1247014_intenerated
noncentral1248004noncentra__l
nonfederated1753364nonfederated
orchestrated1873414_orchestrated
orientated1144854_orient_ated
penetrated1347304pen_e_trated
potentiated1494364po_tentiated
uncastrated1445384_uncastrated
uncontracted17154144_uncontracted

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 Filter1786911247900.390458182.1
2DLD Change Limit124790666.50019198.5
3Display Results66660.0332000.0
 (SQL Overall)178691666.92325811.2
 
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.