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

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

89 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
gowned	11	44	1013	(None)
downed	11	53	1478	1	downed
gowaned	12	3	576	1	gowaned
owned	9	51	1323	1	_owned
awned	9	66	1595	2	_awned
boned	8	51	3324	2	bo_ned
bowed	11	45	3342	2	bow_ed
bowled	12	50	1814	2	bowled
bowsed	12	57	1597	2	bowsed
browned	13	47	1097	2	browned
clowned	13	44	773	2	clowned
coined	9	45	2360	2	coined
coned	8	60	4005	2	co_ned
conned	9	51	1970	2	conned
corned	9	52	2452	2	corned
cowed	11	56	3785	2	cow_ed
cowled	12	52	1839	2	cowled
crowned	13	39	1243	2	crowned
dawned	11	39	1209	2	dawned
donned	8	50	1574	2	donned
dowed	10	46	3261	2	dow_ed
downer	10	44	1492	2	downer
dowsed	11	50	1501	2	dowsed
drowned	12	41	990	2	drowned
fawned	13	49	1042	2	fawned
foined	10	59	1501	2	foined
fowled	13	39	1410	2	fowled
frowned	14	34	883	2	frowned
gained	8	46	1746	2	gained
gawked	15	46	876	2	gawked
gawped	13	50	907	2	gawped
ginned	8	38	1398	2	ginned
girned	8	40	1051	2	girned
glowed	11	49	1383	2	glow_ed
goaded	9	49	1371	2	goaded
goaled	8	50	1436	2	goaled
gobbed	12	46	1388	2	gobbed
godded	10	48	1180	2	godded
golfed	11	56	976	2	golfed
gonad	7	52	1605	2	go_nad
gone	5	56	3904	2	go_ne_
gonef	9	52	2129	2	go_nef
goner	6	60	2516	2	go_ner
gonged	9	71	1591	2	gonged
goofed	11	49	1138	2	goofed
gooney	10	66	1231	2	gooney
goosed	8	68	1703	2	goosed
gored	7	52	2708	2	go_red
gorged	9	50	1698	2	gorged
gormed	10	50	1383	2	gormed
gouged	9	62	1459	2	gouged
gowd	9	65	1998	2	gow__d
gown	8	57	2407	2	gown__
gowns	9	51	1510	2	gown_s
groaned	9	25	997	2	groaned
groined	9	27	1081	2	groined
growled	12	27	817	2	growled
gunned	8	35	1309	2	gunned
honed	9	53	3226	2	ho_ned
horned	10	57	1870	2	horned
howked	17	73	1234	2	howked
howled	13	40	1497	2	howled
joined	14	46	1307	2	joined
jowed	16	47	2442	2	jow_ed
jowled	17	42	1080	2	jowled
loaned	7	38	1629	2	loaned
lowed	9	52	3390	2	low_ed
moaned	9	45	1417	2	moaned
mooned	9	42	1664	2	mooned
mowed	11	36	2901	2	mow_ed
owed	8	68	3387	2	_ow_ed
owner	8	46	1331	2	_owner
pawned	12	45	1328	2	pawned
rowed	9	40	3432	2	row_ed
sorned	7	48	2004	2	sorned
sowed	9	49	3386	2	sow_ed
toned	6	54	3534	2	to_ned
towed	9	51	3458	2	tow_ed
townee	9	28	1521	2	townee
ungowned	13	3	518	2	ungowned
unowned	11	4	881	2	unowned
vowed	12	44	2457	2	vow_ed
wonned	10	40	1206	2	wonned
wowed	12	40	2377	2	wow_ed
yawned	13	50	984	2	yawned
yowed	12	530	2518	2	yow_ed
yowled	13	38	1109	2	yowled
zoned	15	40	2026	2	zo_ned
zooned	16	40	1108	2	zooned

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	89	2.376	34743.7
3	Display Results	89	89	0.063	1412.7
	(SQL Overall)	178691	89	2.782	64231.1