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

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

24 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
panoches	15	4	812	(None)
panaches	15	3	1029	1	panaches
panochas	15	4	565	1	panochas
panoche	14	5	638	1	panoche_
penoches	15	3	893	1	penoches
caroches	15	7	1069	2	caroches
ganaches	14	3	743	2	ganaches
manches	14	38	1862	2	man_ches
painches	15	8	892	2	painches
panache	14	5	843	2	panache_
panicles	12	10	1012	2	panicles
panocha	14	4	498	2	panoch_a
parches	14	37	2000	2	pa_rches
patches	14	33	2038	2	pa_tches
paunches	15	6	817	2	paunches
penoche	14	4	704	2	penoche_
penuches	15	3	694	2	penuches
pinches	14	41	1793	2	pin_ches
pinochles	16	4	486	2	pinochles
pinocles	12	4	869	2	pinocles
planches	15	31	1186	2	plan_ches
pooches	14	32	1416	2	p_ooches
punches	14	48	1613	2	pun_ches
ranches	12	36	2011	2	ran_ches

Search took 5 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	24	4.360	27765.8
3	Display Results	24	24	0.000
	(SQL Overall)	178691	24	4.766	37492.9