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

135 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
stereographies205424(None) 
stenographies19125312ste_nographies
stereographed2053902stereograph_ed
stereographic2154882stereographi_c
stereographing21112422stereographing
stereographs1855182stereograph__s
arteriographies2172743arteriographies
choreographies2555273choreographies
petrographies2157143petr_ographies
scenographies21124523sce_nographies
serigraphies18114763s_er_igraphies
stereograph1755013stereograph___
stereography2154973stereograph__y
stylographies2254353st_ylographies
telegraphies1854773_tele_graphies
thermographies2554693thermographies
xerographies2586713_xer_ographies
aortographies1955734_aortographies
biogeographies2353354biogeographies
cartographies2156044_cartographies
chirographies2465904chir_ographies
chorographies2487434chor_ographies
demographies2156414_de_mographies
ethnographies2254934et_hnographies
flexographies2953544fle_xographies
geographies1856614___geographies
hydrographies2675804hydr_ographies
ideographies1955774__ideographies
oceanographies2263054oceanographies
orographies1767794__or_ographies
paleographies2155734_paleographies
pornographies2165964_pornographies
renographies1866534_re_nographies
reprographies2196094_reprographies
seismographies2253344seismographies
sonographies1846614s__onographies
spectrographies2562444spectrographies
stenographer1875304ste_nograph_er
stenographers19104094ste_nographers
stenographic2055904ste_nographi_c
stereograms1453434stereogra___ms
stereoscopies1763464stereoscop_ies
stereotypies1753294stereo_typ_ies
stratigraphies2062014stratigraphies
tomographies20127364_t_omographies
topographies20116934_t_opographies
typographies23105664_t_ypographies
venographies2165674_ve_nographies
videographies2354424_videographies
zoogeographies301864574zoogeographies
angiographies2054365_angiographies
arteriographic2272815arteriographi_c
autobiographies2362335autobiographies
autographies1856955__autographies
bibliographies2463385bibliographies
biographies1996495___biographies
cacographies2255725__cacographies
cardiographies2353715cardiographies
choreographed25104825choreograph_ed
choreographer2495745choreograph_er
choreographers2594535choreographers
choreographic2655875choreographi_c
choreographing2663295choreographing
choreographs2356195choreograph__s
chronographies2574935chronographies
cosmographies2355055_cosmographies
cryptographies2754085cryptographies
demographics2355765_de_mographics
discographies2284585_discographies
epigraphies1954935__e_pigraphies
ergographs1746365__ergograph__s
filmographies2454305_filmographies
fluorographies2392875fluorographies
hagiographies2354925_hagiographies
heterotrophies2263225heter_otrophies
holographies2148125__holographies
iconographies2155055_iconographies
kymographies2754485__kymographies
lexicographies2962645lexicographies
lithographies2295275_lithographies
lymphographies3062645lymphographies
mammographies2253565_mammographies
metallographies2362405metallographies
micrographics2555645micr_ographics
mythographies2754555_mythographies
nomographies20126605__nomographies
orthographies2255105_orthographies
oscillographies2381775oscillographies
petrographer2057285petr_ograph_er
petrographers2155075petr_ographers
petrographic2278025petr_ographi_c
phlebographies2763305phlebographies
phonographies2447475_phonographies
photographies2459415_photographies
physiographies2854195physiographies
pictographies2355635_pictographies
planographies2164885_planographies
polarographies2253535polarographies
radiographies2055825_radiographies
reprographics2395175_reprographics
scenographer2064705sce_nograph_er
scenographers2173635sce_nographers
scenographic2275195sce_nographi_c
scintigraphies2261695scintigraphies
serigrapher1754465s_er_igraph_er
serigraphers1853575s_er_igraphers
serigraphs1645435s_er_igraph__s
shadowgraphies2761505shadowgraphies
stenography2045605ste_nograph__y
stereogram1353885stereogra____m
stereologies1345915stereo__logies
stereophonies1872655stereo_phonies
stereopses1254695stereo___p_ses
stereopsis1263445stereo___psi_s
stereoscopes1654295stereoscop__es
stereotypes16103885stereo_typ__es
supergraphics2362055s_upergraphics
telegraphed1853865_tele_graph_ed
telegrapher1754505_tele_graph_er
telegraphers1853795_tele_graphers
telegraphese1852475_tele_graph_ese
telegrapheses1961675_tele_grapheses
telegraphic1954935_tele_graphi_c
telegraphing1962975_tele_graphing
telegraphist1863605_tele_graphist
telegraphists1961875_tele_graphists
telegraphs1645195_tele_graph__s
thermographer2464885thermograph_er
thermographers2553685thermographers
thermographic2655655thermographi_c
thermographs2355655thermograph__s
uranographies1954245_uranographies
xerographic2667925_xer_ographi_c
xylographies2855265__xylographies
zoographies2645805___zoographies

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.373479064.3
2DLD Change Limit950241356.83013912.7
3Display Results1351350.0931451.6
 (SQL Overall)1786911357.29624491.6
 
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.