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

85 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
cosmographic245578(None) 
cosmographer2254882cosmographer
cosmographical2693322cosmographical
cosmographies2355052cosmographies
cosmography2445592cosmograph_y
homographic24410072ho_mographic
nomographic2147922no_mographic
tomographic2148772to_mographic
aortographic2056453aortographic
cartographic2266753cartographic
chirographic2556373chirographic
choreographic2655873choreographic
chorographic2548553chorographic
cosmographers2353593cosmographers
demographic2247863_demographic
discographic2354663discographic
holographic2269523ho_lographic
iconographic2255613ico_nographic
kymographic2845733_kymographic
logographic2047063lo_gographic
mammographic2354183mammographic
monographic2148553mo_nographic
orographic1849073_o_rographic
pornographic2286653pornographic
seismographic2373783seismographic
topographic2167713to_pographic
allographic1947434_allographic
angiographic2155254angiographic
autographic1948044_autographic
barographic2146564_barographic
biogeographic2453954biogeographic
biographic2047444__biographic
calligraphic2252874calligraphic
cardiographic2454214cardiographic
chronographic2655514chronographic
cosmogenic1754104cosmog__enic
cosmogonic1752994cosmog__onic
cryptographic2864464cryptographic
cymograph2296844c_ymograph__
cymographs2397004c_ymograph_s
demographics2355764_demographics
ethnographic2355314ethnographic
flexographic3063994flexographic
geographic1947754__geographic
hagiographic2495724hagiographic
heliographic2356944heliographic
homograph20810414ho_mograph__
homographs21710544ho_mograph_s
hydrographic2756354hydrographic
ideographic2056874_ideographic
idiographic2046794_idiographic
isomorphic1954784isomo_r_phic
lithographic2355694lithographic
micrographic2467124micrographic
nomograph1787544no_mograph__
nomographies20126604no_mographies
nomographs1877804no_mograph_s
nomography2166804no_mograph_y
oceanographic2353404oceanographic
orthographic2355634orthographic
paleographic2276554paleographic
pantographic2256574pantographic
petrographic2278024petrographic
phonographic2548434phonographic
photographic25410304photographic
physiographic2954644physiographic
pictographic2456384pictographic
planographic2255464planographic
polarographic2394134polarographic
polygraphic2464714po_lygraphic
radiographic2156364radiographic
renographic1947404_renographic
reprographic2296654reprographic
scenographic2275194scenographic
stenographic2055904stenographic
thermographic2655654thermographic
tomograph1788704to_mograph__
tomographies20127354to_mographies
tomographs1889084to_mograph_s
tomography2177794to_mograph_y
typographic2456454_typographic
xerographic2667924_xerographic
xylographic2946104_xylographic
zoogeographic3153184zoogeographic
zoomorphic2854434zoomo_r_phic

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.1731032896.0
2DLD Change Limit124790858.06315476.9
3Display Results85850.0601416.7
 (SQL Overall)178691858.29621539.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.