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	1066	(None)
clunker	13	41	946	1	clunker
flunker	14	38	937	1	flunker
lunker	10	47	1835	1	_lunker
plinker	13	40	1097	1	plinker
plucker	15	36	825	1	plucker
plunder	10	38	1051	1	plunder
plunger	10	42	1125	1	plunger
plunked	14	42	960	1	plunked
plunkers	14	32	834	1	plunkers
plunkier	14	30	533	1	plunkier
punker	12	37	1883	1	p_unker
blanker	13	46	1202	2	blanker
blinker	13	41	1021	2	blinker
blunder	10	38	1316	2	blunder
blunger	10	41	1202	2	blunger
blunter	9	45	1204	2	blunter
bunker	12	45	1937	2	_bunker
clinker	13	38	1166	2	clinker
clunked	14	43	957	2	clunked
clunkers	14	32	756	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	754	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	2043	2	_lunger
lunier	6	46	1761	2	_lunier
lunkers	11	34	1461	2	_lunkers
lurker	10	36	1329	2	_lurker
pinker	12	53	2244	2	p_inker
planer	8	41	2266	2	plan_er
planked	14	35	1228	2	planked
plankter	14	3	536	2	plankter
planner	9	35	1163	2	planner
planter	9	40	1781	2	planter
plinked	14	39	1089	2	plinked
plinkers	14	30	940	2	plinkers
plonked	14	34	810	2	plonked
plucked	16	36	796	2	plucked
pluckers	16	31	656	2	pluckers
pluckier	16	29	507	2	pluckier
plugger	11	37	844	2	plugger
plumber	13	33	999	2	plumber
plumier	11	35	1005	2	plumier
plummer	13	29	853	2	plummer
plumper	13	31	878	2	plumper
plunders	11	32	984	2	plunders
plunge	9	38	1106	2	plunge_
plunged	11	43	953	2	plunged
plungers	11	37	941	2	plungers
plunges	10	40	1162	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	1039	2	plusher
pouncer	11	35	1124	2	pouncer
pounder	10	33	1401	2	pounder
prinker	13	34	1274	2	prinker
pruner	8	34	1346	2	prun_er
pucker	14	38	1763	2	p_ucker
punier	8	45	1923	2	p_unier
punkers	13	37	1486	2	p_unkers
punkey	15	40	1117	2	p_unkey
punkier	13	35	1279	2	p_unkier
punner	8	49	1816	2	p_unner
punter	8	43	2003	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.393	454684.5
2	DLD Change Limit	107671	76	3.123	34476.8
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	3.546	50392.3