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

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

78 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
prowls	11	55	1108	(None)
growls	10	47	1111	1	growls
prowl	10	56	1512	1	prowl_
prows	10	63	2701	1	prow_s
bowls	10	61	2143	2	_bowls
brawls	11	52	1433	2	brawls
broils	8	41	1417	2	broils
browns	11	64	1563	2	browns
brows	10	54	2598	2	brow_s
cowls	10	69	2221	2	_cowls
crawls	11	47	1208	2	crawls
crowds	12	49	1076	2	crowds
crowns	11	56	1511	2	crowns
crows	10	57	2731	2	crow_s
drawls	10	55	1139	2	drawls
drolls	7	53	1239	2	drolls
drools	7	44	1281	2	drools
drowns	10	56	1233	2	drowns
fowls	11	55	1889	2	_fowls
frowns	12	60	1139	2	frowns
frows	11	66	2310	2	frow_s
growl	9	61	1582	2	growl_
growly	13	49	917	2	growly
grows	9	55	2392	2	grow_s
howls	11	62	1922	2	_howls
jowls	15	62	1452	2	_jowls
owls	7	60	2293	2	__owls
parols	8	47	2261	2	paro_ls
pawls	10	56	1766	2	p_awls
plows	10	54	1990	2	plow_s
polls	7	46	2772	2	p_olls
pols	6	60	4456	2	p_o_ls
pools	7	44	2770	2	p_ools
pows	9	55	3766	2	p_ow_s
prawns	11	50	902	2	prawns
prills	8	40	1561	2	prills
proas	7	50	2880	2	pro_as
probes	10	41	1945	2	probes
prods	8	55	2355	2	pro_ds
proems	10	47	1116	2	proems
profs	10	51	2089	2	pro_fs
progs	8	66	2415	2	pro_gs
prole	7	45	2779	2	pro_le
proles	8	46	2720	2	proles
promos	10	51	1642	2	promos
proms	9	54	2641	2	pro_ms
prongs	9	43	1448	2	prongs
proofs	11	45	1168	2	proofs
propels	11	34	1284	2	propels
props	9	57	2688	2	pro_ps
propyls	14	30	819	2	propyls
pros	6	57	4278	2	pro__s
proses	8	47	3347	2	proses
prosos	8	57	1855	2	prosos
pross	7	65	2940	2	pro_ss
protyls	12	29	846	2	protyls
proves	11	43	2225	2	proves
prow	9	70	3038	2	prow__
prowar	11	41	1094	2	prowar
prower	11	42	1812	2	prower
prowess	12	3	790	2	prowess
prowest	12	3	1153	2	prowest
prowled	13	30	991	2	prowled
prowler	12	33	1001	2	prowler
prowlers	13	32	893	2	prowlers
roils	5	48	2679	2	_roils
rolls	5	53	2623	2	_rolls
rotls	5	56	2016	2	_rotls
rowels	9	45	1545	2	_rowels
rows	7	59	4175	2	_row_s
scowls	11	54	959	2	scowls
sprawls	12	17	637	2	sprawls
trawls	9	44	1239	2	trawls
trolls	6	46	1394	2	trolls
trowels	10	35	836	2	trowels
trows	8	88	2618	2	trow_s
vrows	11	61	1526	2	vrow_s
yowls	11	57	1543	2	_yowls

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.373	479064.3
2	DLD Change Limit	82551	78	2.673	30883.3
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.076	58092.0