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

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

69 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
curches	14	35	1274	(None)
churches	18	4	643	1	churches
culches	14	37	1074	1	culches
cutches	14	32	1646	1	cutches
lurches	12	33	1166	1	lurches
arches	11	48	2204	2	_arches
birches	14	34	1232	2	birches
bunches	14	41	1603	2	bunches
butches	14	43	1536	2	butches
caches	13	79	2691	2	c_aches
caroches	15	7	1069	2	caroches
catches	14	43	2077	2	catches
churched	19	3	465	2	churched
cinches	14	42	1577	2	cinches
circles	11	3	990	2	circles
cliches	14	42	1374	2	cliches
cloches	14	41	1371	2	cloches
clutches	15	30	792	2	clutches
coaches	14	40	1869	2	coaches
conches	14	40	1981	2	conches
cooches	14	35	1583	2	cooches
couches	14	40	2047	2	couches
creches	14	3	1309	2	creches
cruces	10	51	1754	2	cruc_es
crunches	15	37	1135	2	crunches
crushes	12	42	1513	2	crushes
crutches	15	35	959	2	crutches
cuishes	12	28	1082	2	cuishes
cultches	15	31	653	2	cultches
curacies	12	3	1176	2	curacies
curares	9	49	1685	2	curares
curates	9	53	2383	2	curates
curch	12	44	1541	2	curch__
curdles	10	38	1457	2	curdles
cures	7	56	4543	2	cur__es
curies	8	49	3402	2	cur_ies
curites	9	39	1986	2	curites
curries	9	37	2316	2	curries
curses	8	53	2827	2	cur_ses
curves	11	46	1928	2	cur_ves
dunches	13	33	1258	2	dunches
gulches	13	39	810	2	gulches
gurshes	11	22	1003	2	gurshes
hunches	15	39	1346	2	hunches
hutches	15	36	1352	2	hutches
larches	12	44	1644	2	larches
lunches	12	41	1544	2	lunches
lurched	13	35	803	2	lurched
lurcher	12	33	813	2	lurcher
lurchers	13	30	715	2	lurchers
marches	14	39	2117	2	marches
merches	14	40	1376	2	merches
muches	13	47	1899	2	mu_ches
mulches	14	32	1067	2	mulches
munches	14	42	1579	2	munches
mutches	14	33	1428	2	mutches
ouches	11	43	2218	2	ou_ches
parches	14	37	2000	2	parches
perches	14	37	1795	2	perches
porches	14	38	1567	2	porches
punches	14	48	1613	2	punches
quiches	21	3	933	2	quiches
qurshes	19	22	857	2	qurshes
ruches	11	48	1958	2	ru_ches
scorches	15	18	914	2	scorches
sculches	15	17	627	2	sculches
scutches	15	16	888	2	scutches
torches	12	37	1543	2	torches
tusches	12	3	790	2	tusches

Search took 9 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.140	1276364.3
2	DLD Change Limit	107671	69	7.860	13698.6
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	8.030	22252.9