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

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

58 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
lurches	12	33	1166	(None)
curches	14	35	1274	1	curches
larches	12	44	1645	1	larches
lunches	12	41	1544	1	lunches
lurched	13	35	803	1	lurched
lurcher	12	33	813	1	lurcher
lurchers	13	30	715	1	lurchers
arches	11	48	2204	2	_arches
birches	14	34	1232	2	birches
bunches	14	41	1603	2	bunches
butches	14	43	1536	2	butches
churches	18	4	643	2	churches
clutches	15	30	792	2	clutches
culches	14	37	1074	2	culches
cutches	14	32	1646	2	cutches
dunches	13	33	1258	2	dunches
glunches	14	3	626	2	glunches
gulches	13	39	811	2	gulches
gurshes	11	22	1003	2	gurshes
hunches	15	39	1346	2	hunches
hutches	15	36	1352	2	hutches
laches	11	65	2835	2	l_aches
larchen	12	47	963	2	larchen
latches	12	33	2013	2	latches
launches	13	8	790	2	launches
leaches	12	33	1934	2	leaches
leches	11	54	2131	2	l_eches
leeches	12	39	1193	2	leeches
letches	12	40	1548	2	letches
liches	11	47	2429	2	l_iches
loaches	12	36	1398	2	loaches
luces	7	55	2843	2	lu_c_es
lucres	8	45	1330	2	lu_cres
lunched	13	39	1182	2	lunched
luncher	12	31	1141	2	luncher
lunchers	13	34	956	2	lunchers
lurch	10	48	1463	2	lurch__
lures	5	61	3853	2	lur__es
lurexes	14	3	607	2	lurexes
lushes	9	40	2274	2	lu_shes
lyches	14	42	1361	2	l_yches
lynches	15	37	887	2	lynches
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
torches	12	37	1544	2	torches
tusches	12	3	790	2	tusches

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	58	3.486	30886.7
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	3.889	45947.8