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

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

60 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
prigging	13	29	909	(None)
frigging	14	26	895	1	frigging
pigging	12	36	1467	1	p_igging
progging	13	26	1038	1	progging
rigging	10	30	1633	1	_rigging
sprigging	14	3	589	1	sprigging
trigging	11	29	958	1	trigging
bigging	12	28	1588	2	_bigging
bragging	13	35	933	2	bragging
bridging	13	28	844	2	bridging
bringing	12	30	1127	2	bringing
cringing	12	33	1138	2	cringing
digging	11	35	1370	2	_digging
dragging	12	30	810	2	dragging
drugging	12	32	644	2	drugging
figging	13	33	1356	2	_figging
fragging	14	32	942	2	fragging
fringing	13	30	1090	2	fringing
frogging	14	35	873	2	frogging
frugging	14	31	705	2	frugging
gigging	9	33	1177	2	_gigging
igging	9	32	1207	2	__igging
jigging	17	30	1155	2	_jigging
pegging	12	28	1113	2	p_egging
piggin	10	31	1109	2	p_iggin_
piggins	11	30	1047	2	p_iggins
pinging	11	34	1955	2	p_inging
plugging	13	30	689	2	plugging
pranging	12	30	1272	2	pranging
pricing	12	34	1734	2	pri_cing
pricking	17	32	1260	2	pricking
priding	11	33	1754	2	pri_ding
priggish	15	4	468	2	priggish
priggism	14	4	438	2	priggism
prilling	11	34	1341	2	prilling
priming	12	34	1737	2	pri_ming
primming	15	26	817	2	primming
primping	15	33	889	2	primping
prinking	15	32	1245	2	prinking
printing	11	32	1608	2	printing
prising	10	33	2145	2	pri_sing
prissing	11	30	1145	2	prissing
prizing	19	35	1468	2	pri_zing
pronging	12	35	1184	2	pronging
pugging	12	29	1254	2	p_ugging
ragging	10	35	1668	2	_ragging
rerigging	12	3	655	2	rerigging
ridging	10	41	1298	2	_ridging
riggings	11	32	713	2	_riggings
ringing	9	35	2128	2	_ringing
rugging	10	25	1276	2	_rugging
springing	13	3	874	2	springing
swigging	14	33	722	2	swigging
triaging	10	26	1054	2	triaging
twigging	14	30	567	2	twigging
unrigging	12	4	518	2	unrigging
wigging	13	34	1383	2	_wigging
wriggling	15	3	381	2	wriggling
wringing	13	27	962	2	wringing
zigging	19	32	1053	2	_zigging

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	60	3.843	31501.2
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	4.266	41887.2