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

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

65 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
plinkers	14	30	939	(None)
blinkers	14	38	850	1	blinkers
clinkers	14	33	983	1	clinkers
linkers	11	43	1771	1	_linkers
pinkers	13	41	1860	1	p_inkers
plinker	13	40	1096	1	plinker_
plunkers	14	32	833	1	plunkers
prinkers	14	30	1038	1	prinkers
aliners	7	47	1772	2	alin_ers
blinders	11	39	1114	2	blinders
blinker	13	41	1021	2	blinker_
clickers	16	39	1020	2	clickers
clingers	11	38	1066	2	clingers
clinker	13	38	1166	2	clinker_
clunkers	14	32	755	2	clunkers
drinkers	13	27	782	2	drinkers
flankers	15	34	930	2	flankers
flickers	17	33	888	2	flickers
flinders	12	43	926	2	flinders
flingers	12	34	1019	2	flingers
flunkers	15	34	753	2	flunkers
inkers	10	40	1883	2	__inkers
jinkers	18	35	1181	2	_jinkers
lickers	13	41	1825	2	_lickers
likers	10	46	2091	2	_li_kers
liners	6	54	2885	2	_lin_ers
lingers	8	42	2330	2	_lingers
linker	10	43	2147	2	_linker_
linters	7	38	2263	2	_linters
lunkers	11	34	1460	2	_lunkers
painters	10	30	1302	2	painters
pickers	15	37	1809	2	p_ickers
pikers	12	47	1739	2	p_i_kers
pincers	11	39	1650	2	p_incers
pinders	10	37	2047	2	p_inders
pingers	10	40	2074	2	p_ingers
pinkens	13	41	964	2	p_inkens
pinker	12	53	2244	2	p_inker_
pinkeys	16	37	821	2	p_inkeys
pinners	9	35	1860	2	p_inners
planers	9	45	1794	2	plan_ers
plankters	15	4	458	2	plankters
planners	10	39	993	2	planners
planters	10	29	1532	2	planters
pliers	8	47	1515	2	pli__ers
plinked	14	39	1089	2	plinke_d
plinks	12	49	1326	2	plink__s
pluckers	16	31	655	2	pluckers
plunders	11	32	983	2	plunders
plungers	11	37	940	2	plungers
plunker	13	39	1065	2	plunker_
pointers	10	30	1372	2	pointers
prickers	16	37	1067	2	prickers
prinker	13	34	1274	2	prinker_
printers	10	32	1490	2	printers
punkers	13	37	1485	2	p_unkers
sinkers	11	36	1854	2	_sinkers
skinkers	11	29	818	2	skinkers
slickers	14	31	1255	2	slickers
slingers	9	37	1268	2	slingers
splinters	11	27	792	2	splinters
stinkers	12	31	1113	2	stinkers
thinkers	15	30	870	2	thinkers
tinkers	11	35	1714	2	_tinkers
winkers	14	35	1711	2	_winkers

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.373	479064.3
2	DLD Change Limit	121059	65	3.690	32807.3
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	4.093	43657.7