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

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

56 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
coacher	14	37	1412	(None)
coached	15	33	1384	1	coached
coachers	15	43	1230	1	coachers
coaches	14	40	1869	1	coaches
coucher	14	45	1585	1	coucher
poacher	14	39	1232	1	poacher
botcher	14	36	1322	2	botcher
broacher	15	32	926	2	broacher
cache	12	51	2248	2	c_ache_
cached	14	54	1920	2	c_ached
caches	13	79	2691	2	c_aches
cachet	13	45	2641	2	c_achet
catcher	14	31	1582	2	catcher
clacker	15	38	1377	2	clacker
clasher	12	46	1551	2	clasher
coach	12	59	1945	2	coach__
coachmen	17	4	501	2	coachmen
coacted	12	36	1161	2	coacted
coactor	11	3	913	2	coactor
coaler	8	41	2171	2	coa_ler
coalier	9	34	1618	2	coalier
coanchor	15	4	525	2	coanchor
coarser	9	32	1120	2	coarser
coaster	9	42	1904	2	coaster
coater	8	43	2957	2	coa_ter
coaxer	15	39	1279	2	coa_xer
cocker	14	43	2039	2	co_cker
conches	14	40	1981	2	conches
cooches	14	35	1583	2	cooches
cosher	11	48	1990	2	co_sher
couched	15	41	1579	2	couched
couchers	15	35	1386	2	couchers
couches	14	40	2047	2	couches
cougher	13	37	1173	2	cougher
couther	12	39	1463	2	couther
cracker	15	31	1417	2	cracker
crasher	12	46	1616	2	crasher
leacher	12	40	1484	2	leacher
loaches	12	36	1398	2	loaches
loather	10	37	1100	2	loather
moocher	14	36	1067	2	moocher
notcher	12	36	1093	2	notcher
ocher	10	45	1610	2	_o_cher
peacher	14	42	1607	2	peacher
poached	15	42	1240	2	poached
poachers	15	29	1076	2	poachers
poaches	14	44	1694	2	poaches
poachier	15	5	682	2	poachier
reacher	12	37	1829	2	reacher
roached	13	32	1183	2	roached
roaches	12	36	1621	2	roaches
scorcher	15	19	679	2	scorcher
teacher	12	37	1483	2	teacher
tocher	11	40	1491	2	to_cher
toucher	12	48	1435	2	toucher
voucher	15	41	1026	2	voucher

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	107671	0.376	475242.0
2	DLD Change Limit	107671	56	3.436	31336.1
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	3.828	46680.0