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

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

75 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
flunker	14	38	936	(None)
clunker	13	41	945	1	clunker
flanker	14	39	1129	1	flanker
flunked	15	39	841	1	flunked
flunkers	15	34	753	1	flunkers
flunkey	17	40	579	1	flunkey
funker	13	39	1576	1	f_unker
lunker	10	47	1834	1	_lunker
plunker	13	39	1064	1	plunker
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
flaker	13	49	1617	2	fl_aker
flanger	11	34	1262	2	flanger
flanked	15	37	1064	2	flanked
flanken	14	22	676	2	flanken
flankers	15	34	930	2	flankers
flaunter	11	3	501	2	flaunter
flenser	10	3	678	2	flenser
flicker	16	36	1062	2	flicker
flinder	11	31	987	2	flinder
flinger	11	37	1051	2	flinger
flounder	12	3	510	2	flounder
flubber	14	28	771	2	flubber
fluffer	12	33	650	2	fluffer
fluke	12	50	1689	2	flu_ke_
fluked	14	51	1209	2	flu_ked
flukes	13	51	1419	2	flu_kes
flukey	16	45	981	2	flu_key
flukier	14	39	785	2	flukier
flunk	12	50	1438	2	flunk__
flunkeys	18	26	317	2	flunkeys
flunkie	14	3	451	2	flunkie
flunkies	15	3	639	2	flunkies
flunks	13	46	986	2	flunk_s
flunky	16	40	809	2	flunk_y
flusher	13	30	1227	2	flusher
fluster	10	39	1306	2	fluster
fluter	9	53	1686	2	flu_ter
flutier	10	30	1155	2	flutier
flutter	10	40	1209	2	flutter
founder	11	43	1257	2	founder
franker	14	35	1018	2	franker
fucker	15	34	1442	2	f_ucker
funder	10	40	1608	2	f_under
funked	14	42	1411	2	f_unked
funkers	14	37	1206	2	f_unkers
funkier	14	34	998	2	f_unkier
funner	9	34	1410	2	f_unner
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
plinker	13	40	1096	2	plinker
plucker	15	36	824	2	plucker
plunder	10	38	1049	2	plunder
plunger	10	42	1123	2	plunger
plunked	14	42	959	2	plunked
plunkers	14	32	832	2	plunkers
plunkier	14	30	532	2	plunkier
punker	12	37	1882	2	_punker
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	75	3.406	31612.2
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	3.559	50208.2