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

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

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.

39 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
wretches	16	25	728	(None)
retches	12	33	1851	1	_retches
wrenches	16	32	1023	1	wrenches
wretched	17	27	653	1	wretched
breaches	15	37	1412	2	breaches
breeches	15	25	867	2	breeches
britches	15	27	868	2	britches
cratches	15	30	1254	2	cratches
creches	14	3	1309	2	cre_ches
crotches	15	34	1130	2	crotches
crutches	15	35	959	2	crutches
drenches	14	30	980	2	drenches
etches	11	42	1776	2	__etches
fetches	15	34	1389	2	_fetches
fletches	16	30	885	2	fletches
frenches	16	33	1163	2	frenches
grutches	14	28	585	2	grutches
ketches	16	40	1219	2	_ketches
kvetches	20	5	358	2	kvetches
letches	12	40	1548	2	_letches
preaches	15	32	1489	2	preaches
ratches	12	36	2046	2	_ratches
reaches	12	34	2320	2	_reaches
retched	13	38	1427	2	_retched
rotches	12	35	1570	2	_rotches
sketches	17	4	682	2	sketches
stretches	14	3	829	2	stretches
trenches	13	35	1260	2	trenches
vetches	15	34	1126	2	_vetches
watches	15	30	1737	2	w_atches
welches	15	37	1031	2	w_elches
wenches	15	29	1413	2	w_enches
witches	15	27	1579	2	w_itches
wreathes	14	29	989	2	wreathes
wrenched	17	74	813	2	wrenched
wrencher	16	28	778	2	wrencher
wrenchers	17	25	633	2	wrenchers
wretch	14	32	653	2	wretch__
writhes	13	48	1170	2	writ_hes

Search took 4 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	121059	0.406	440125.6
2	DLD Change Limit	121059	39	3.203	37795.5
3	Display Results	39	39	0.016	2437.5
	(SQL Overall)	178691	39	3.625	49294.1