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

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

89 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
flump	12	46	1472	(None)
clump	11	55	1745	1	clump
flume	10	60	2117	1	flume
flumps	13	51	1250	1	flumps
frump	12	69	1256	1	frump
lump	8	65	3170	1	_lump
plump	11	53	1526	1	plump
slump	9	48	1663	1	slump
alum	6	52	2761	2	alum_
alums	7	57	2060	2	alums
blimp	11	56	1294	2	blimp
blume	9	56	1989	2	blume
bump	10	62	2824	2	_bump
chump	14	53	1544	2	chump
clamp	11	55	1765	2	clamp
clomp	11	56	1570	2	clomp
clumps	12	153	1464	2	clumps
clumpy	15	40	957	2	clumpy
crump	11	56	1642	2	crump
dump	9	59	2709	2	_dump
filum	10	50	1543	2	filum_
flam	9	63	3329	2	flam_
flame	10	51	2444	2	flame
flams	10	51	2501	2	flams
flamy	13	52	1747	2	flamy
flap	9	61	2870	2	fl_ap
flip	9	63	2426	2	fl_ip
flop	9	69	2545	2	fl_op
flu	6	65	3021	2	flu__
flub	9	57	2188	2	flu_b
flubs	10	55	1544	2	flubs
flue	7	53	2985	2	flu_e
flued	9	50	2125	2	flued
flues	8	46	2692	2	flues
fluff	10	39	1361	2	fluff
fluid	9	40	1396	2	fluid
fluke	12	50	1689	2	fluke
fluky	15	45	1229	2	fluky
flumed	12	49	1526	2	flumed
flumes	11	51	1973	2	flumes
flumped	15	37	771	2	flumped
flung	9	51	1458	2	flung
flunk	12	50	1438	2	flunk
fluor	8	45	1277	2	fluor
flus	7	56	2654	2	flu_s
flush	11	51	1607	2	flush
flute	8	68	2375	2	flute
fluty	11	44	1564	2	fluty
flux	14	56	1774	2	flu_x
fluyt	11	46	1420	2	fluyt
frumps	13	47	978	2	frumps
frumpy	16	46	688	2	frumpy
fume	9	67	2763	2	f_ume
fumy	12	71	1858	2	f_umy
glum	7	58	2510	2	glum_
glume	8	51	2046	2	glume
glumpy	14	52	719	2	glumpy
glums	8	46	2142	2	glums
grump	10	51	1531	2	grump
hump	11	62	2872	2	_hump
jump	15	66	2172	2	_jump
lamp	8	62	3382	2	_lamp
limp	8	84	3249	2	_limp
lum	5	55	4293	2	_lum_
luma	6	55	2752	2	_luma
lumps	9	56	2498	2	_lumps
lumpy	12	66	1591	2	_lumpy
lums	6	57	3424	2	_lums
mump	10	54	2572	2	_mump
plum	8	51	2210	2	plum_
plumb	11	45	1407	2	plumb
plume	9	48	1946	2	plume
plumps	12	46	1261	2	plumps
plums	9	46	1995	2	plums
plumy	12	42	1323	2	plumy
pump	10	57	2685	2	_pump
rump	8	67	2908	2	_rump
shlump	13	4	571	2	shlump
slum	6	54	3051	2	slum_
slumps	10	43	1358	2	slumps
slums	7	46	2343	2	slums
slurp	7	40	1498	2	slurp
stump	9	46	1646	2	stump
sump	8	63	3153	2	_sump
thump	12	62	1157	2	thump
trump	9	56	1512	2	trump
tump	8	59	2703	2	_tump
ump	7	61	3044	2	__ump
whump	15	49	1004	2	whump

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	89	1.530	35163.4
3	Display Results	89	89	0.033	2697.0
	(SQL Overall)	178691	89	1.859	96122.1