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

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

63 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
prowled	13	30	991	(None)
growled	12	27	817	1	growled
prowler	12	33	1001	1	prowler
bowled	12	50	1814	2	_bowled
brawled	13	39	1012	2	brawled
broiled	10	38	1142	2	broiled
browed	12	52	1639	2	brow_ed
browned	13	47	1097	2	browned
browsed	13	45	1123	2	browsed
cowled	12	52	1839	2	_cowled
crawled	13	37	1040	2	crawled
crowded	14	41	879	2	crowded
crowed	12	47	1730	2	crow_ed
crowned	13	39	1243	2	crowned
drawled	12	36	834	2	drawled
drolled	9	38	1022	2	drolled
drooled	9	36	920	2	drooled
drowned	12	41	990	2	drowned
drowsed	12	44	874	2	drowsed
fowled	13	39	1410	2	_fowled
frowned	14	34	883	2	frowned
growler	11	31	897	2	growler
howled	13	40	1497	2	_howled
jowled	17	42	1080	2	_jowled
paroled	10	42	1763	2	paro_led
peopled	12	3	850	2	peopled
plowed	12	42	1320	2	plow_ed
poled	8	49	3484	2	p_o_led
polled	9	40	2200	2	p_olled
pooled	9	46	1981	2	p_ooled
prawned	13	4	674	2	prawned
preowned	14	3	521	2	preowned
prilled	10	47	1300	2	prilled
probed	11	41	1482	2	pro_bed
problem	13	3	598	2	problem
proceed	12	3	1055	2	proceed
prodded	12	5	773	2	prodded
profiled	14	33	852	2	profiled
progged	12	40	980	2	progged
prole	7	45	2779	2	pro_le_
proleg	9	46	1211	2	pro_leg
proles	8	46	2720	2	pro_les
promoed	12	3	1008	2	promoed
pronged	11	39	1239	2	pronged
proofed	13	13	872	2	proofed
propped	11	33	1195	2	propped
prosed	9	49	2109	2	pro_sed
proved	12	50	1603	2	pro_ved
prower	11	42	1812	2	prow_er
prowl	10	56	1512	2	prowl__
prowlers	13	32	893	2	prowlers
prowls	11	55	1108	2	prowl_s
roiled	7	43	2005	2	_roiled
rolled	7	42	2024	2	_rolled
rowed	9	40	3432	2	_row_ed
roweled	11	26	986	2	_roweled
scowled	13	39	819	2	scowled
sprawled	14	3	452	2	sprawled
trawled	11	34	1152	2	trawled
trolled	8	43	1226	2	trolled
trowed	10	47	1465	2	trow_ed
troweled	12	10	611	2	troweled
yowled	13	38	1109	2	_yowled

Search took 5 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	63	3.686	29210.8
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	4.075	43850.6