Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hectograms” with Change Limit: [1] [2] [3] [4]

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

38 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
hectograms	18	11	481	(None)
hectogram	17	11	581	1	hectogram_
hektograms	20	12	373	1	hektograms
echograms	17	4	565	2	_echograms
hectograph	21	4	626	2	hectograph
hectographs	22	5	620	2	hectographs
hektogram	19	9	432	2	hektogram_
heliograms	16	4	485	2	heliograms
histograms	16	4	436	2	histograms
pictograms	17	4	462	2	pictograms
aerograms	12	4	815	3	ae_rograms
cartograms	15	4	511	3	cartograms
centigrams	15	4	308	3	centigrams
decagrams	15	4	374	3	dec_agrams
decigrams	15	4	409	3	dec_igrams
deprograms	16	5	546	3	deprograms
echogram	16	4	639	3	_echogram_
electrograms	17	5	505	3	electrograms
ethograms	15	4	543	3	_ethograms
genograms	13	4	562	3	ge_nograms
hectors	12	35	1326	3	hecto_r__s
heliogram	15	4	557	3	heliogram_
hexagrams	22	4	309	3	he_xagrams
histogram	15	4	455	3	histogram_
holograms	15	4	736	3	h_olograms
micrograms	17	4	778	3	micrograms
nephograms	18	4	449	3	nephograms
pectorals	13	12	815	3	pecto_rals
pentagrams	15	4	316	3	pentagrams
photograms	18	4	819	3	photograms
picograms	16	4	572	3	pic_ograms
pictogram	16	4	516	3	pictogram_
renograms	12	4	676	3	re_nograms
reprograms	15	5	622	3	reprograms
sociograms	15	5	337	3	sociograms
spectrograms	19	5	263	3	spectrograms
thermograms	19	6	448	3	thermograms
venograms	15	4	547	3	ve_nograms

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	140603	0.423	422437.4
2	DLD Change Limit	140603	38	6.296	22332.1
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	6.735	26531.7