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

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

82 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
pluck	13	42	1230	(None)
cluck	13	49	1489	1	cluck
luck	10	53	2982	1	_luck
plack	13	50	1784	1	plack
plucks	14	37	973	1	plucks
plucky	17	40	658	1	plucky
plunk	11	45	1440	1	plunk
puck	12	49	2794	1	p_uck
alack	11	48	2006	2	alack
amuck	13	8	956	2	amuck
black	13	47	1907	2	black
block	13	49	1784	2	block
buck	12	51	2990	2	_buck
chuck	16	48	1487	2	chuck
clack	13	47	2017	2	clack
click	13	52	1795	2	click
clock	13	49	1798	2	clock
clucks	14	45	1207	2	clucks
clunk	11	42	1508	2	clunk
cruck	13	56	1532	2	cruck
duck	11	59	2917	2	_duck
flack	14	45	1941	2	flack
fleck	14	82	1359	2	fleck
flick	14	50	1721	2	flick
flock	14	47	1742	2	flock
flunk	12	50	1438	2	flunk
fuck	13	49	2463	2	_fuck
guck	11	49	2253	2	_guck
huck	13	59	2763	2	_huck
klick	10	53	1144	2	klick
lack	10	58	3768	2	_lack
lick	10	69	3508	2	_lick
lock	10	61	3436	2	_lock
luce	6	51	3257	2	_luce
lucks	11	57	2356	2	_lucks
lucky	14	55	1501	2	_lucky
lunk	8	60	3072	2	_lunk
lurk	8	66	2416	2	_lurk
muck	12	57	2785	2	_muck
pack	12	55	3544	2	p_ack
peck	12	57	3068	2	p_eck
pick	12	59	3382	2	p_ick
place	9	48	2461	2	place
placks	14	44	1415	2	placks
plank	11	52	2114	2	plank
plica	9	6	1337	2	plica
plink	11	52	1912	2	plink
plonk	11	46	1398	2	plonk
plucked	16	36	796	2	plucked
plucker	15	36	825	2	plucker
plug	7	49	1599	2	plu_g
plugs	8	52	1349	2	plugs
plum	8	51	2210	2	plu_m
plumb	11	45	1407	2	plumb
plume	9	48	1946	2	plume
plump	11	53	1526	2	plump
plums	9	46	1995	2	plums
plumy	12	42	1323	2	plumy
plunks	12	47	1116	2	plunks
plunky	15	37	795	2	plunky
plus	6	63	2483	2	plu_s
plush	10	56	1471	2	plush
pock	12	61	2929	2	p_ock
potluck	15	4	403	2	potluck
pouch	12	46	1708	2	pouch
prick	13	43	1750	2	prick
puce	8	51	2788	2	p_uce
pucka	13	34	1280	2	p_ucka
pucks	13	43	2210	2	p_ucks
pulik	11	36	1330	2	pulik
punk	10	57	2997	2	p_unk
ruck	10	47	2833	2	_ruck
shuck	14	43	1453	2	shuck
slack	11	50	2176	2	slack
slick	11	55	2052	2	slick
slunk	9	50	1630	2	slunk
snuck	11	44	1191	2	snuck
stuck	11	45	1577	2	stuck
suck	10	61	3173	2	_suck
truck	11	61	1546	2	truck
tuck	10	46	2657	2	_tuck
yuck	13	64	2353	2	_yuck

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	82	1.406	38264.6
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	1.732	103170.3