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

76 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
oceanographers226229(None) 
oceanographer2162961oceanographer_
oceanographies2263052oceanographies
scenographers2173632sce_nographers
iconographers2153633ic_onographers
oceanographic2353403oceanograph_ic
oceanography2353413oceanograph__y
scenographer2064703sce_nographer_
stenographers19104093ste_nographers
cartographers2194464_cartographers
chirographers2494694_chirographers
chorographers24106124_chorographers
cosmographers2353594_cosmographers
demographers2154564_de_mographers
ethnographers2293584_ethnographers
geographers1854784_ge__ographers
iconographer2054894ic_onographer_
oceanographical2572244oceanographical
petrographers2155074_petrographers
phonographers2465804_phonographers
pornographers2164494_pornographers
reprographers2154664_reprographers
scenographies21124524sce_nographies
stenographer1875304ste_nographer_
thermographers2553684thermographers
bibliographers2462535bibliographers
biogeographers2382915biogeographers
biographers19155115___biographers
cacographies2255725_c_acographies
calligraphers2162225_calligraphers
cartographer2096115_cartographer_
chirographer23106065_chirographer_
choreographers2594535choreographers
chorographer23118245_chorographer_
coronographs20124925coronograph__s
cosmographer2254885_cosmographer_
cryptographers2762915cryptographers
demographer2046375_de_mographer_
discographers2253195_discographers
epigraphers1953405__e_pigraphers
ethnographer2184785_ethnographer_
geographer1746165_ge__ographer_
glossographers2161765glossographers
hagiographers2353745_hagiographers
holographers2166225__holographers
hydrographers2654165_hydrographers
iconographies2155055ic_onographies
lexicographers29172195lexicographers
lithographers2253905_lithographers
metallographers2371845metallographers
mythographers2793635_mythographers
oleographs1647855ole__ograph__s
paleographers21114245_paleographers
paragraphers2093035__paragraphers
petrographer2057285_petrographer_
phonographer2347865_phonographer_
photographers2457175_photographers
physiographers2863405physiographers
planographies2164885_planographies
pornographer2056015_pornographer_
renographies1866535_re_nographies
reprographer2056255_reprographer_
scenographic2275195sce_nograph_ic
scenography2254845sce_nograph__y
seismographers22142685seismographers
serigraphers1853575_se_rigraphers
stenographies19125315ste_nographies
telegraphers1853795_te_legraphers
thermographer2464885thermographer_
topographers2055075__topographers
typographers2354075__typographers
uranographies1954245_uranographies
venographies2165675_ve_nographies
videographers2353405_videographers
xylographers2853815__xylographers
zoogeographers3062375zoogeographers

Search took 8 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 Limit95024766.97013633.3
3Display Results76760.0461652.2
 (SQL Overall)178691767.37624226.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.