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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

114 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
copied	11	46	1856	(None)
coped	10	50	3684	1	cop_ed
copier	10	37	2289	1	copier
copies	10	41	3030	1	copies
copped	13	52	2125	1	copped
cosied	9	48	1988	1	cosied
cozied	18	41	1215	1	cozied
bodied	10	38	1458	2	bodied
bopped	13	44	1340	2	bopped
canopied	13	3	634	2	canopied
caped	10	49	3180	2	cap_ed
capped	13	47	2185	2	capped
caried	9	45	2869	2	caried
chopped	17	45	1100	2	chopped
citied	9	40	1414	2	citied
clopped	14	36	1152	2	clopped
coaled	9	50	2271	2	coaled
coapted	12	39	1150	2	coapted
coated	9	49	2704	2	coated
coaxed	16	56	1251	2	coaxed
cocked	15	50	2256	2	cocked
codded	11	45	1530	2	codded
coded	9	54	3318	2	co_ded
coed	7	71	4054	2	co__ed
cogged	11	64	1661	2	cogged
coifed	12	41	1306	2	coifed
coiled	9	51	2394	2	coiled
coined	9	45	2360	2	coined
coked	12	47	3069	2	co_ked
coled	8	55	4076	2	co_led
colies	8	48	3705	2	colies
collied	10	33	1667	2	collied
combed	13	55	1654	2	combed
comped	13	59	1987	2	comped
compiled	15	3	781	2	compiled
complied	15	3	967	2	complied
compted	14	38	1352	2	compted
coned	8	60	4005	2	co_ned
conies	8	43	3859	2	conies
conked	13	50	1911	2	conked
conned	9	51	1970	2	conned
cooed	8	45	3434	2	co_oed
cooeed	9	59	1786	2	cooeed
cooked	13	59	2136	2	cooked
cooled	9	52	2459	2	cooled
cooped	11	48	2160	2	cooped
coopted	12	37	1076	2	coopted
cope	8	68	4738	2	cop_e_
copen	9	48	2643	2	cop_en
coper	9	53	3609	2	cop_er
copes	9	77	4710	2	cop_es
copiers	11	42	1596	2	copiers
coping	11	39	2766	2	coping
copper	12	43	2189	2	copper
coppiced	17	3	482	2	coppiced
copse	9	56	2392	2	copse_
copses	10	49	2247	2	copses
copter	10	98	2201	2	copter
corded	10	59	2335	2	corded
cored	8	50	4422	2	co_red
corked	13	50	2078	2	corked
corned	9	52	2452	2	corned
coshed	12	42	1754	2	coshed
cosie	7	47	2826	2	cosie_
cosier	8	44	2375	2	cosier
cosies	8	49	3215	2	cosies
costed	9	56	2311	2	costed
coted	8	50	3385	2	co_ted
couped	11	50	1931	2	couped
coupled	12	43	1267	2	coupled
coved	11	50	2737	2	co_ved
cowed	11	56	3785	2	co_wed
cowier	11	36	1616	2	cowier
cowled	12	52	1839	2	cowled
cowpie	13	35	1151	2	cowpie_
cowpies	14	33	1428	2	cowpies
coxed	15	43	2281	2	co_xed
coyed	11	46	2380	2	co_yed
cozie	16	35	1913	2	cozie_
cozier	17	33	1514	2	cozier
cozies	17	45	2141	2	cozies
cried	8	46	2428	2	c_ried
cropped	14	38	1206	2	cropped
cupid	10	32	1278	2	cupi_d
cupped	13	44	1398	2	cupped
doped	9	53	2671	2	dop_ed
dopier	9	35	1592	2	dopier
espied	9	35	977	2	espied
fopped	14	40	1267	2	fopped
honied	10	48	1839	2	honied
hoped	11	56	2818	2	hop_ed
hopped	14	43	1811	2	hopped
loped	8	51	2833	2	lop_ed
lopped	11	42	1862	2	lopped
monied	9	43	1946	2	monied
moped	10	54	2473	2	mop_ed
mopier	10	39	1478	2	mopier
mopped	13	41	1432	2	mopped
oped	7	62	3015	2	_op_ed
opined	9	51	1385	2	_opined
opted	8	49	1427	2	_opted
pied	7	50	3536	2	__pied
ponied	9	49	2070	2	ponied
popped	10	41	1781	2	popped
poppied	11	38	898	2	poppied
recopied	13	3	984	2	recopied
roped	8	46	3080	2	rop_ed
ropier	8	41	1880	2	ropier
scoped	11	51	1665	2	scop_ed
sopited	10	42	1106	2	sopited
sopped	11	48	1990	2	sopped
spied	8	54	2771	2	_spied
toped	8	56	3131	2	top_ed
topped	11	46	1772	2	topped

Search took 3 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	114	2.436	33887.9
3	Display Results	114	114	0.033	3454.5
	(SQL Overall)	178691	114	2.812	63545.9