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

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

71 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
deconcentrating2163081deconcentrating
deconcentration20103622deconcentration
reconcentrating2063342reconcentrating
concentrating1856433__concentrating
deconcentrate1873473deconcentrat__e
deconcentrated2093003deconcentrat_ed
deconcentrates1993143deconcentrat_es
reconcentration1963993reconcentration
concentration1758014__concentration
concentrations1877074__concentrations
concentrative2056214__concentrative
deconsecrating2053634deconse_crating
reconcentrate1793894reconcentrat__e
reconcentrated1983344reconcentrat_ed
reconcentrates1893484reconcentrat_es
concentrate15118355__concentrat__e
concentrated17116735__concentrat_ed
concentrates16118215__concentrat_es
concentrator1655335__concentrat_or
concentrators1754995__concentrators
decompensating2262525decompen_sating
deconsecration1954785deconse_cration
deconsecrations2064515deconse_crations
defenestrating19112545defen_estrating
demonstrating17104765demon__strating
reconsecrating1954195reconse_crating
accentuating1762836_ac__centuating
commentating1957046__comment_ating
concelebrating2172596__concelebrating
concentering1755446__concent_ering
concentratedly2262176__concentratedly
concentric1346136__concentr__i_c
concentricity1963726__concentricity
concertina14410626__conce__r_tina
concerting15313896__conce__r_ting
concertino14910846__conce__r_tino
confederating2054016__confederating
consecrating1747946__conse_crating
decelerating1645596de___celerating
decentralize2455406de___centralize
decentring1446756de___centr__ing
decerebrating1953206dec_ere_brating
decompensation2193366decompen_sation
decompensations22103046decompen_sations
decongestant1662466decongest_a__nt
decongesting1753736deconge___sting
deconsecrate17114176deconse_crat__e
deconsecrated19113856deconse_crat_ed
deconsecrates1894046deconse_crat_es
deconstructing20113906decon__structing
decontaminating2162766decontaminating
decorating14312076deco_____rating
defenestration18173546defen_estration
defenestrations1993306defen_estrations
degenerating1545666de___generating
demonstration16126286demon__stration
demonstrations1795676demon__strations
demonstrative1964216demon__strative
denitrating13128336de__n__itrating
disconcerting1954576disconce__r_ting
disorientating1682706disorient_ating
exonerating1945556_exon_e__rating
penetrating1447666pe__n_e_trating
preconcerting2084416preconce__r_ting
reconceptualize3072516reconceptualize
reconsecration1885566reconse_cration
reconsecrations1995106reconse_crations
reconverting1876406reconve__r_ting
remonstrating1695556remon__strating
reorchestrating2172276re_orchestrating
reorientating1473766re_orient_ating

Search took 8 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.360496363.9
2DLD Change Limit95024717.44012772.0
3Display Results71710.0601183.3
 (SQL Overall)178691717.86022734.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.