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

42 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
electroscopes1915570(None) 
electroscope18145301electroscope_
spectroscopes2163392spectroscopes
electrocutes1655313electro_cutes
electroosmoses1872713electroosmoses
electroshocks2493223electroshocks
electrotypes1965193electro_types
spectroscope2063203spectroscope_
spectroscopies2262673spectroscopies
aeroscopes1448014_ae__roscopes
dichroscopes2254114_dichroscopes
electresses1345974electres__ses
electrocute1555094electro_cute_
electrocuted1754184electro_cuted
electrodes1347284electr___odes
electroforms19104194electro_forms
electrologies1656264electrologies
electrolyses1755634electro_lyses
electrolytes1755944electro_lytes
electrolyzes2655184electro_lyzes
electroosmosis1872764electroosmosis
electrophiles2055124electrophiles
electrophorese21173864electrophorese
electrophorus2063714electrophorus
electroplates1764614electroplates
electroshock2383244electrosho_ck
electrotonus1453894electro_tonus
electrotype1854634electro_type_
electrotyped2064044electro_typed
electrotyper1964074electro_typer
electrotypers2063644electro_typers
fetoscopes1745394_fe_t_oscopes
fluoroscopes19244404fl_uoroscopes
gastroscopes17104694_gastroscopes
laparoscopes1873414_laparoscopes
microscopes19119094_mic_roscopes
spectroscopic2062824spectroscopic
spectroscopist2272554spectroscopist
spectroscopy2362354spectroscop_y
stethoscopes1963814ste_thoscopes
synchroscopes2563434synchroscopes
urethroscopes2062824urethroscopes

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 Filter178691950240.373479064.3
2DLD Change Limit95024425.59616980.7
3Display Results42420.0301400.0
 (SQL Overall)178691425.99929786.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.