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

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

76 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
plunker	13	39	1064	(None)
clunker	13	41	945	1	clunker
flunker	14	38	936	1	flunker
lunker	10	47	1834	1	_lunker
plinker	13	40	1096	1	plinker
plucker	15	36	824	1	plucker
plunder	10	38	1049	1	plunder
plunger	10	42	1123	1	plunger
plunked	14	42	959	1	plunked
plunkers	14	32	832	1	plunkers
plunkier	14	30	532	1	plunkier
punker	12	37	1882	1	p_unker
blanker	13	46	1202	2	blanker
blinker	13	41	1021	2	blinker
blunder	10	38	1314	2	blunder
blunger	10	41	1201	2	blunger
blunter	9	45	1203	2	blunter
bunker	12	45	1937	2	_bunker
clinker	13	38	1166	2	clinker
clunked	14	43	957	2	clunked
clunkers	14	32	755	2	clunkers
clunkier	14	34	579	2	clunkier
drunker	12	32	663	2	drunker
dunker	11	36	1646	2	_dunker
flanker	14	39	1129	2	flanker
flunked	15	39	841	2	flunked
flunkers	15	34	753	2	flunkers
flunkey	17	40	579	2	flunkey
funker	13	39	1576	2	_funker
hunker	13	39	1767	2	_hunker
junker	17	42	1365	2	_junker
lanker	10	41	2300	2	_lanker
linker	10	43	2147	2	_linker
lunger	7	57	2042	2	_lunger
lunier	6	46	1760	2	_lunier
lunkers	11	34	1460	2	_lunkers
lurker	10	36	1329	2	_lurker
pinker	12	53	2244	2	p_inker
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
plinked	14	39	1089	2	plinked
plinkers	14	30	939	2	plinkers
plonked	14	34	810	2	plonked
plucked	16	36	796	2	plucked
pluckers	16	31	655	2	pluckers
pluckier	16	29	507	2	pluckier
plugger	11	37	843	2	plugger
plumber	13	33	998	2	plumber
plumier	11	35	1004	2	plumier
plummer	13	29	852	2	plummer
plumper	13	31	877	2	plumper
plunders	11	32	982	2	plunders
plunge	9	38	1105	2	plunge_
plunged	11	43	952	2	plunged
plungers	11	37	939	2	plungers
plunges	10	40	1161	2	plunges
plunk	11	45	1440	2	plunk__
plunks	12	47	1116	2	plunk_s
plunky	15	37	795	2	plunk_y
plusher	12	40	1038	2	plusher
pouncer	11	35	1123	2	pouncer
pounder	10	33	1399	2	pounder
prinker	13	34	1274	2	prinker
pruner	8	34	1345	2	prun_er
pucker	14	38	1763	2	p_ucker
punier	8	45	1922	2	p_unier
punkers	13	37	1485	2	p_unkers
punkey	15	40	1117	2	p_unkey
punkier	13	35	1279	2	p_unkier
punner	8	49	1815	2	p_unner
punter	8	43	2002	2	p_unter
spelunker	15	4	196	2	spelunker
younker	14	31	645	2	younker

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.123	1452772.4
2	DLD Change Limit	107671	76	3.313	32499.5
3	Display Results	76	76	0.016	4750.0
	(SQL Overall)	178691	76	3.452	51764.5