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 “oscillographiesa” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
oscillographies2381771oscillographies_
oscillographic2481983oscillographi__c
oscillographs2162093oscillograph__s_
oscillograph2062104oscillograph____
oscillography2482154oscillograph___y
calligraphies2153195__calligraphies_
filmographies2454305__filmographies_
metallographies2362405metallographies_
oceanographies2263055o_ceanographies_
oscillograms17121425oscillogra___ms_
scenographies21124525_sc_enographies_
scintigraphies2261695_scintigraphies_
seismographies2253345_seismographies_
stylographies2254355_s_tylographies_
angiographies2054366angi__ographies_
bibliographies2463386_bibliographies_
biographies1996496__bi__ographies_
cacographies2255726__c_acographies_
calligraphist2182116__calligraphi_st
cartographies2156046__cartographies_
chirographies2465906__chirographies_
chorographies2487436__chorographies_
cosmographies2355056__cosmographies_
discographies2284586__discographies_
hagiographies2354926hagi__ographies_
holographies2148126___holographies_
iconographies2155056_ic_onographies_
ideographies1955776___ideographies_
lexicographies2962646lexi_cographies_
lithographies2295276__lithographies_
orographies1767796o____rographies_
orthographies2255106o__rthographies_
oscillogram16111706oscillogra_____m
oscilloscopes1981656oscilloscop__es_
paleographies2155736__paleographies_
pictographies2355636__pictographies_
radiographies2055826radi__ographies_
sonographies1846616_s__onographies_
stenographies19125316_s_tenographies_
stereographies2054246_stereographies_
videographies2354426__videographies_
xylographies2855266___xylographies_
allographic1947437___allographi__c
allographs1648067___allograph__s_
aortographies1955737__aortographies_
arteriographies2172747arteriographies_
autobiographies2362337autobiographies_
autographies1856957___autographies_
biogeographies2353357_biogeographies_
biographees19124537__bi__ographees_
calligrapher2052587__calligraph_e_r
calligraphers2162227__calligraph_ers
calligraphic2252877__calligraphi__c
calligraphists2291137__calligraphists
cardiographies2353717_cardiographies_
choreographies2555277_choreographies_
chronographies2574937_chronographies_
cryptographies2754087_cryptographies_
demographies2156417___demographies_
epigraphies1954937_epi___graphies_
ethnographies2254937__ethnographies_
flexographies2953547__flexographies_
fluorographies2392877_fluorographies_
geographies1856617____geographies_
hydrographies2675807__hydrographies_
kymographies2754487___kymographies_
lymphographies3062647_lymphographies_
mammographies2253567__mammographies_
metallographer2262337metallograph_e_r
metallographers2371847metallograph_ers
metallographic2462417metallographi__c
micrographics2555647__micrographics_
mythographies2754557__mythographies_
nomographies20126607___nomographies_
oceanographer2162967o_ceanograph_e_r
oceanographers2262297o_ceanograph_ers
oceanographic2353407o_ceanographi__c
oceanographical2572247o_ceanographical
ochlocracies1861937o_c_hlocra_cies_
oleographs1647857o___leograph__s_
oscillates1244777oscill___a__tes_
oscilloscope1871677oscilloscop__e__
oscilloscopic1891317oscilloscop_i__c
petrographies2157147__petrographies_
phlebographies2763307_phlebographies_
phonographies2447477__phonographies_
photographies2459417__photographies_
physiographies2854197_physiographies_
planographies2164887__planographies_
polarographies2253537_polarographies_
pornographies2165967__pornographies_
prosopographies2262087prosopographies_
renographies1866537___renographies_
reprographies2196097__reprographies_
scenographer2064707_sc_enograph_e_r
scenographers2173637_sc_enograph_ers
scenographic2275197_sc_enographi__c
scintigraphic23101777_scintigraphi__c
seismographer21143407_seismograph_e_r
seismographers22142687_seismograph_ers
seismographic2373787_seismographi__c
seismographs20123917_seismograph__s_
serigraphies18114767_s__erigraphies_
shadowgraphies2761507_shadowgraphies_
sociologies1447807sociolog____ies_
spectrographies2562447spectrographies_
stratigraphies2062017_stratigraphies_
telegraphies1854777___telegraphies_
thermographies2554697_thermographies_
tomographies20127367___tomographies_
topographies20116937___topographies_
typographies23105667___typographies_
uranographies1954247__uranographies_
venographies2165677___venographies_
xerographies2586717___xerographies_
zoogeographies301864577_zoogeographies_
zoographies2645807____zoographies_

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 Filter178691950240.360496363.9
2DLD Change Limit950241177.67312384.2
3Display Results1171170.0931258.1
 (SQL Overall)1786911178.12621990.0
 
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.