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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
oceanographical257224(None) 
oceanographic2353402oceanographic__
cacographical2263413_c_acographical
iconographical2463283ic_onographical
oceanographies2263053oceanographi_es
cartographical2463344_cartographical
chirographical2783504_chirographical
cosmographical2693324_cosmographical
demographical2454174_de_mographical
ethnographical2563214_ethnographical
geographical2164534_ge__ographical
oceanographer2162964oceanograph__er
oceanographers2262294oceanograph_ers
oceanography2353414oceanograph___y
orographical2054394o___rographical
orthographical2563054o_rthographical
petrographical2463894_petrographical
scenographic2275194sce_nographic__
bibliographical2772465bibliographical
biogeographical2682735biogeographical
biographical2254515___biographical
discographical2562835_discographical
epigraphical2263585__e_pigraphical
hagiographical2663225_hagiographical
iconographic2255615ic_onographic__
lexicographical3292215lexicographical
nonbiographical2572235nonbiographical
paleographical2463665_paleographical
physiographical3172865physiographical
planographic2255465_planographic__
renographic1947405_re_nographic__
scenographies21124525sce_nographi_es
stenographic2055905ste_nographic__
topographical2354215__topographical
typographical2663895__typographical
xylographical3163575__xylographical
zoogeographical332134495zoogeographical
barographic2146566__barographic__
cacographies2255726_c_acographi_es
cartographic2266756_cartographic__
chirographic2556376_chirographic__
chorographic2548556_chorographic__
chronographic2655516chronographic__
cosmographic2455786_cosmographic__
demographic2247866_de_mographic__
demographically2963886_de_mographically
demographics2355766_de_mographic_s
ethnographic2355316_ethnographic__
flexographic3063996fle_xographic__
geographic1947756_ge__ographic__
geographically2664586_ge__ographically
graphical1745886______graphical
heliographic2356946_heliographic__
hieroglyphical2871566hie_roglyphical
iconographies2155056ic_onographi_es
ideographic2056876ide__ographic__
ideographically27113716ide__ographically
monographic2148556__monographic__
ochlocratical1961436oc_hlocra_tical
orographic1849076o___rographic__
orthographic2355636o_rthographic__
oscillographic2481986oscillographic__
pantographic2256586__pantographic__
petrographic2278026_petrographic__
phonographic2548436_phonographic__
planographies2164886_planographi_es
polarographic2394136polarographic__
pornographic2286656_pornographic__
renographies1866536_re_nographi_es
reprographic2296656_reprographic__
reprographics2395176_reprographic_s
scenographer2064706sce_nograph__er
scenographers2173636sce_nograph_ers
scenography2254846sce_nograph___y
stenographies19125316ste_nographi_es
stereographic2154886stereographic__
thermographic2655656thermographic__
uranographies1954246_uranographi_es
venographies2165676_ve_nographi_es
xerographic2667926_xe_rographic__
xerographically3363646_xe_rographically

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.373479064.3
2DLD Change Limit95024818.03011833.6
3Display Results81810.0631285.7
 (SQL Overall)178691818.46621106.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.