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

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
spectroscopies226267(None) 
spectroscopes2163381spectroscop_es
spectroscope2063202spectroscop_e_
spectroscopic2062822spectroscopi_c
spectroscopist2272542spectroscopist
spectroscopists2371812spectroscopists
electroscopes19155693electroscop_es
spectroscopy2362353spectroscop__y
electroscope18145294electroscop_e_
fetoscopies1853704_fe_t_oscopies
gastroscopies18143564_gastroscopies
microscopies20167244_mic_roscopies
spectrographies2562444spectrographies
spectrometries2062824spectrometries
stereoscopies1763464ste_reoscopies
stethoscopes1963814ste_thoscop_es
synchroscopes2563434synchroscop_es
aeroscopes1448015_ae__roscop_es
arthroscopies2064225_arthroscopies
cryoscopies2054175___cryoscopies
cystoscopies2163345_cyst_oscopies
dichroscopes2254115_dichroscop_es
electrologies1656255electro_logies
endoscopies1654465__e_ndoscopies
fetoscopes1745395_fe_t_oscop_es
fluoroscopies20203075_fluoroscopies
gastroscopes17104685_gastroscop_es
horoscopies1856105___horoscopies
laparoscopies1962675_laparoscopies
microcopies19117855_mic_ro_copies
microscopes19119095_mic_roscop_es
otoscopies1455125___ot_oscopies
periscopes1646355_pe__riscop_es
petrologies1449895_pe_tro_logies
photocopies2058915_phot_o_copies
retinoscopies1772625_retinoscopies
speciosities1653765spec_ios_ities
spectrographs23113385spectrograp_hs
statoscopes1554825s_tat_oscop_es
stereoscopes1654295ste_reoscop_es
stethoscope1863635ste_thoscop_e_
stethoscopic2163005ste_thoscopi_c
synchroscope2463375synchroscop_e_
urethroscopes2062825urethroscop_es
uroscopies1455385____uroscopies

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.346516448.0
2DLD Change Limit95024456.60614384.5
3Display Results45450.0331363.6
 (SQL Overall)178691456.98525582.1
 
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.