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

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

74 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
arched	12	57	1732	(None)
ached	11	92	2783	1	a_ched
arced	8	82	2416	1	arc_ed
archer	11	50	1624	1	archer
arches	11	48	2204	1	arches
arcked	13	62	1194	1	arcked
marched	15	38	1340	1	marched
parched	15	40	1369	1	parched
aahed	9	178	1644	2	a_ahed
aced	7	95	4088	2	a_c_ed
ache	9	68	2982	2	a_che_
aches	10	61	3229	2	a_ches
acned	8	75	2067	2	a_cned
acred	8	71	2635	2	a_cred
acted	8	85	2173	2	a_cted
ahed	8	95	3625	2	a__hed
airshed	11	25	853	2	airshed
airthed	11	32	830	2	airthed
arcade	9	10	1364	2	arcade
arcaded	11	7	897	2	arcaded
arch	9	86	2844	2	arch__
archaea	12	13	761	2	archaea
archean	12	6	912	2	archean
archers	12	44	1457	2	archers
archery	15	47	806	2	archery
archil	11	6	1157	2	archil
archived	17	35	599	2	archived
archly	14	3	735	2	archly
archon	11	3	1175	2	archon
argled	8	53	1455	2	argled
argued	8	43	1117	2	argued
ariled	7	56	2032	2	ariled
armed	8	63	2443	2	ar_med
ashed	9	78	2977	2	a_shed
bached	14	55	1989	2	bached
batched	15	41	1424	2	batched
birched	15	34	991	2	birched
cached	14	54	1920	2	cached
earthed	11	3	992	2	earthed
eched	11	69	1922	2	_eched
etched	12	36	1370	2	etched
farced	12	52	1653	2	farc_ed
hatched	16	34	1446	2	hatched
inarched	14	8	611	2	inarched
inched	12	45	1448	2	inched
itched	12	38	1202	2	itched
larchen	12	47	962	2	larchen
larches	12	44	1644	2	larches
latched	13	39	1406	2	latched
leched	12	37	1600	2	leched
lurched	13	35	803	2	lurched
marchen	14	33	1207	2	marchen
marcher	14	39	1297	2	marcher
marches	14	39	2117	2	marches
matched	15	35	1396	2	matched
miched	14	39	1339	2	miched
niched	12	55	1406	2	niched
orchid	12	8	957	2	orchid
ouched	12	43	1693	2	ouched
parches	14	37	2000	2	parches
patched	15	35	1462	2	patched
peched	14	49	1534	2	peched
perched	15	47	1324	2	perched
raced	8	76	3531	2	rac_ed
rachet	11	50	2897	2	rachet
racked	13	45	2608	2	racked
ranched	13	31	1360	2	ranched
ruched	12	43	1463	2	ruched
searched	14	20	925	2	searched
starched	14	19	931	2	starched
teched	12	40	1443	2	teched
torched	13	35	1135	2	torched
unarched	14	12	855	2	unarched
watched	16	30	1282	2	watched

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	82551	0.343	520965.0
2	DLD Change Limit	82551	74	2.686	30733.8
3	Display Results	74	74	0.016	4625.0
	(SQL Overall)	178691	74	3.045	58683.4