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

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

83 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
plinker	13	40	1096	(None)
blinker	13	41	1021	1	blinker
clinker	13	38	1166	1	clinker
linker	10	43	2147	1	_linker
pinker	12	53	2244	1	p_inker
plinked	14	39	1089	1	plinked
plinkers	14	30	939	1	plinkers
plunker	13	39	1065	1	plunker
prinker	13	34	1274	1	prinker
aliner	6	56	2198	2	alin_er
blanker	13	46	1202	2	blanker
blinder	10	39	1298	2	blinder
blinked	14	40	1001	2	blinked
blinkers	14	38	850	2	blinkers
clicker	15	41	1188	2	clicker
clinger	10	38	1215	2	clinger
clinked	14	40	1164	2	clinked
clinkers	14	33	983	2	clinkers
clunker	13	41	945	2	clunker
drinker	12	34	948	2	drinker
flanker	14	39	1129	2	flanker
flicker	16	36	1062	2	flicker
flinder	11	31	987	2	flinder
flinger	11	37	1051	2	flinger
flunker	14	38	936	2	flunker
inker	9	44	2109	2	__inker
jinker	17	40	1354	2	_jinker
lanker	10	41	2300	2	_lanker
licker	12	52	2204	2	_licker
liker	9	56	2706	2	_li_ker
liner	5	59	3892	2	_lin_er
linger	7	52	2600	2	_linger
linier	6	44	2379	2	_linier
linked	11	45	1821	2	_linked
linkers	11	43	1771	2	_linkers
linter	6	46	2534	2	_linter
lunker	10	47	1834	2	_lunker
painter	9	38	1456	2	painter
picker	14	44	2217	2	p_icker
piker	11	56	2284	2	p_i_ker
pincer	10	40	1917	2	p_incer
pinder	9	45	2345	2	p_inder
pinger	9	43	2409	2	p_inger
pinier	8	40	2469	2	p_inier
pinked	13	48	1988	2	p_inked
pinken	12	45	1328	2	p_inken
pinkers	13	41	1860	2	p_inkers
pinkey	15	43	1467	2	p_inkey
pinner	8	45	2150	2	p_inner
plainer	9	38	1198	2	plain_er
planer	8	41	2265	2	plan_er
planked	14	35	1228	2	planked
plankter	14	3	536	2	plankter
planner	9	35	1162	2	planner
planter	9	40	1780	2	planter
plier	7	52	2128	2	pli__er
plink	11	52	1912	2	plink__
plinks	12	49	1326	2	plink_s
plonked	14	34	810	2	plonked
plucker	15	36	824	2	plucker
plunder	10	38	1050	2	plunder
plunger	10	42	1124	2	plunger
plunked	14	42	959	2	plunked
plunkers	14	32	833	2	plunkers
plunkier	14	30	532	2	plunkier
pointer	9	38	1493	2	pointer
pricker	15	40	1341	2	pricker
prinked	14	34	1216	2	prinked
prinkers	14	30	1039	2	prinkers
printer	9	39	1730	2	printer
punker	12	37	1882	2	p_unker
sinker	10	36	2090	2	_sinker
skinker	10	31	944	2	skinker
slicker	13	33	1453	2	slicker
slinger	8	34	1383	2	slinger
slinked	12	30	1138	2	slinked
slinkier	12	20	693	2	slinkier
splinter	10	32	970	2	splinter
stinker	11	33	1331	2	stinker
thinker	14	36	1068	2	thinker
tinker	10	36	1992	2	_tinker
uplinked	15	25	420	2	uplinked
winker	13	42	2029	2	_winker

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.373	479064.3
2	DLD Change Limit	107671	83	3.173	33933.5
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	3.576	49969.5