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

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

88 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
pricked	16	46	1383	(None)
bricked	16	43	1206	1	bricked
cricked	16	48	1428	1	cricked
picked	15	44	2131	1	p_icked
priced	11	50	1888	1	pric_ed
pricker	15	40	1341	1	pricker
pricket	15	36	1644	1	pricket
prickled	17	35	807	1	prickled
prinked	14	34	1216	1	prinked
ricked	13	65	2362	1	_ricked
tricked	14	40	1616	1	tricked
wricked	17	49	1019	1	wricked
arcked	13	62	1194	2	ar_cked
brisked	14	42	1000	2	brisked
clicked	16	41	1245	2	clicked
cracked	16	35	1474	2	cracked
cricket	15	47	1695	2	cricket
crickey	18	41	814	2	crickey
crocked	16	40	1443	2	crocked
dicked	14	49	2086	2	_dicked
flicked	17	46	1067	2	flicked
frisked	15	47	882	2	frisked
frocked	17	43	933	2	frocked
hoicked	17	3	596	2	hoicked
kicked	12	44	1594	2	_kicked
licked	13	46	2156	2	_licked
nicked	13	50	1968	2	_nicked
packed	15	48	2260	2	p_acked
paiked	13	51	1343	2	pai_ked
panicked	17	8	517	2	panicked
pecked	15	50	1910	2	p_ecked
picker	14	44	2217	2	p_icker
picket	14	49	2431	2	p_icket
pickled	16	40	1188	2	p_ickled
piked	12	56	2331	2	p_i_ked
pinked	13	48	1988	2	p_inked
plinked	14	39	1089	2	plinked
plucked	16	36	796	2	plucked
pocked	15	48	1898	2	p_ocked
pranked	14	37	1209	2	pranked
price	9	37	2541	2	pric_e_
pricer	10	39	1829	2	pric_er
prices	10	45	2454	2	pric_es
pricey	13	44	1263	2	pric_ey
pricier	11	33	1311	2	pricier
prick	13	43	1750	2	prick__
prickers	16	37	1067	2	prickers
prickets	16	32	908	2	prickets
prickier	16	36	814	2	prickier
prickle	15	36	1101	2	prickle
prickles	16	25	1109	2	prickles
prickly	18	36	789	2	prickly
pricks	14	44	1426	2	prick_s
pricky	17	42	1034	2	prick_y
prided	10	36	1803	2	pri_ded
pried	8	44	2686	2	pri__ed
prigged	12	39	893	2	prigged
prilled	10	47	1299	2	prilled
primed	11	51	1891	2	pri_med
primmed	14	38	885	2	primmed
primped	14	47	915	2	primped
prinker	13	34	1274	2	prinker
printed	10	40	1637	2	printed
prised	9	43	2220	2	pri_sed
prissed	10	33	1126	2	prissed
prized	18	44	1539	2	pri_zed
proceed	12	3	1054	2	proceed
racked	13	45	2608	2	_racked
recked	13	48	2180	2	_recked
riced	8	58	2554	2	_ric_ed
rickey	15	46	1397	2	_rickey
risked	11	55	1463	2	_risked
rocked	13	50	2232	2	_rocked
rucked	13	47	1876	2	_rucked
sicked	13	45	2440	2	_sicked
slicked	14	44	1384	2	slicked
snicked	14	38	1163	2	snicked
sticked	14	41	1463	2	sticked
ticked	13	47	2052	2	_ticked
tracked	14	37	1613	2	tracked
triced	9	55	1867	2	tric_ed
tricker	13	46	1552	2	tricker
trickled	15	26	1043	2	trickled
trocked	14	43	1224	2	trocked
trucked	14	39	1081	2	trucked
wicked	16	43	1741	2	_wicked
wracked	17	41	1011	2	wracked
wrecked	17	41	833	2	wrecked

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.126	1418182.5
2	DLD Change Limit	107671	88	3.500	30763.1
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.656	48876.1