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

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

54 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
plunking	15	32	848	(None)
clunking	15	32	943	1	clunking
flunking	16	31	777	1	flunking
planking	15	35	1301	1	planking
plinking	15	36	1124	1	plinking
plonking	15	35	856	1	plonking
plucking	17	35	772	1	plucking
plunging	12	35	767	1	plunging
blanking	15	44	1193	2	blanking
blinking	15	35	1062	2	blinking
blunging	12	32	841	2	blunging
blunting	11	31	984	2	blunting
bunking	14	40	1619	2	_bunking
chunking	18	32	805	2	chunking
clanking	15	43	1306	2	clanking
clinking	15	36	1166	2	clinking
clonking	15	38	1015	2	clonking
clucking	17	42	999	2	clucking
dunking	13	38	1326	2	_dunking
flanking	16	42	1108	2	flanking
fluking	15	44	1051	2	flu_king
funking	15	40	1302	2	_funking
junking	19	39	1007	2	_junking
linking	12	38	1825	2	_linking
lucking	14	36	1583	2	_lucking
lunging	9	37	1421	2	_lunging
lunting	8	38	1774	2	_lunting
lurking	12	37	1085	2	_lurking
pinking	14	39	1894	2	p_inking
planing	10	34	1825	2	plan_ing
plankings	16	32	611	2	plankings
planning	11	36	1022	2	planning
planting	11	35	1538	2	planting
plugging	13	30	689	2	plugging
plumbing	15	28	643	2	plumbing
pluming	12	34	1204	2	plu_ming
plumping	15	27	763	2	plumping
plunkier	14	30	532	2	plunkier
pouncing	13	31	888	2	pouncing
pounding	12	33	1147	2	pounding
pranking	15	38	1338	2	pranking
prinking	15	32	1245	2	prinking
pruning	10	3	1173	2	prun_ing
puking	13	39	1306	2	p_u_king
punkin	12	36	1152	2	p_unkin_
punkins	13	31	1111	2	p_unkins
punning	10	34	1499	2	p_unning
punting	10	33	1844	2	p_unting
skunking	12	25	665	2	skunking
slinking	13	34	1298	2	slinking
spelunking	17	11	200	2	spelunking
spunking	15	25	806	2	spunking
thunking	16	19	695	2	thunking
uplinking	16	3	462	2	uplinking

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	121059	0.410	435831.7
2	DLD Change Limit	121059	54	3.483	34757.1
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	3.923	45549.6