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

60 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
urethroscopes206282(None) 
urethroscope1962661urethroscope_
arthroscopes19125312ar_throscopes
arthroscope1895003ar_throscope_
arthroscopies2064223ar_throscopies
stethoscopes1963813steth_oscopes
aeroscopes1448014_ae__roscopes
arthroscopic2163994ar_throscopic
arthroscopy21133654ar_throscop_y
arthrospores1763534ar_throspores
dichroscopes2254114_dichroscopes
electroscopes19155694electroscopes
fetoscopes1745394_fet__oscopes
gastroscopes17104684gast_roscopes
nephoscopes2054294_neph_oscopes
retinoscopies1772624_retinoscopies
spectroscopes2163384spectroscopes
stethoscope1863634steth_oscope_
synchroscopes2563434synchroscopes
aeroscope1347685_ae__roscope_
arthroses1248735ar_thros___es
arthrospore1663405ar_throspore_
baroscopes1646755___baroscopes
bronchoscopes2492095bronchoscopes
cryoscopes1995255cr___yoscopes
cystoscopes2053925cyst__oscopes
dichroscope2154035_dichroscope_
electroscope18145295electroscope_
endoscopes1545815__e_ndoscopes
erythrocytes2362375erythro_cytes
erythrosines1862555erythros_ines
fetoscope1655265_fet__oscope_
fetoscopies1853705_fet__oscopies
fluoroscopes19244405_fluoroscopes
gastroscope1664255gast_roscope_
gastroscopies18143565gast_roscopies
gyroscopes1845075___gyroscopes
horoscopes1747635___horoscopes
kinetoscopes2062495kinet__oscopes
laparoscopes1873415_laparoscopes
microscopes19119095__microscopes
nephoscope1954095_neph_oscope_
nephrostomes1952915_nephrostomes
orthoscopic2054245or_th_oscopic
otoscopes1346515__ot__oscopes
periscopes1646355_pe__riscopes
radarscopes1652185_radar_scopes
retinoscopy1872515_retinoscop_y
retrocedes1344945_ret_ro_cedes
spectroscope2063205spectroscope_
spectroscopies2262675spectroscopies
statoscopes1554825__statoscopes
stereoscopes1654295ste_reoscopes
stethoscopic2163005steth_oscopic
synchroscope2463375synchroscope_
thermoscopes2164945the_rmoscopes
urediospores1561825ure_diospores
uredospores1452325ure__dospores
urethritises1582215urethr_itises
uroscopies1455385u____roscopies

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.423422437.4
2DLD Change Limit124790609.40613267.1
3Display Results60600.0302000.0
 (SQL Overall)178691609.85918124.7
 
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.