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

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

77 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
notches	12	35	1365	(None)
botches	14	37	1602	1	botches
hotches	15	38	1436	1	hotches
notched	13	42	1030	1	notched
notcher	12	36	1093	1	notcher
notchers	13	27	942	1	notchers
rotches	12	35	1570	1	rotches
aitches	12	30	1436	2	aitches
batches	14	40	1961	2	batches
bitches	14	41	1706	2	bitches
blotches	15	3	743	2	blotches
boches	13	46	1852	2	bo_ches
botched	15	36	1190	2	botched
botcher	14	36	1322	2	botcher
botchers	15	35	1154	2	botchers
butches	14	43	1536	2	butches
catches	14	43	2077	2	catches
coaches	14	40	1869	2	coaches
conches	14	40	1981	2	conches
cooches	14	35	1583	2	cooches
couches	14	40	2047	2	couches
crotches	15	34	1130	2	crotches
cutches	14	32	1646	2	cutches
ditches	13	32	1571	2	ditches
douches	13	43	1523	2	douches
etches	11	42	1776	2	_etches
fetches	15	34	1389	2	fetches
fitches	15	35	1619	2	fitches
gotchas	13	3	461	2	gotchas
hatches	15	34	2027	2	hatches
hitches	15	36	1627	2	hitches
hooches	15	38	1252	2	hooches
hootches	16	5	697	2	hootches
hotched	16	36	1092	2	hotched
hutches	15	36	1352	2	hutches
itches	11	49	1621	2	_itches
ketches	16	40	1219	2	ketches
latches	12	33	2013	2	latches
letches	12	40	1548	2	letches
loaches	12	36	1398	2	loaches
matches	14	32	1978	2	matches
mooches	14	37	1445	2	mooches
mouches	14	38	1596	2	mouches
mutches	14	33	1428	2	mutches
naches	11	46	2241	2	n_aches
nautches	13	3	608	2	nautches
niches	11	44	1914	2	n_iches
nitchies	13	3	907	2	nitchies
nonces	8	44	1883	2	nonc_es
noshes	9	66	1823	2	no_shes
notates	7	28	1748	2	notates
notch	10	56	1332	2	notch__
notes	5	50	3458	2	not__es
nother	9	38	1596	2	not_her
notices	9	3	1228	2	notices
ouches	11	43	2218	2	_ouches
patches	14	33	2038	2	patches
pitches	14	36	1775	2	pitches
poaches	14	44	1694	2	poaches
pooches	14	32	1416	2	pooches
porches	14	38	1567	2	porches
potiches	15	3	920	2	potiches
pouches	14	41	1674	2	pouches
ratches	12	36	2046	2	ratches
retches	12	33	1851	2	retches
roaches	12	36	1621	2	roaches
rotche	11	43	1198	2	rotche_
rouches	12	42	1789	2	rouches
scotches	15	17	947	2	scotches
snatches	13	14	1071	2	snatches
snitches	13	14	898	2	snitches
torches	12	37	1544	2	torches
touches	12	51	1834	2	touches
vetches	15	34	1126	2	vetches
vouches	15	39	1411	2	vouches
watches	15	30	1737	2	watches
witches	15	27	1579	2	witches

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.373	479064.3
2	DLD Change Limit	107671	77	3.533	30475.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.936	45399.1