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

61 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
deconcentrate187347(None) 
deconcentrated2093001deconcentrated
deconcentrates1993141deconcentrates
reconcentrate1793891reconcentrate
concentrate15118352__concentrate
reconcentrated1983342reconcentrated
reconcentrates1893482reconcentrates
concentrated17116733__concentrated
concentrates16118213__concentrates
deconcentrating2163083deconcentrating
deconcentration20103623deconcentration
deconsecrate17114173deconse_crate
concentrative2056214__concentrative
concentrator1655334__concentrator
decompensate19123634decompen_sate
deconsecrated19113854deconse_crated
deconsecrates1894044deconse_crates
defenestrate1662644defen_estrate
demonstrate14145914demon__strate
reconcentrating2063344reconcentrating
reconcentration1963994reconcentration
reconsecrate1694754reconse_crate
accentuate1453525_ac__centuate
coelenterate1452705__coelenterate
commentate16108175__comment_ate
concelebrate18103595__concelebrate
concentratedly2262175__concentratedly
concentrating1856435__concentrating
concentration1758015__concentration
concentrators1754995__concentrators
concentric1346135__concentr_ic
condensate1345545__conden_sate
confederate1754835__confederate
consecrate1448435__conse_crate
decelerate1347505de___celerate
decentre11248555de___centr__e
decerebrate1664015dec_ere_brate
decolletage1551485decolle_t_age
decompensated21122895decompen_sated
decompensates20113195decompen_sates
decongestant1662465decongest_ant
decongestants1771895decongestants
decongestive1952395decongest_ive
decontaminate18112915decontaminate
decorate11315195deco_____rate
defenestrated1862145defen_estrated
defenestrates1762465defen_estrates
degenerate1246835de___generate
demonstrated16134895demon__strated
demonstrates15155605demon__strates
denitrate10810535de__n__itrate
disorientate1363385disorient_ate
exonerate16107735_exon_e__rate
fenestrate1345295fe__n_estrate
noncentral1248005__noncentra_l
penetrate1149235pe__n_e_trate
reconsecrated1884395reconse_crated
reconsecrates1784425reconse_crates
remonstrate13146405remon__strate
reorchestrate1872595re_orchestrate
reorientate1153375re_orient_ate

Search took 10 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 Limit124790619.08013743.4
3Display Results61610.0461326.1
 (SQL Overall)178691619.51618778.0
 
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.