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

45 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
gastroscope166425(None) 
gastroscopes17104681gastroscopes
gastroscopy1972991gastroscopy
gastroscopic1963562gastroscopic
gastroscopies18143562gastroscopies
aeroscope1347683_a_eroscope
arthroscope1895003_arthroscope
baroscope1546573ba__roscope
cystoscope1953903cyst_oscope
gastronome1383553gastro_nome
gastroscopist1863083gastroscopist
gyroscope1755013g__yroscope
laparoscope1763163laparoscope
aeroscopes1448014_a_eroscopes
arthroscopes19125314_arthroscopes
arthroscopy21133654_arthroscopy
astrocyte1465834_astro_cyte
astrodome1254514_astro_dome
baroscopes1646754ba__roscopes
cystoscopes2053924cyst_oscopes
cystoscopy2252704cyst_oscopy
dichroscope2154034dichroscope
electroscope18145294electroscope
fetoscope1655264_fet_oscope
fluoroscope18194284fluoroscope
galvanoscope2061414galvanoscope
gastronomes1483794gastro_nomes
gastronomy1652934gastro_nomy
gastropod1343674gastro_po_d
gastropods1453704gastro_pods
gastroscopists1972134gastroscopists
gyroscopes1845074g__yroscopes
hagioscope1853694ha_gioscope
horoscope1647274__horoscope
laparoscopes1873414laparoscopes
laparoscopy2072124laparoscopy
microscope18138574_microscope
otoscope1246434__ot_oscope
radarscope1552204radar_scope
spectroscope2063204spectroscope
statoscope1454724__statoscope
stereoscope1554224__stereoscope
stethoscope1863634stethoscope
stroboscope1762914__stroboscope
urethroscope1962664urethroscope

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 Filter1786911488190.1731032896.0
2DLD Change Limit148819459.56015566.8
3Display Results45450.0331363.6
 (SQL Overall)178691459.76618297.3
 
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.