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

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

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.

40 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
torchlights	20	5	177	(None)
torchlight	19	5	262	1	torchlight_
earthlights	18	5	249	3	earthlights
forthrights	21	5	222	3	forthrights
searchlights	21	6	119	3	searchlights
trothplights	21	6	119	3	trothplights
backlights	22	5	399	4	_backlights
birthrights	20	5	189	4	birthrights
cockfights	25	5	183	4	co_ckfights
downlights	18	4	284	4	do_wnlights
droplights	17	5	260	4	_droplights
earthlight	17	5	364	4	earthlight_
firelights	17	6	401	4	fir_elights
flashlights	21	5	188	4	flashlights
footlights	17	14	402	4	fo_otlights
foresights	17	4	375	4	for_esights
forthright	20	5	324	4	forthright_
fortnights	17	5	267	4	for_tnights
highlights	17	5	239	4	_highlights
houselights	18	5	222	4	houselights
jacklights	27	5	279	4	_jacklights
lowlights	16	4	365	4	lo__wlights
moonlights	16	4	299	4	mo_onlights
overlights	17	4	485	4	_overlights
preflights	19	4	332	4	_preflights
relights	12	4	805	4	__r_elights
rushlights	17	6	178	4	_rushlights
searchlight	20	6	176	4	searchlight_
starlights	14	4	398	4	star__lights
stoplights	16	8	311	4	sto__plights
taillights	14	4	334	4	t_aillights
tonights	12	4	459	4	to___nights
topflight	18	4	354	4	to_pflight_
torchieres	15	4	324	4	torch_ieres
torchiers	14	4	507	4	torch_i_ers
torchiest	14	3	803	4	torch_iest_
torchlike	18	4	371	4	torchli__ke
touchlines	15	4	388	4	touchli_nes
trothplight	20	6	154	4	trothplight_
twilights	16	4	253	4	t__wilights

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	148819	0.423	422437.4
2	DLD Change Limit	148819	40	8.876	16766.4
3	Display Results	40	40	0.013	3076.9
	(SQL Overall)	178691	40	9.312	19189.3