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

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

53 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
drowner	11	36	980	(None)
browner	12	49	1164	1	browner
crowner	12	40	1259	1	crowner
downer	10	44	1492	1	d_owner
droner	7	47	1767	1	dro_ner
drowned	12	41	990	1	drowned
drowners	12	42	827	1	drowners
frowner	13	42	968	1	frowner
browned	13	47	1097	2	browned
brownier	13	22	691	2	brownier
browser	12	49	1114	2	browser
crooner	9	37	1404	2	crooner
crowder	13	38	984	2	crowder
crower	11	41	1755	2	crow_er
crowned	13	39	1242	2	crowned
crowners	13	37	1074	2	crowners
crownet	12	37	1411	2	crownet
dower	9	50	2770	2	d_ow_er
downed	11	53	1478	2	d_owned
downers	11	39	1277	2	d_owners
downier	11	29	970	2	d_ownier
dowser	10	47	1608	2	d_owser
drainer	8	30	1284	2	drainer
drawer	10	47	1136	2	draw_er
drawler	11	33	859	2	drawler
droller	8	41	1028	2	droller
drone	6	53	2498	2	dro_ne_
droned	8	46	1686	2	dro_ned
droners	8	41	1438	2	dro_ners
drones	7	50	2343	2	dro_nes
dropper	12	32	987	2	dropper
drover	10	46	1459	2	dro_ver
drown	9	55	1582	2	drown__
drownd	11	47	831	2	drown_d
drownded	14	33	443	2	drownded
drownds	12	34	615	2	drownds
drowns	10	56	1233	2	drown_s
drowse	10	50	1055	2	drowse_
drowsed	12	44	874	2	drowsed
drowses	11	46	1023	2	drowses
drowsier	12	8	490	2	drowsier
frowned	14	34	883	2	frowned
frowners	14	37	793	2	frowners
groaner	8	25	1013	2	groaner
grower	10	46	1493	2	grow_er
growler	11	31	897	2	growler
ironer	6	42	1645	2	iro_ner
kroner	10	46	1257	2	kro_ner
owner	8	46	1331	2	__owner
prawner	12	4	680	2	prawner
prower	11	42	1812	2	prow_er
prowler	12	33	1001	2	prowler
rower	8	54	3049	2	_row_er

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.140	1276364.3
2	DLD Change Limit	107671	53	3.296	32667.2
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	3.466	51555.4