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

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

20 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
chamomile	18	5	360	(None)
camomile	14	15	632	1	c_amomile
chamomiles	19	5	350	1	chamomiles
camomiles	15	15	563	2	c_amomiles
cacomixle	22	5	178	3	c_acomixle
cammie	12	46	1529	3	c_am_mi_e
chamise	14	36	1285	3	cha__mise
chammied	18	21	597	3	cham_mied
chammies	17	29	1016	3	cham_mies
chamois	14	35	1219	3	chamo_i_s
chamoised	17	33	532	3	chamo_ised
chamoises	16	32	793	3	chamo_ises
chamoix	21	27	564	3	chamo_i_x
chemokine	20	8	434	3	chemokine
chromide	16	4	805	3	ch_romide
chromite	15	3	1083	3	ch_romite
chromize	24	4	768	3	ch_romize
chummily	20	4	284	3	chum_mily
clammily	17	4	363	3	clam_mily
hammily	17	3	606	3	_ham_mily

Search took 9 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	148641	0.653	273646.2
2	DLD Change Limit	148641	20	7.706	19289.0
3	Display Results	20	20	0.000
	(SQL Overall)	178691	20	8.359	21377.1