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

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

79 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
hydrographic275635(None) 
hydrographer2555792hydrographer
hydrographies2675772hydrographies
hydrography2746192hydrograph_y
barographic2146563_barographic
chirographic2556373chirographic
chorographic2548553chorographic
hagiographic2495723hagiographic
heliographic2356943heliographic
holographic2269523h_olographic
homographic24410073h_omographic
hydrographers2654153hydrographers
hydromorphic2864073hydromorphic
hydropathic2564943hydro_pathic
hydrotropic2255283hydrotrop_ic
hygrograph2355443hygrograph__
hygrographs2455503hygrograph_s
ideographic2056873_ideographic
idiographic2046793_idiographic
kymographic2845733ky_mographic
micrographic2467123micrographic
orographic1849073__orographic
petrographic2278023petrographic
physiographic2954643physiographic
radiographic2156363radiographic
reprographic2296653reprographic
typographic2456453ty_pographic
xerographic2667923_xerographic
xylographic2946103xy_lographic
allographic1947434_allographic
angiographic2155254angiographic
aortographic2056454aortographic
autographic1948044_autographic
biographic2047444__biographic
cardiographic2454214cardiographic
cartographic2266754cartographic
choreographic2655874choreographic
chronographic2655514chronographic
cosmographic2455784cosmographic
cryptographic2864464cryptographic
demographic2247864_demographic
digraphic1845514__d_igraphic
discographic2354664discographic
ethnographic2355314ethnographic
flexographic3063994flexographic
fluorographic24113224fluorographic
geographic1947754__geographic
hieroglyphic2691774hieroglyphic
hydropic1947274hydro___p_ic
hydrostatic2065224hydrosta_tic
iconographic2255614iconographic
lithographic2355694lithographic
logographic2047064_logographic
lymphographic3153094lymphographic
mammographic2354184mammographic
micrographics2555644micrographics
monographic2148554_monographic
nomographic2147924_nomographic
orthographic2355634orthographic
paleographic2276554paleographic
pantographic2256574pantographic
paragraphic2154184_paragraphic
phlebographic2853654phlebographic
phonographic2548434phonographic
photographic25410304photographic
pictographic2456384pictographic
planographic2255464planographic
polarographic2394134polarographic
pornographic2286654pornographic
renographic1947404_renographic
reprographics2395174reprographics
scenographic2275194scenographic
stenographic2055904stenographic
stereographic2154884stereographic
thermographic2655654thermographic
thyrotrophic2573614thy_rotrophic
tomographic2148774_tomographic
topographic2167714_topographic
trigraphic1854754__trigraphic

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790796.43619389.4
3Display Results79790.0461717.4
 (SQL Overall)178691796.62226984.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.