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

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

67 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
plunger	10	42	1125	(None)
blunger	10	41	1202	1	blunger
lunger	7	57	2043	1	_lunger
plugger	11	37	844	1	plugger
plunder	10	38	1051	1	plunder
plunge	9	38	1106	1	plunge_
plunged	11	43	953	1	plunged
plungers	11	37	941	1	plungers
plunges	10	40	1162	1	plunges
plunker	13	39	1066	1	plunker
bludger	11	41	956	2	bludger
blunder	10	38	1316	2	blunder
blunge	9	43	1148	2	blunge_
blunged	11	43	1013	2	blunged
blungers	11	46	985	2	blungers
blunges	10	42	1222	2	blunges
blunter	9	45	1204	2	blunter
clanger	10	41	1349	2	clanger
clinger	10	38	1215	2	clinger
clunker	13	41	946	2	clunker
flanger	11	34	1262	2	flanger
flinger	11	37	1051	2	flinger
flunker	14	38	937	2	flunker
grunger	9	38	978	2	grunger
hunger	10	40	1520	2	_hunger
linger	7	52	2600	2	_linger
longer	7	58	2320	2	_longer
lounger	8	46	1021	2	lounger
luger	6	53	2208	2	_lu_ger
lugger	8	39	1655	2	_lugger
lunge	6	53	2380	2	_lunge_
lunged	8	54	1827	2	_lunged
lungee	7	51	1981	2	_lungee
lungers	8	38	1710	2	_lungers
lunges	7	61	2342	2	_lunges
lunier	6	46	1761	2	_lunier
lunker	10	47	1835	2	_lunker
pinger	9	43	2409	2	p_inger
planer	8	41	2266	2	plan_er
planner	9	35	1163	2	planner
planter	9	40	1781	2	planter
pledger	11	35	917	2	pledger
plinker	13	40	1097	2	plinker
plucker	15	36	825	2	plucker
plugged	12	40	804	2	plugged
pluggers	12	29	703	2	pluggers
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
plunked	14	42	960	2	plunked
plunkers	14	32	834	2	plunkers
plunkier	14	30	533	2	plunkier
plusher	12	40	1039	2	plusher
pouncer	11	35	1124	2	pouncer
pounder	10	33	1401	2	pounder
pruner	8	34	1346	2	prun_er
punier	8	45	1923	2	p_unier
punker	12	37	1883	2	p_unker
punner	8	49	1816	2	p_unner
punter	8	43	2003	2	p_unter
purger	9	47	1723	2	p_urger
slinger	8	34	1383	2	slinger
slugger	9	36	1068	2	slugger
splurger	11	4	381	2	splurger
younger	11	38	716	2	younger

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.376	475242.0
2	DLD Change Limit	107671	67	3.000	35890.3
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	3.392	52680.1