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

Here are the results of your fuzzy-string dictionary search for “grograms” 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.

77 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
grograms	12	4	602	(None)
grogram	11	4	707	1	grogram_
programs	13	3	978	1	programs
aerograms	12	4	815	2	aerograms
barograms	14	4	586	2	barograms
genograms	13	4	562	2	genograms
isograms	11	4	647	2	isograms
program	12	3	1169	2	program_
trigrams	11	11	635	2	trigrams
aerogram	11	4	952	3	aerogram_
anagrams	11	4	659	3	anagrams
angiograms	14	5	366	3	angiograms
barogram	13	4	653	3	barogram_
brogans	10	4	966	3	brog_ans
broughams	17	4	240	3	broughams
cartograms	15	4	511	3	cartograms
deprograms	16	5	546	3	deprograms
diagrams	12	4	613	3	diagrams
echograms	17	4	565	3	echograms
engrams	10	3	807	3	_engrams
epigrams	13	4	611	3	epigrams
ethograms	15	4	543	3	ethograms
forams	11	51	1591	3	_fo_rams
genogram	12	4	673	3	genogram_
ginghams	15	7	389	3	ginghams
gloams	9	52	1066	3	glo__ams
goddams	12	3	398	3	g_oddams
goorals	8	3	870	3	g_oorals
gorals	7	69	1765	3	g_o_rals
gorms	8	56	1959	3	g_o_r_ms
gourami	10	8	380	3	g_ourami
gouramis	11	8	416	3	g_ouramis
grahams	13	3	533	3	gr_ahams
grams	8	53	2731	3	___grams
grandams	12	3	712	3	grandams
grigris	9	3	409	3	grigr_is
groans	7	48	1506	3	gro__ans
groats	7	48	1665	3	gro__ats
grogs	7	63	1941	3	grog___s
grooms	9	45	1252	3	gro__oms
grosgrain	11	5	237	3	grosgrain
grosgrains	12	5	218	3	grosgrains
grugrus	9	4	199	3	grugr_us
holograms	15	4	736	3	holograms
ideograms	13	4	480	3	ideograms
isogram	10	4	725	3	isogram_
jorams	15	48	1053	3	_jo_rams
kilograms	16	4	504	3	kilograms
kymograms	21	4	367	3	kymograms
logjams	17	4	358	3	_logjams
logograms	13	5	469	3	logograms
micrograms	17	4	778	3	micrograms
monograms	14	7	826	3	monograms
nanograms	12	4	484	3	nanograms
nomograms	14	4	537	3	nomograms
ogams	8	41	1268	3	__og_ams
oghams	12	4	585	3	__oghams
ondograms	13	4	456	3	ondograms
pangrams	13	3	715	3	pangrams
picograms	16	4	572	3	picograms
pogroms	12	3	764	3	_pogroms
prograde	12	4	718	3	prograde
programed	15	8	589	3	programed
programer	14	7	560	3	programer
programers	15	8	440	3	programers
programme	16	9	477	3	programme
programmes	17	8	492	3	programmes
progress	11	3	702	3	progress
renograms	12	4	676	3	renograms
reprograms	15	5	622	3	reprograms
roams	7	49	1961	3	_ro__ams
sonograms	12	9	630	3	sonograms
tangrams	11	3	616	3	tangrams
tomograms	14	4	589	3	tomograms
trigram	10	7	776	3	trigram_
venograms	15	4	547	3	venograms
zymograms	26	4	386	3	zymograms

Search took 14 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	146162	0.156	1145455.1
2	DLD Change Limit	146162	77	12.780	11436.8
3	Display Results	77	77	0.063	1222.2
	(SQL Overall)	178691	77	12.999	13746.5