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

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

63 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
deconcentration2010362(None) 
reconcentration1963991reconcentration
concentration1758012__concentration
deconcentrating2163082deconcentrating
concentrations1877073__concentrations
deconcentrate1873473deconcentrat__e
deconcentrated2093003deconcentrat_ed
deconcentrates1993143deconcentrat_es
deconsecration1954783deconse_cration
reconcentrating2063343reconcentrating
concentrating1856434__concentrating
concentrative2056214__concentrative
concentrator1655334__concentrat_or
decompensation2193364decompen_sation
deconsecrations2064514deconse_crations
defenestration18173544defen_estration
demonstration16126284demon__stration
reconcentrate1793894reconcentrat__e
reconcentrated1983344reconcentrat_ed
reconcentrates1893484reconcentrat_es
reconsecration1885564reconse_cration
accentuation1653465_ac__centuation
cogeneration1546445__co_generation
concelebration20133565__concelebration
concentrate15118355__concentrat__e
concentrated17116735__concentrat_ed
concentrates16118215__concentrat_es
concentrators1754995__concentrators
condensation1546785__conden_sation
confederation1995255__confederation
consecration1649785__conse_cration
contestation1448665__contest_ation
decantation1448945de___cant_ation
deceleration1547175de___celeration
decerebration1884195dec_ere_bration
decolonization26146025deco_lonization
decompensations22103045decompen_sations
decongestion1653925deconge___stion
deconsecrating2053635deconse_crating
deconstruction19134435decon__struction
decontamination2083255decontamination
decoration13314425deco_____ration
defenestrations1993305defen_estrations
deforestation1754305defo_rest_ation
degeneration1447285de___generation
demonetization2655875demon_etization
demonstrations1795675demon__strations
depigmentation20103045depigment_ation
disorientation1583775disorient_ation
documentation18144725doc_ument_ation
exoneration1847655_exon_e__ration
exponentiation2361795expon_entiation
fenestration1596075fe__n_estration
penetration1349895pe__n_e_tration
recommendation2183225recommen_dation
reconception1855645reconce___ption
reconciliation1854125reconc_iliation
reconfiguration2162055reconfiguration
reconsecrations1995105reconse_crations
reconsideration18112585reconsideration
remonstration15117125remon__stration
reorchestration2072835re_orchestration
reorientation1375595re_orient_ation

Search took 5 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 Filter178691658740.326548131.9
2DLD Change Limit65874633.92316791.7
3Display Results63630.0461369.6
 (SQL Overall)178691634.29541604.4
 
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.