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

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

124 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
mythographers279363(None) 
mythographer26124511mythographer_
lithographers2253902lithographers
mythographies2754552mythographies
ethnographers2293583_ethnographers
hydrographers2654163hydrographers
lithographer2155023lithographer_
mythography2854403mythograph__y
petrographers2155073petrographers
typographers2354073ty_pographers
xylographers2853813xy_lographers
biographers19155114__biographers
cartographers2194464cartographers
chirographers2494694chirographers
chorographers24106124chorographers
cosmographers2353594cosmographers
cryptographers2762914cryptographers
demographers2154564_demographers
discographers2253194discographers
ethnographer2184784_ethnographer_
geographers1854784__geographers
hagiographers2353744hagiographers
holographers2166224_holographers
hydrographer2555804hydrographer_
iconographers2153634iconographers
lithographed2254384lithographe_d
lithographies2295274lithographies
lithographs2065644lithograph__s
metallographers2371844metallographers
myographs2085704my__ograph__s
orthographies2255104orthographies
paleographers21114244paleographers
petrographer2057284petrographer_
phonographers2465804phonographers
photographers2457174photographers
physiographers2863404physiographers
pornographers2164494pornographers
reprographers2154664reprographers
scenographers2173624scenographers
stenographers19104094stenographers
topographers2055074_topographers
typographer2255344ty_pographer_
videographers2353404videographers
xylographer2754834xy_lographer_
autobiographers2372045autobiographers
autographed1856155aut_ographe_d
autographies1856955aut_ographies
autographs1648735aut_ograph__s
bibliographers2462535bibliographers
biogeographers2382915biogeographers
biographees19124535__biographees
biographer18126515__biographer_
calligraphers2162225calligraphers
cartographer2096115cartographer_
chirographer23106065chirographer_
choreographers2594535choreographers
chorographer23118245chorographer_
cosmographer2254885cosmographer_
cryptographer2663745cryptographer_
cymographs2397005cy_mograph__s
demographer2046375_demographer_
discographer2154165discographer_
epigraphers1953405__epigraphers
ethnographies2254935_ethnographies
geographer1746165__geographer_
glossographers2161765glossographers
hagiographer2255015hagiographer_
holographer2088395_holographer_
hydrographies2675805hydrographies
hygrographs2455505hygrograph__s
iconographer2054895iconographer_
kymographies2754485ky_mographies
kymographs25115545ky_mograph__s
lexicographers29172195lexicographers
lithograph1965635lithograph___
lithographic2355695lithograph_ic
lithographing2362815lithographing
lithography2365375lithograph__y
lithotripters186985lithotripters
lymphographies3062645lymphographies
mammographies2253565mammographies
metallographer2262335metallographer_
micrographed2365945micrographe_d
micrographics2555645micrographics
micrographs2147785micrograph__s
mimeographed2353735mimeographe_d
mimeographs2184765mimeograph__s
monogrammers1652605m_onogrammers
monographed2046555m_onographe_d
monographs1848885m_onograph__s
myograph1995545my__ograph___
mythmakers2452195myth__ma_kers
mythologers2052465mytho__logers
mythologizers3152535mythologizers
oceanographers2262295oceanographers
orthographic2355635orthograph_ic
orthography2355175orthograph__y
paleographer20115735paleographer_
paragraphers2093035_paragraphers
petrographies2157145petrographies
phonographer2347865phonographer_
photographer2349695photographer_
physiographer2754345physiographer_
polygraphers2353405_polygraphers
pornographer2056015pornographer_
psychographs2854245psychograph__s
reprographer2056255reprographer_
scenographer2064695scenographer_
seismographers22142685seismographers
serigraphers1853575_serigraphers
stenographer1875305stenographer_
stylographies2254355stylographies
telegraphers1853795_telegraphers
thermographers2553685thermographers
thrashers1565315__th__rashers
topographer1946695_topographer_
typographed2354685ty_pographe_d
typographies23105665ty_pographies
typographs2196485ty_pograph__s
videographer2254325videographer_
xylographed2854225xy_lographe_d
xylographies2855265xy_lographies
xylographs2645665xy_lograph__s
zoogeographers3062375zoogeographers

Search took 10 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.406440125.6
2DLD Change Limit1247901248.51614653.6
3Display Results1241240.0931333.3
 (SQL Overall)1786911249.01519821.5
 
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.