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

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

102 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
coifed	12	41	1306	(None)
coiffed	16	3	541	1	coiffed
coiled	9	51	2393	1	coiled
coined	9	45	2360	1	coined
boffed	15	36	948	2	boffed
boiled	9	50	2095	2	boiled
ceiled	9	41	1495	2	ceiled
chafed	15	48	1391	2	chafed
chefed	15	50	1056	2	chefed
chided	13	51	1396	2	chided
chimed	14	58	1483	2	chimed
chined	12	56	2006	2	chined
choired	13	34	934	2	choired
cited	8	44	2195	2	c_ited
coaled	9	50	2270	2	coaled
coated	9	49	2703	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
codified	15	3	740	2	codified
coed	7	71	4054	2	co__ed
coffee	14	41	1374	2	coffee
coffer	14	41	1286	2	coffer
coffled	16	29	736	2	coffled
cogged	11	64	1661	2	cogged
coif	9	63	3791	2	coif__
coiffe	14	4	704	2	coiffe
coiffes	15	4	680	2	coiffes
coifs	10	57	1870	2	coif_s
coigned	11	41	866	2	coigned
coiler	8	44	2159	2	coiler
coiner	8	43	2378	2	coiner
coinfer	12	41	939	2	coinfer
coked	12	47	3069	2	co_ked
coled	8	55	4075	2	co_led
combed	13	55	1654	2	combed
comped	13	59	1987	2	comped
coned	8	60	4005	2	co_ned
confer	11	40	1868	2	confer
conifer	12	32	1264	2	conifer
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	2458	2	cooled
cooped	11	48	2160	2	cooped
coped	10	50	3684	2	co_ped
copied	11	46	1856	2	copied
copped	13	52	2125	2	copped
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
cornfed	13	3	738	2	cornfed
coshed	12	42	1754	2	coshed
cosied	9	48	1988	2	cosied
costed	9	56	2311	2	costed
coted	8	50	3385	2	co_ted
couped	11	50	1931	2	couped
coved	11	50	2737	2	co_ved
cowed	11	56	3784	2	co_wed
cowled	12	52	1838	2	cowled
coxed	15	43	2281	2	co_xed
coyed	11	46	2380	2	co_yed
cozied	18	41	1215	2	cozied
cried	8	46	2428	2	cri_ed
cuffed	15	43	1121	2	cuffed
doffed	14	42	850	2	doffed
doiled	8	48	1729	2	doiled
doited	8	50	1663	2	doited
fifed	12	51	1597	2	_fifed
foiled	10	46	1840	2	foiled
foined	10	59	1501	2	foined
golfed	11	56	976	2	golfed
goofed	11	49	1138	2	goofed
hoised	10	51	1743	2	hoised
hoofed	13	46	1489	2	hoofed
joined	14	46	1307	2	joined
knifed	14	52	812	2	knifed
loafed	10	40	1115	2	loafed
loided	8	34	1402	2	loided
moiled	9	43	1886	2	moiled
noised	7	54	1623	2	noised
offed	12	35	916	2	_offed
oiled	6	44	2947	2	_oiled
poised	9	49	1847	2	poised
poufed	12	44	971	2	poufed
roiled	7	43	2005	2	roiled
rolfed	10	45	1052	2	rolfed
roofed	10	52	1474	2	roofed
scoffed	16	26	618	2	scoffed
soiled	7	38	2247	2	soiled
toiled	7	44	2032	2	toiled
toited	7	40	1675	2	toited
voiced	12	39	1011	2	voiced
voided	11	40	1113	2	voided
waifed	13	40	1103	2	waifed
wifed	12	51	1774	2	_wifed
wolfed	13	42	801	2	wolfed
woofed	13	45	1120	2	woofed

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.110	1624463.6
2	DLD Change Limit	82551	102	3.063	26951.0
3	Display Results	102	102	0.030	3400.0
	(SQL Overall)	178691	102	3.203	55788.6