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

Here are the results of your fuzzy-string dictionary search for “flummery” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

112 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
flummery	18	3	305	(None)
fluttery	14	37	614	2	fluttery
glummer	12	41	798	2	glummer_
mummery	13	33	666	2	_mummery
plumbery	17	31	553	2	plumbery
plummer	13	29	852	2	plummer_
slumbery	15	29	604	2	slumbery
slummer	11	37	1120	2	slummer_
slummers	12	35	893	2	slummers
summery	14	32	941	2	_summery
bloomery	15	33	569	3	bloomery
blubbery	14	29	478	3	blubbery
blustery	13	36	800	3	blustery
bummer	12	40	1410	3	_bummer_
bummers	13	37	1244	3	_bummers
clammer	13	42	1179	3	clammer_
clammers	14	35	1069	3	clammers
clumber	13	40	1144	3	clumber_
clumbers	14	39	1041	3	clumbers
clustery	13	31	711	3	clustery
cluttery	13	34	632	3	cluttery
cummer	12	44	1459	3	_cummer_
cummers	13	37	1348	3	_cummers
drummer	12	40	750	3	drummer_
drummers	13	31	616	3	drummers
flackery	20	29	524	3	flackery
flamer	11	49	1912	3	fl_amer_
flamers	12	46	1636	3	fl_amers
flamier	12	31	1214	3	flamier_
flammed	15	37	741	3	flamme_d
flattery	14	33	829	3	flattery
flickery	20	36	510	3	flickery
flowery	16	32	778	3	fl_owery
flubber	14	28	771	3	flubber_
flubbers	15	34	689	3	flubbers
fluffer	12	33	650	3	fluffer_
fluffers	13	33	529	3	fluffers
flukey	16	45	981	3	flu_ke_y
flukier	14	39	785	3	flukier_
flume	10	60	2117	3	flu_me__
flumed	12	49	1526	3	flu_me_d
flumes	11	51	1973	3	flu_me_s
flummeries	17	4	376	3	flummeries
flummox	21	4	141	3	flumm_ox
flumped	15	37	771	3	flumpe_d
flunker	14	38	936	3	flunker_
flunkers	15	34	753	3	flunkers
flunkey	17	40	579	3	flunke_y
flurry	12	39	711	3	flu__rry
flusher	13	30	1227	3	flusher_
flushers	14	27	973	3	flushers
fluster	10	39	1306	3	fluster_
flusters	11	38	1150	3	flusters
fluter	9	53	1686	3	flu_ter_
fluters	10	37	1368	3	flu_ters
flutey	12	52	1252	3	flu_te_y
flutier	10	30	1155	3	flutier_
flutter	10	40	1209	3	flutter_
flutters	11	40	1082	3	flutters
fullery	13	33	797	3	f_ullery
fumer	10	59	1823	3	f_u_mer_
fumers	11	36	1338	3	f_u_mers
fumier	11	3	1090	3	f_umier_
furmety	15	3	481	3	f_urmety
glimmer	12	43	771	3	glimmer_
glimmers	13	39	615	3	glimmers
glummest	13	23	556	3	glummest
grummer	12	33	878	3	grummer_
gummer	11	46	1545	3	_gummer_
gummers	12	37	1220	3	_gummers
hummer	13	36	1527	3	_hummer_
hummers	14	38	1306	3	_hummers
limmer	10	43	1479	3	_limmer_
limmers	11	34	1308	3	_limmers
lumber	10	38	1777	3	_lumber_
lumberly	15	4	468	3	_lumberly
lumbers	11	38	1591	3	_lumbers
lumper	10	38	1665	3	_lumper_
lumpers	11	35	1448	3	_lumpers
mummer	9	36	1454	3	_mummer_
mummers	10	37	1284	3	_mummers
nummary	14	31	465	3	_nummary
plumber	13	33	998	3	plumber_
plumbers	14	41	851	3	plumbers
plumier	11	35	1004	3	plumier_
plummest	14	27	641	3	plummest
plummet	13	27	835	3	plumme_t
plummets	14	30	477	3	plummets
plummier	14	3	412	3	plummier_
plummy	15	37	566	3	plumm__y
plumper	13	31	877	3	plumper_
plumpers	14	35	729	3	plumpers
rummer	10	47	1548	3	_rummer_
rummers	11	35	1365	3	_rummers
scummer	13	39	875	3	scummer_
scummers	14	27	778	3	scummers
shimmery	18	26	525	3	shimmery
slammer	11	39	1303	3	slammer_
slammers	12	35	1122	3	slammers
slimmer	11	42	1134	3	slimmer_
slimmers	12	36	963	3	slimmers
slumber	11	38	1100	3	slumber_
slumbers	12	31	1027	3	slumbers
slummed	12	35	927	3	slumme_d
slummier	12	3	547	3	slummier_
slummy	13	32	586	3	slumm__y
stemmery	15	33	469	3	stemmery
summary	14	29	735	3	_summary
summer	10	40	1771	3	_summer_
summerly	15	27	510	3	_summerly
summers	11	36	1650	3	_summers
trumpery	15	3	361	3	trumpery

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	112	6.720	21750.3
3	Display Results	112	112	0.030	3733.3
	(SQL Overall)	178691	112	7.173	24911.6