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

Here are the results of your fuzzy-string dictionary search for “drown” 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
drown	9	55	1582	(None)
brown	10	56	1953	1	brown
crown	10	56	2008	1	crown
down	8	64	2749	1	d_own
drawn	9	56	1424	1	drawn
drownd	11	47	831	1	drownd
drowns	10	56	1233	1	drowns
frown	11	54	1597	1	frown
grown	9	53	1735	1	grown
adown	9	56	1166	2	adown
blown	10	57	1667	2	blown
brawn	10	60	1856	2	brawn
brow	9	72	2844	2	brow_
browns	11	64	1563	2	browns
browny	14	45	1004	2	browny
brows	10	54	2598	2	brows
clown	10	52	1473	2	clown
croon	7	55	2278	2	croon
crow	9	64	2813	2	crow_
crowd	11	58	1562	2	crowd
crowns	11	56	1511	2	crowns
crows	10	57	2731	2	crows
dawn	8	56	2420	2	d_awn
decrown	13	20	605	2	decrown
dhow	11	66	1400	2	dhow_
dhows	12	59	1122	2	dhows
disown	10	3	695	2	disown
don	4	67	5765	2	d_o_n
dow	7	67	4997	2	d_ow_
downs	9	49	1857	2	d_owns
downy	12	57	1455	2	d_owny
dows	8	59	4105	2	d_ows
drain	6	52	2289	2	drain
draw	8	56	2301	2	draw_
drawl	9	55	1601	2	drawl
draws	9	51	1937	2	draws
drew	8	62	2167	2	drew_
droid	7	42	1853	2	droid
droit	6	51	2712	2	droit
droll	6	54	1540	2	droll
dromon	9	3	936	2	dromon
drone	6	53	2498	2	drone
drool	6	54	1610	2	drool
droop	8	58	1482	2	droop
drop	7	53	2440	2	dro_p
drops	8	57	1950	2	drops
dropt	8	69	2443	2	dropt
dross	6	54	1809	2	dross
drouk	10	3	943	2	drouk
drove	9	55	1806	2	drove
drownds	12	34	615	2	drownds
drowned	12	41	990	2	drowned
drowner	11	36	980	2	drowner
drowse	10	50	1055	2	drowse
drowsy	13	48	790	2	drowsy
flown	11	62	1399	2	flown
frow	10	64	2505	2	frow_
frowns	12	60	1139	2	frowns
frows	11	66	2310	2	frows
gown	8	57	2407	2	_gown
groan	6	56	1842	2	groan
groin	6	55	2108	2	groin
grow	8	61	2730	2	grow_
growl	9	61	1582	2	growl
grows	9	55	2392	2	grows
iron	4	67	2846	2	iro_n
known	12	56	834	2	known
kroon	9	45	1448	2	kroon
lown	7	69	2929	2	_lown
mown	9	54	2444	2	_mown
own	6	64	2970	2	__own
prawn	10	53	1243	2	prawn
prow	9	70	3038	2	prow_
prowl	10	56	1512	2	prowl
prows	10	63	2701	2	prows
roan	4	72	3420	2	_roan
row	6	74	5367	2	_row_
rowan	8	54	1873	2	_rowan
rowen	8	49	2115	2	_rowen
rows	7	59	4175	2	_rows
shown	11	52	1647	2	shown
sown	7	51	2745	2	_sown
strown	9	68	1209	2	strown
thrown	12	149	1144	2	thrown
town	7	69	2870	2	_town
trow	7	80	3142	2	trow_
trows	8	88	2618	2	trows
vrow	10	58	1747	2	vrow_
vrows	11	61	1526	2	vrows

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	89	1.673	32157.8
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	1.796	99493.9