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

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

22 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
gromwell	14	4	184	(None)
gromwells	15	4	174	1	gromwells
drywell	14	4	237	3	dr_ywell
goodwill	13	4	286	3	goodwill
grommet	12	26	845	3	gromme_t
grommets	13	23	466	3	grommets
grovel	10	43	1054	3	gro_ve_l
grovels	11	42	781	3	gro_vels
grower	10	46	1493	3	gro_we_r
growers	11	36	1272	3	gro_wers
growl	9	61	1582	3	gro_w__l
growled	12	27	817	3	gro_wled
growler	11	31	897	3	gro_wler
growls	10	47	1111	3	gro_w_ls
growly	13	49	917	3	gro_w_ly
rowel	8	47	2141	3	_ro_we_l
rowels	9	45	1545	3	_ro_wels
tramell	9	39	870	3	tram_ell
trommel	11	31	536	3	tromme_l
trommels	12	25	433	3	trommels
trowel	9	42	1146	3	tro_we_l
trowels	10	35	836	3	tro_wels

Search took 8 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.406	440125.6
2	DLD Change Limit	146162	22	7.093	20606.5
3	Display Results	22	22	0.016	1375.0
	(SQL Overall)	178691	22	7.515	23777.9