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

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

38 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
prawners	13	4	601	(None)
pawners	12	43	1107	1	p_awners
prawner	12	4	680	1	prawner_
branners	10	40	1092	2	branners
brawlers	13	40	864	2	brawlers
crawlers	13	30	901	2	crawlers
crowners	13	37	1075	2	crowners
drainers	9	28	1126	2	drainers
drawers	11	36	1007	2	draw_ers
drawlers	12	30	731	2	drawlers
drowners	12	42	827	2	drowners
fawners	13	38	849	2	_fawners
frowners	14	37	793	2	frowners
grainers	9	30	1208	2	grainers
panners	9	36	2127	2	p_anners
pardners	11	26	920	2	pardners
partners	10	27	1114	2	partners
pawers	11	48	1878	2	p_aw_ers
pawnees	12	29	817	2	p_awnees
pawner	11	42	1292	2	p_awner_
pawnors	12	29	720	2	p_awnors
planers	9	45	1795	2	pla_ners
planners	10	39	994	2	planners
praisers	10	34	1084	2	praisers
prancers	12	32	1034	2	prancers
praters	9	49	2165	2	pra_ters
prawned	13	4	674	2	prawne_d
prawns	11	50	902	2	prawn__s
prayers	12	42	1285	2	pra_yers
preeners	10	27	1281	2	preeners
prowlers	13	32	893	2	prowlers
pruners	9	37	1073	2	pr_uners
rawness	10	3	815	2	_rawness
spawners	13	39	649	2	spawners
sprawlers	14	3	390	2	sprawlers
trainers	8	31	1465	2	trainers
trawlers	11	33	1020	2	trawlers
yawners	13	36	718	2	_yawners

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	121059	0.390	458182.1
2	DLD Change Limit	121059	38	3.906	30993.1
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	4.312	41440.4