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

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

62 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
crowned	13	39	1244	(None)
browned	13	47	1097	1	browned
clowned	13	44	773	1	clowned
crooned	10	38	1335	1	crooned
crowded	14	41	880	1	crowded
crowed	12	47	1731	1	crow_ed
crowner	12	40	1260	1	crowner
crownet	12	37	1411	1	crownet
drowned	12	41	990	1	drowned
frowned	14	34	883	1	frowned
browed	12	52	1640	2	brow_ed
browner	12	49	1164	2	browner
browsed	13	45	1124	2	browsed
chowed	15	49	1465	2	chow_ed
chowsed	16	47	862	2	chowsed
cloned	9	45	1880	2	clo_ned
coined	9	45	2360	2	c_oined
coned	8	60	4005	2	c_o_ned
conned	9	51	1970	2	c_onned
corned	9	52	2452	2	c_orned
cowed	11	56	3785	2	c_ow_ed
cowled	12	52	1839	2	c_owled
craned	9	61	2165	2	cr_aned
crawled	13	37	1040	2	crawled
crewed	12	53	1656	2	crew_ed
croaked	14	37	1054	2	croaked
crocked	16	40	1444	2	crocked
crone	7	52	3133	2	cro_ne_
crones	8	47	2924	2	cro_nes
crooked	14	39	1095	2	crooked
crooner	9	37	1404	2	crooner
cropped	14	38	1207	2	cropped
crossed	10	53	1390	2	crossed
crowd	11	58	1562	2	crow__d
crowder	13	38	986	2	crowder
crower	11	41	1756	2	crow_er
crown	10	56	2008	2	crown__
crowners	13	37	1075	2	crowners
crownets	13	40	767	2	crownets
crowns	11	56	1511	2	crown_s
decrowned	16	6	366	2	decrowned
downed	11	53	1478	2	_downed
droned	8	46	1686	2	dro_ned
drownd	11	47	831	2	drown_d
drownded	14	33	443	2	drownded
drowner	11	36	980	2	drowner
drowsed	12	44	875	2	drowsed
frowner	13	42	968	2	frowner
gowned	11	44	1013	2	_gowned
groaned	9	25	997	2	groaned
groined	9	27	1081	2	groined
growled	12	27	817	2	growled
ironed	7	49	1601	2	iro_ned
owned	9	51	1323	2	__owned
prawned	13	4	674	2	prawned
preowned	14	3	521	2	preowned
prowled	13	30	991	2	prowled
recrowned	15	6	486	2	recrowned
rowed	9	40	3432	2	_row_ed
trowed	10	47	1465	2	trow_ed
uncrowned	15	6	475	2	uncrowned
unowned	11	4	881	2	unowned

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	62	3.236	33272.9
3	Display Results	62	62	0.013	4769.2
	(SQL Overall)	178691	62	3.622	49334.9