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

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

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.

42 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
triggerfishes	21	6	66	(None)
triggerfish	19	5	88	2	triggerfish__
anglerfishes	19	5	124	4	_anglerfishes
archerfishes	23	5	152	4	ar_cherfishes
priggeries	14	4	499	4	prigger_i__es
silverfishes	21	5	178	4	_silverfishes
tilefishes	16	4	460	4	t_i_le_fishes
viperfishes	22	5	250	4	_vi_perfishes
angelfishes	18	6	269	5	__angelfishes
butterfishes	20	5	208	5	_butterfishes
clingfishes	20	5	254	5	cling__fishes
filefishes	19	4	448	5	_fi_le_fishes
frogfishes	20	4	332	5	fr_og__fishes
garfishes	16	16	708	5	____garfishes
gibberishes	19	5	172	5	_gibber_ishes
groggeries	13	5	471	5	grogger_i__es
guitarfishes	19	6	123	5	gui_tarfishes
kingfishes	21	4	370	5	_king__fishes
overfishes	19	4	701	5	___overfishes
pigfishes	18	4	500	5	_pi_g__fishes
piggeries	13	10	789	5	_pigger_i__es
pipefishes	20	4	379	5	_pi_pe_fishes
redfishes	16	4	579	5	_r___edfishes
ribbonfishes	22	6	80	5	_ribbonfishes
rosefishes	16	4	411	5	_r_ose_fishes
staggerbushes	20	6	63	5	staggerbushes
thuggeries	15	4	337	5	thugger_i__es
tigerish	12	4	656	5	t_i_ger_ish__
tigerishly	17	5	210	5	t_i_ger_ishly
tigerishness	16	5	265	5	t_i_ger_ishness
toggeries	11	4	621	5	t_ogger_i__es
trickeries	16	4	715	5	tricker_i__es
triggered	12	4	352	5	trigger____ed
triggering	13	4	388	5	trigger_i__ng
triggermen	14	7	163	5	trigger___men
triggers	10	25	784	5	trigger_____s
trignesses	11	8	821	5	trigne___sses
trimerisms	14	4	454	5	tri_mer_is_ms
trunkfishes	21	5	177	5	tr__unkfishes
vigorishes	17	4	311	5	_vi_gor_ishes
whitefishes	23	5	264	5	whi_te_fishes
wiggeries	14	13	657	5	_wigger_i__es

Search took 10 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	124790	0.406	440125.6
2	DLD Change Limit	124790	42	8.766	14235.7
3	Display Results	42	42	0.016	2625.0
	(SQL Overall)	178691	42	9.188	19448.3