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

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

90 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
flunks	13	46	986	(None)
clunks	12	48	1101	1	clunks
flanks	13	39	1340	1	flanks
flunk	12	50	1438	1	flunk_
flunky	16	40	809	1	flunky
funks	12	53	1891	1	f_unks
lunks	9	48	2245	1	_lunks
plunks	12	47	1116	1	plunks
blanks	12	41	1289	2	blanks
blinks	12	46	1357	2	blinks
blunts	8	45	1289	2	blunts
bunks	11	51	2508	2	_bunks
chunks	15	42	1033	2	chunks
clanks	12	46	1518	2	clanks
clinks	12	58	1506	2	clinks
clonks	12	50	1347	2	clonks
clucks	14	45	1207	2	clucks
clunk	11	42	1508	2	clunk_
clunky	15	44	789	2	clunky
drunks	11	42	751	2	drunks
dunks	10	56	2119	2	_dunks
faunas	9	40	1363	2	faunas
fauns	8	45	1675	2	faun_s
finks	12	54	2422	2	f_inks
flacks	15	41	1453	2	flacks
flanes	9	45	2242	2	flanes
flank	12	46	1809	2	flank_
flans	8	53	2797	2	flan_s
flasks	13	48	867	2	flasks
flaunts	10	5	613	2	flaunts
flecks	15	43	1080	2	flecks
flicks	15	45	1299	2	flicks
flings	10	67	1528	2	flings
flints	9	56	1745	2	flints
flocks	15	47	1353	2	flocks
flongs	10	50	1049	2	flongs
flubs	10	55	1544	2	flu_bs
flues	8	46	2692	2	flu_es
fluffs	11	34	778	2	fluffs
fluids	10	34	942	2	fluids
fluke	12	50	1689	2	flu_ke
flukes	13	51	1419	2	flukes
fluky	15	45	1229	2	flu_ky
flumes	11	51	1973	2	flumes
flumps	13	51	1250	2	flumps
flung	9	51	1458	2	flun_g
flunked	15	39	841	2	flunked
flunker	14	38	936	2	flunker
flunkers	15	34	753	2	flunkers
flunkey	17	40	579	2	flunkey
flunkeys	18	26	317	2	flunkeys
flunkie	14	3	451	2	flunkie
flunkies	15	3	639	2	flunkies
fluors	9	43	1137	2	fluors
flus	7	56	2654	2	flu__s
flutes	9	54	2178	2	flutes
fluxes	16	52	1293	2	fluxes
fluyts	12	36	715	2	fluyts
founds	10	48	1419	2	founds
founts	9	43	1338	2	founts
franks	13	49	1273	2	franks
fucks	14	44	1925	2	f_ucks
funds	9	41	1925	2	f_unds
funk	11	58	2562	2	f_unk_
funky	15	43	1513	2	f_unky
funs	7	52	3573	2	f_un_s
gunks	10	45	1772	2	_gunks
hunks	12	53	2145	2	_hunks
junks	16	48	1597	2	_junks
links	9	64	3019	2	_links
lucks	11	57	2356	2	_lucks
lunas	5	50	2501	2	_lunas
lunes	5	53	3777	2	_lunes
lungs	6	52	2388	2	_lungs
lunk	8	60	3072	2	_lunk_
lunts	5	58	2690	2	_lunts
lurks	9	52	1874	2	_lurks
planks	12	41	1675	2	planks
plinks	12	49	1326	2	plinks
plonks	12	42	1042	2	plonks
plucks	14	37	973	2	plucks
plunk	11	45	1440	2	plunk_
plunky	15	37	795	2	plunky
punks	11	48	2268	2	_punks
skunks	9	46	816	2	skunks
slinks	10	43	1515	2	slinks
slunk	9	50	1630	2	slunk_
spunks	12	34	933	2	spunks
thunks	13	45	903	2	thunks
trunks	10	42	975	2	trunks

Search took 3 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	82551	0.390	458182.1
2	DLD Change Limit	82551	90	2.500	33020.4
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	2.923	61132.7