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

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

35 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
underweights	20	5	235	(None)
underweight	19	5	325	1	underweight_
counterweights	23	7	253	3	counterweights
hundredweights	26	8	63	3	hundredweights
overweights	21	5	373	3	_overweights
paperweights	23	6	141	3	paperweights
unweights	16	4	320	3	un___weights
counterweight	22	6	354	4	counterweight_
deadweights	20	5	163	4	__deadweights
hundredweight	25	9	78	4	hundredweight_
makeweights	24	5	158	4	make_weights
overweighs	20	4	409	4	_overweigh_s
overweight	20	4	537	4	_overweight_
paperweight	22	6	214	4	paperweight_
underbought	18	5	229	4	underbought_
undereats	10	3	1022	4	under_e__ats
underheats	14	4	605	4	underhe__ats
underlets	10	15	889	4	underle___ts
underreacts	14	5	302	4	underre_acts
underreports	15	7	177	4	underreports
undersets	10	12	932	4	underse___ts
undershirts	15	5	412	4	undershi_rts
undersigns	12	6	583	4	under_sig_ns
underskirts	16	5	320	4	underski_rts
undertenants	13	6	294	4	undertenants
undertints	11	4	828	4	under_ti_nts
undervests	14	6	474	4	underve__sts
underwent	13	4	905	4	underwe__nt_
underwings	15	14	640	4	underw_i_ngs
underwires	14	4	702	4	underw_i_res
underwrite	14	4	631	4	underwri__te
underwriters	16	5	280	4	underwriters
underwrites	15	4	518	4	underwri_tes
unweight	15	4	474	4	un___weight_
welterweights	23	7	111	4	welterweights

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	124790	0.453	394461.4
2	DLD Change Limit	124790	35	6.626	18833.4
3	Display Results	35	35	0.013	2692.3
	(SQL Overall)	178691	35	7.092	25196.1