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

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

67 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
pricking	17	32	1260	(None)
bricking	17	39	1140	1	bricking
cricking	17	34	1265	1	cricking
picking	16	34	1833	1	p_icking
pricing	12	34	1734	1	pric_ing
prickings	18	31	565	1	prickings
prickling	18	3	653	1	prickling
prinking	15	32	1245	1	prinking
ricking	14	39	2023	1	_ricking
tricking	15	27	1451	1	tricking
wricking	18	34	949	1	wricking
arcking	14	58	1196	2	ar_cking
brisking	15	32	947	2	brisking
clicking	17	36	1098	2	clicking
cracking	17	40	1390	2	cracking
crocking	17	43	1344	2	crocking
dicking	15	36	1761	2	_dicking
drinking	14	30	891	2	drinking
flicking	18	41	1004	2	flicking
frisking	16	26	836	2	frisking
frocking	18	30	957	2	frocking
hoicking	18	3	605	2	hoicking
kicking	13	33	1402	2	_kicking
licking	14	41	1828	2	_licking
nicking	14	35	1632	2	_nicking
packing	16	44	2072	2	p_acking
paiking	14	38	1481	2	pai_king
panicking	18	3	529	2	panicking
pecking	16	40	1778	2	p_ecking
pickings	17	35	938	2	p_ickings
pickling	17	23	920	2	p_ickling
piking	13	37	1964	2	p_i_king
pinking	14	39	1894	2	p_inking
plinking	15	36	1124	2	plinking
plucking	17	35	772	2	plucking
pocking	16	39	1676	2	p_ocking
pranking	15	38	1338	2	pranking
prickier	16	36	814	2	prickier
priding	11	33	1754	2	pri_ding
prigging	13	29	909	2	prigging
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
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
racking	14	43	2366	2	_racking
recking	14	43	1992	2	_recking
ricing	9	48	2276	2	_ric_ing
risking	12	39	1424	2	_risking
rocking	14	36	1963	2	_rocking
rucking	14	32	1667	2	_rucking
sicking	14	37	2017	2	_sicking
slicking	15	37	1259	2	slicking
snicking	15	36	1023	2	snicking
sticking	15	35	1346	2	sticking
ticking	14	32	1875	2	_ticking
tracking	15	37	1546	2	tracking
tricing	10	34	1735	2	tric_ing
trickling	16	4	772	2	trickling
trocking	15	36	1242	2	trocking
trucking	15	33	1016	2	trucking
wicking	17	34	1477	2	_wicking
wracking	18	34	996	2	wracking
wrecking	18	32	815	2	wrecking

Search took 9 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	1.046	170832.7
2	DLD Change Limit	121059	67	7.610	15907.9
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	8.689	20565.2