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

Here are the results of your fuzzy-string dictionary search for “copepod” with Change Limit: [1] [2] [3] [4]

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.

98 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
copepod	14	4	485	(None)
copepods	15	4	471	1	copepods
coped	10	50	3684	2	cope__d
copped	13	52	2125	2	cop_ped
bopped	13	44	1340	3	bop_ped
caped	10	49	3180	3	cape__d
capered	12	30	1404	3	capered
capped	13	47	2185	3	cap_ped
cheeped	15	34	1059	3	cheeped
chopped	17	45	1100	3	chop_ped
cleped	11	51	1411	3	c_leped
clopped	14	36	1152	3	clop_ped
coded	9	54	3318	3	code__d
coed	7	71	4054	3	co_e__d
coelom	10	3	1042	3	co_elom
cohead	12	38	1112	3	cohe_ad
cohered	13	35	1469	3	cohered
coked	12	47	3069	3	coke__d
colead	9	41	1464	3	cole_ad
coled	8	55	4075	3	cole__d
comedo	11	35	960	3	comedo_
comedos	12	32	907	3	comedos
comped	13	59	1987	3	co_mped
compend	14	40	1030	3	compe_nd
compered	15	34	1492	3	compered
competed	15	41	1359	3	competed
compo	11	53	1857	3	co_mpo_
compos	12	48	1880	3	co_mpos
coned	8	60	4005	3	cone__d
cooed	8	45	3434	3	cooe__d
cooeed	9	59	1786	3	cooe_ed
cooeyed	13	4	689	3	cooeyed
cooped	11	48	2160	3	co_oped
coopered	13	33	1093	3	coopered
cope	8	68	4738	3	cope___
copeck	16	3	694	3	cope_ck
copecks	17	4	587	3	copecks
copen	9	48	2643	3	cope__n
copens	10	61	1996	3	cope_ns
coper	9	53	3609	3	cope__r
copers	10	46	2984	3	cope_rs
copes	9	77	4710	3	cope__s
copied	11	46	1856	3	cop_ied
copilot	11	8	1126	3	copilot
coplot	10	5	1827	3	cop_lot
copper	12	43	2189	3	cop_per
coppered	15	34	1054	3	coppered
coppers	13	35	1975	3	coppers
coppery	16	40	939	3	coppery
coppra	12	30	683	3	cop_pra
copyboy	19	6	351	3	copyboy
copyhold	19	5	329	3	copyhold
cored	8	50	4422	3	core__d
coted	8	50	3385	3	cote__d
couped	11	50	1931	3	co_uped
coupon	10	28	1099	3	co_upon
coved	11	50	2737	3	cove__d
covered	13	33	1529	3	covered
coveted	13	30	1152	3	coveted
cowed	11	56	3784	3	cowe__d
cowered	13	32	1464	3	cowered
cowpox	20	3	500	3	co_wpox
coxed	15	43	2281	3	coxe__d
coyed	11	46	2380	3	coye__d
coypou	13	26	840	3	co_ypou
cozened	19	34	918	3	cozened
creeped	12	32	971	3	creeped
creped	11	41	1570	3	c_reped
crepon	10	3	993	3	c_repon
cropped	14	38	1206	3	crop_ped
cupeled	12	5	779	3	cupeled
cupped	13	44	1398	3	cup_ped
doped	9	53	2671	3	dope__d
fopped	14	40	1267	3	fop_ped
hoped	11	56	2818	3	hope__d
hopped	14	43	1811	3	hop_ped
loped	8	51	2833	3	lope__d
lopped	11	42	1862	3	lop_ped
monopod	12	4	749	3	monopod
moped	10	54	2473	3	mope__d
mopped	13	41	1432	3	mop_ped
notepad	10	4	412	3	notepad
octopod	12	4	489	3	octopod
oped	7	62	3015	3	_ope__d
opened	9	43	1186	3	_opened
operon	8	8	1177	3	_operon
pepo	8	76	2215	3	__pepo_
pepos	9	66	2008	3	__pepos
polypod	15	4	698	3	polypod
popedom	14	4	545	3	popedom
popeyed	15	3	570	3	popeyed
popped	10	41	1781	3	pop_ped
roped	8	46	3080	3	rope__d
scoped	11	51	1665	3	scope__d
scorepad	13	6	338	3	scorepad
sopped	11	48	1990	3	sop_ped
toped	8	56	3131	3	tope__d
topped	11	46	1772	3	top_ped

Search took 7 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	98	6.753	19847.0
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	6.939	25751.7