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

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

47 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
prawned	13	4	674	(None)
pawned	12	45	1328	1	p_awned
prawner	12	4	680	1	prawner
awned	9	66	1595	2	__awned
brained	10	38	1610	2	brained
branned	10	43	1169	2	branned
brawled	13	39	1012	2	brawled
browned	13	47	1097	2	browned
craned	9	61	2165	2	cra_ned
crawled	13	37	1040	2	crawled
crowned	13	39	1243	2	crowned
dawned	11	39	1209	2	_dawned
drained	9	37	1325	2	drained
drawled	12	36	834	2	drawled
drowned	12	41	990	2	drowned
fawned	13	49	1042	2	_fawned
frowned	14	34	883	2	frowned
grained	9	38	1427	2	grained
pained	9	56	2285	2	p_ained
paned	8	54	3718	2	p_a_ned
panned	9	41	2343	2	p_anned
pawed	11	57	2561	2	p_aw_ed
pawnee	11	31	1540	2	p_awnee
pawner	11	42	1292	2	p_awner
plained	10	38	1223	2	plained
planed	9	44	2091	2	pla_ned
planned	10	38	1015	2	planned
praised	10	42	1481	2	praised
pranced	12	37	1404	2	pranced
pranged	11	45	1255	2	pranged
pranked	14	37	1209	2	pranked
prated	9	49	2492	2	pra_ted
prawn	10	53	1243	2	prawn__
prawners	13	4	600	2	prawners
prawns	11	50	902	2	prawn_s
prayed	12	48	1543	2	pra_yed
preened	10	32	1499	2	preened
preowned	14	3	521	2	preowned
prowled	13	30	991	2	prowled
pruned	9	34	1311	2	pr_uned
rained	7	50	2460	2	_rained
spawned	13	31	680	2	spawned
sprained	11	3	843	2	sprained
sprawled	14	3	452	2	sprawled
trained	8	41	1720	2	trained
trawled	11	34	1152	2	trawled
yawned	13	50	984	2	_yawned

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.376	475242.0
2	DLD Change Limit	107671	47	3.263	32997.5
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	3.655	48889.5