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

37 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
concentrators175499(None) 
concentrator1655331concentrator_
concentrates16118212concentrat_es
concentrations1877072concentrations
cogenerators1553983co_generators
commentators1854793comment_ators
concentrate15118353concentrat__e
concentrated17116733concentrat_ed
concentrating1856433concentrating
concentration1758013concentration
concentrative2056213concentrative
consecrators1656053conse_crators
cocurators1447304co_c__urators
cogenerator1454174co_generator_
commemorators1862454commemorators
commentator1755274comment_ator_
compensators1854374compen_sators
concenters14410584concen___ters
concentratedly2262174concentratedly
concertmasters2061544concertmasters
concertos132711134conce__r_to_s
conciliators1695394conc_iliators
consecrator1546384conse_crator_
consecratory1954544conse_cratory
conservators1755974conse_rvators
conspirators1655534con_spirators
contemplators1953574contemplators
continuators14105624contin_uators
contractors1549164co___ntractors
convertors1549134conve__r_tors
cooperators1547004coope__rators
cunctators1443724cunc__t_ators
deconcentrates1993144deconcentrat_es
incinerators1463434_incinerators
orchestrators1872654_orchestrators
potentiators1453224po_tentiators
reconcentrates1893484reconcentrat_es

Search took 6 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 Filter178691950240.343520965.0
2DLD Change Limit95024375.50017277.1
3Display Results37370.0132846.2
 (SQL Overall)178691375.85630514.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.