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

50 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
oscillography248215(None) 
oscillograph2062101oscillograph_
oscillographs2162091oscillographs
oscillographic2481982oscillographic
oscillogram16111703oscillogra__m
oscillograms17121423oscillogra_ms
oscillographies2381773oscillographies
calligraphy2262564__calligraphy
filmography2554174__filmography
metallography2462944metallography
oceanography2353414o_ceanography
scenography2254844_sc_enography
scintigraphy2361994_scintigraphy
seismography23133884_seismography
stylography2354534_s_tylography
allograph1547535___allograph_
allographs1648065___allographs
angiography2154515angi__ography
bibliography2553035_bibliography
biography2046225__bi__ography
cacography2345835__c_acography
cartography2246785__cartography
chirography2546135__chirography
chorography2548455__chorography
cosmography2445595__cosmography
crystallography29121225crystallography
discography2354095__discography
hagiography2445505hagi__ography
holography2278615___holography
iconography2245455_ic_onography
ideography2046215___ideography
lexicography3052555lexi_cography
lithography2365375__lithography
oleograph1547365o___leograph_
oleographs1647855o___leographs
orography1847955o____rography
orthography2355175o__rthography
oscilloscope1871675oscilloscop_e
oscilloscopes1981655oscilloscopes
oscilloscopic1891315oscilloscopic
paleography2246175__paleography
pictography2446075__pictography
radiography2165945radi__ography
seismograph19123845_seismograph_
seismographs20123915_seismographs
sonography1947205_s__onography
stenography2045605_s_tenography
stereography2154975_stereography
videography2454435__videography
xylography2945005___xylography

Search took 9 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.406440125.6
2DLD Change Limit124790508.08015444.3
3Display Results50500.0133846.2
 (SQL Overall)178691508.49921024.9
 
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.