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

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

142 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
phonographs224890(None) 
phonograph2148811phonograph_
phonography2568301phonography
photographs22411471photographs
chronographs23145842chronographs
holographs1979982_holographs
homographs21710542_homographs
monographs1848882_monographs
phonograms1845702phonogra_ms
phonographer2347862phonographer
phonographers2465802phonographers
phonographic2548432phonographic
phonographies2447472phonographies
photograph21411012photograph_
photography25410072photography
bolographs1867533_bolographs
choreographs2356193choreographs
chorography2548453chorography
chronograph22146073chronograph_
chronography26125743chronography
coronographs20124923coronographs
holograph1879663_holograph_
holography2278613_holography
homograph20810413_homograph_
iconography2245453iconography
logographs1746923_logographs
monograph1748643_monograph_
nomographs1877803_nomographs
odographs1667343__odographs
pantographs1946573pantographs
phonogram1746363phonogra__m
phonogramic2154573phonogramic
photograms1848193photogra_ms
photographed2458663photographed
photographer2349693photographer
photographers2457173photographers
photographic25410313photographic
photographies2459413photographies
pictographs2146553pictographs
planography2255163planography
polygraphs2145303p_olygraphs
pornography2246213pornography
rephotographs2464033rephotographs
sonography1947203_sonography
tomographs1889083_tomographs
topographs1888043_topographs
allographs1648064_allographs
anemographs1955414anemographs
autographs1648734_autographs
barographs1847074_barographs
bolograph1767294_bolograph_
chirography2546134chirography
choreograph2256154choreograph_
choreography2656004choreography
chorographer23118244chorographer
chorographers24106124chorographers
chorographic2548554chorographic
chorographies2487434chorographies
chronograms1953934chronogra_ms
chronographic2655514chronographic
chronographies2574934chronographies
coronagraphs20152364coronagraphs
coronograph19124934coronograph_
cymographs2397004_cymographs
ergographs1746364_ergographs
ethnography2355144ethnography
hectographs2256204hectographs
heliographs2047124heliographs
holograms1547364_hologra_ms
holographed21107624_holographed
holographer2088394_holographer
holographers2166224_holographers
holographic2269524_holographic
holographies2148124_holographies
homografts1953724_homografts
homographic24410074_homographic
honorands1345024_hono_rands
hoorahs13399604_ho_o_ra_hs
hygrographs2455504hygrographs
iconographer2054894iconographer
iconographers2153634iconographers
iconographic2255614iconographic
iconographies2155054iconographies
ideographs1746784_ideographs
isographs1546724__isographs
kymographs25115544_kymographs
lithographs2065644lithographs
logograph1646584_logograph_
logogriphs1752354_logogriphs
micrographs2147784micrographs
mimeographs2184764mimeographs
monograms1478264_monogra_ms
monographed2046554_monographed
monographic2148554_monographic
myographs2085704__myographs
nomograph1787544_nomograph_
nomography2166804_nomography
odograph1577334__odograph_
oleographs1647854_oleographs
orography1847954__orography
paleography2246174paleography
pantograph1847064pantograph_
paragraphs1844844p_aragraphs
petrography2247544petrography
phlebography2853614phlebography
phonogrammic2452684phonogrammic
phonotypes2044764phono_types
photogram1748234photogra__m
photographing2565984photographing
photomaps1845604photo_map_s
physiography2954494physiography
pictograph2046654pictograph_
pictography2446074pictography
planographic2255464planographic
planographies2164884planographies
pneumographs2253594pneumographs
polygraph2045104p_olygraph_
pornographer2056014pornographer
pornographers2164494pornographers
pornographic2286654pornographic
pornographies2165964pornographies
prototrophs18195374prototrophs
psychographs2854244psychographs
radiographs1856524radiographs
renography1947024_renography
rephotograph2364184rephotograph_
scenography2254844scenography
shadowgraphs2591624shadowgraphs
sonograms1296304_sonogra_ms
sonographies1846614_sonographies
sphygmographs3061994sphygmographs
stenography2045604stenography
thermographs2355654thermographs
tomograph1788714_tomograph_
tomography2177794_tomography
topograph1787484_topograph_
topography2177094_topography
typographs2196484_typographs
uranography2054184uranography
venography2245764_venography
xylographs2645664_xylographs
zoography2745664_zo_ography

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191428.25018038.7
3Display Results1421420.0761868.4
 (SQL Overall)1786911428.74920424.2
 
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.