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

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

323 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
glummer	12	41	798	(None)
glimmer	12	43	771	1	glimmer
grummer	12	33	878	1	grummer
gummer	11	46	1545	1	g_ummer
plummer	13	29	852	1	plummer
slummer	11	37	1120	1	slummer
aglimmer	13	4	234	2	aglimmer
bummer	12	40	1410	2	_bummer
clammer	13	42	1179	2	clammer
clumber	13	40	1144	2	clumber
cummer	12	44	1459	2	_cummer
drummer	12	40	750	2	drummer
flummery	18	3	305	2	flummery
gammer	11	123	1833	2	g_ammer
gleamer	10	32	851	2	gleamer
glimmers	13	39	615	2	glimmers
glommed	13	26	544	2	glommed
gluer	6	51	1677	2	glu__er
gluier	7	3	1026	2	glu_ier
glume	8	51	2046	2	glu_me_
glumes	9	45	1681	2	glu_mes
glummest	13	23	556	2	glummest
glumpier	13	3	487	2	glumpier
grimmer	12	35	1009	2	grimmer
grummet	12	29	887	2	grummet
gummed	12	38	1166	2	g_ummed
gummers	12	37	1220	2	g_ummers
gummier	12	34	947	2	g_ummier
hummer	13	36	1527	2	_hummer
limmer	10	43	1479	2	_limmer
lumber	10	38	1777	2	_lumber
lumper	10	38	1665	2	_lumper
mummer	9	36	1454	2	_mummer
plumber	13	33	998	2	plumber
plumier	11	35	1004	2	plumier
plummet	13	27	835	2	plummet
plummier	14	3	412	2	plummier
plumper	13	31	877	2	plumper
rummer	10	47	1548	2	_rummer
scummer	13	39	875	2	scummer
slammer	11	39	1303	2	slammer
slimmer	11	42	1134	2	slimmer
slumber	11	38	1100	2	slumber
slummed	12	35	927	2	slummed
slummers	12	35	893	2	slummers
slummier	12	3	547	2	slummier
summer	10	40	1771	2	_summer
almner	8	57	1072	3	al_mner
blamer	10	44	1714	3	bl_amer
bloomer	11	41	981	3	bloomer
blubber	10	39	929	3	blubber
blucher	14	33	1022	3	blucher
bludger	11	41	956	3	bludger
bluer	7	49	1849	3	blu__er
bluffer	15	39	688	3	bluffer
blume	9	56	1989	3	blu_me_
blumed	11	43	1364	3	blu_med
blumes	10	59	1779	3	blu_mes
blunder	10	38	1315	3	blunder
blunger	10	41	1201	3	blunger
blunter	9	45	1203	3	blunter
blurter	9	41	983	3	blurter
blusher	12	41	1311	3	blusher
bluster	9	42	1531	3	bluster
brimmer	13	34	880	3	brimmer
bummed	13	42	1172	3	_bummed
bummers	13	37	1244	3	_bummers
bumper	12	37	1434	3	_bumper
chummed	17	39	644	3	chummed
chummier	17	3	451	3	chummier
claimer	11	27	988	3	claimer
clamber	13	33	1174	3	clamber
clammed	14	36	996	3	clammed
clammers	14	35	1069	3	clammers
clammier	14	3	584	3	clammier
clamper	13	40	1299	3	clamper
climber	13	44	913	3	climber
clubber	13	31	959	3	clubber
clubmen	13	3	425	3	clubmen
clumbers	14	39	1041	3	clumbers
clumped	14	36	1066	3	clumped
clumpier	14	3	558	3	clumpier
clumsier	12	3	473	3	clumsier
clunker	13	41	945	3	clunker
cluster	9	40	1333	3	cluster
clutter	9	42	1166	3	clutter
crammer	13	40	1096	3	crammer
crimmer	13	33	1077	3	crimmer
crumber	13	33	964	3	crumber
crummier	14	3	560	3	crummier
cumber	12	40	1670	3	_cumber
cummers	13	37	1348	3	_cummers
dammer	11	43	1793	3	_dammer
dimmer	11	41	1261	3	_dimmer
drummed	13	30	632	3	drummed
drummers	13	31	616	3	drummers
dumber	11	44	1417	3	_dumber
dumper	11	46	1521	3	_dumper
elmier	8	3	981	3	el_mier
eluder	7	37	1221	3	elu_der
emmer	9	43	1446	3	__emmer
flamer	11	49	1912	3	fl_amer
flamier	12	31	1214	3	flamier
flammed	15	37	741	3	flammed
flubber	14	28	771	3	flubber
fluffer	12	33	650	3	fluffer
flukier	14	39	785	3	flukier
flume	10	60	2117	3	flu_me_
flumed	12	49	1526	3	flu_med
flumes	11	51	1973	3	flu_mes
flummox	21	4	141	3	flummox
flumped	15	37	771	3	flumped
flunker	14	38	936	3	flunker
flusher	13	30	1227	3	flusher
fluster	10	39	1306	3	fluster
fluter	9	53	1686	3	flu_ter
flutier	10	30	1155	3	flutier
flutter	10	40	1209	3	flutter
fumer	10	59	1823	3	_fu_mer
fumier	11	3	1090	3	_fumier
gamer	8	49	2894	3	g__amer
gamier	9	36	1793	3	g_amier
gammed	12	42	1616	3	g_ammed
gammers	12	32	1456	3	g_ammers
gammier	12	37	1119	3	gammier
gaucher	13	3	723	3	gaucher
gaudier	9	3	845	3	gaudier
gauffer	14	7	442	3	gauffer
gauger	8	47	1485	3	gau_ger
gaumed	10	46	1032	3	gau_med
gaunter	8	29	1071	3	gaunter
gauzier	17	3	563	3	gauzier
gazumper	22	4	146	3	gazumper
gemmed	12	32	957	3	g_emmed
gemmier	12	33	738	3	gemmier
germier	10	30	954	3	germier
gimme	10	24	1134	3	g_imme_
gimmes	11	30	1090	3	g_immes
glacier	10	39	1129	3	glacier
gladder	10	39	831	3	gladder
gladier	9	38	1099	3	gladier
glamor	9	5	818	3	gl_amor
glamour	10	6	513	3	glamour
glancer	10	37	1007	3	glancer
glarier	8	41	1220	3	glarier
glazer	16	42	1226	3	gl_azer
glazier	17	40	935	3	glazier
gleamed	11	32	793	3	gleamed
gleamers	11	30	656	3	gleamers
gleamier	11	4	491	3	gleamier
gleaner	8	37	977	3	gleaner
gleemen	10	3	572	3	gleemen
glibber	12	3	516	3	glibber
glider	8	46	1426	3	gl_ider
glime	8	56	2019	3	gl_ime_
glimed	10	53	1228	3	gl_imed
glimes	9	47	1752	3	gl_imes
glimmered	15	4	310	3	glimmered
glimpser	13	4	266	3	glimpser
glister	8	40	1334	3	glister
glitter	8	42	1180	3	glitter
gloater	8	37	1101	3	gloater
glomera	10	3	594	3	gl_omera
gloomed	11	33	741	3	gloomed
gloomier	11	3	509	3	gloomier
glosser	8	34	1081	3	glosser
glover	10	45	1353	3	gl_over
glower	10	51	1493	3	gl_ower
glue	5	56	2849	3	glu__e_
glued	7	51	1836	3	glu__ed
gluers	7	50	1115	3	glu__ers
glues	6	51	2568	3	glu__es
gluey	9	57	1526	3	glu__ey
glugged	11	39	662	3	glugged
glum	7	58	2510	3	glu_m__
glumly	12	35	662	3	glu_mly
glumness	11	3	520	3	glumness
glumpy	14	52	719	3	glu_mpy
glums	8	46	2142	3	glu_m_s
glute	6	60	2090	3	glu_te_
glutei	7	40	974	3	glu_tei
gluten	7	42	1075	3	glu_ten
glutes	7	45	1767	3	glu_tes
glutted	9	3	724	3	glutted
gomer	8	52	2065	3	g__omer
gouger	8	60	1436	3	gou_ger
gourmet	10	5	920	3	gourmet
goutier	8	26	1235	3	goutier
grammar	12	40	689	3	grammar
gramme	11	42	1033	3	gramme_
grammes	12	36	1132	3	grammes
grimier	10	32	1043	3	grimier
grommet	12	26	845	3	grommet
groomer	10	39	987	3	groomer
grubber	12	41	791	3	grubber
grudger	10	36	831	3	grudger
grueler	8	3	702	3	grueler
gruffer	14	7	579	3	gruffer
grumbler	13	86	668	3	grumbler
grume	8	62	1816	3	gru_me_
grumes	9	44	1555	3	gru_mes
grummest	13	28	636	3	grummest
grummets	13	27	503	3	grummets
grumped	13	33	733	3	grumped
grumpier	13	3	480	3	grumpier
grunger	9	38	978	3	grunger
grunter	8	31	1078	3	grunter
guider	8	43	1352	3	g_uider
gulfier	11	3	779	3	gulfier
gulper	9	34	1021	3	g_ulper
gulpier	10	4	695	3	gulpier
gumma	10	53	1310	3	g_umm_a
gummas	11	48	1051	3	g_ummas
gummy	13	54	1365	3	g_umm_y
gunmen	9	34	872	3	g_unmen
gunner	7	38	1398	3	g_unner
gusher	10	41	1577	3	g_usher
gutter	7	38	1771	3	g_utter
hammer	13	81	2003	3	_hammer
hemmer	13	41	1264	3	_hemmer
hummed	14	48	1267	3	_hummed
hummers	14	38	1306	3	_hummers
humper	13	41	1588	3	_humper
jammer	17	40	1413	3	_jammer
jumper	17	36	1237	3	_jumper
klezmer	22	3	193	3	klezmer
krimmer	15	37	687	3	krimmer
kummel	14	26	617	3	_kummel
lamber	10	44	1849	3	_lamber
lamer	7	52	3370	3	_l_amer
lammed	11	39	1562	3	_lammed
limber	10	43	1679	3	_limber
limier	8	35	1872	3	_limier
limmers	11	34	1308	3	_limmers
limner	8	41	1287	3	_limner
limper	10	41	1785	3	_limper
lubber	10	42	1462	3	_lubber
luger	6	53	2208	3	_lu_ger
lugger	8	39	1655	3	_lugger
luller	6	34	1548	3	_luller
lumbar	10	36	1059	3	_lumbar
lumbers	11	38	1591	3	_lumbers
lumen	7	52	2090	3	_lu_men
lummox	17	3	305	3	_lummox
lumped	11	42	1696	3	_lumped
lumpen	10	40	1066	3	_lumpen
lumpers	11	35	1448	3	_lumpers
lumpier	11	34	1014	3	_lumpier
lunger	7	57	2042	3	_lunger
lunier	6	46	1760	3	_lunier
lunker	10	47	1834	3	_lunker
lurer	5	46	2531	3	_lu_rer
lurker	10	36	1329	3	_lurker
lusher	9	38	1876	3	_lusher
luster	6	40	2367	3	_luster
mammer	9	42	1886	3	_mammer
mummed	10	44	1155	3	_mummed
mummers	10	37	1284	3	_mummers
mummery	13	33	666	3	_mummery
mumper	12	35	1352	3	_mumper
number	10	39	1322	3	_number
plucker	15	36	824	3	plucker
plugger	11	37	843	3	plugger
plumbed	14	31	727	3	plumbed
plumbers	14	41	851	3	plumbers
plumbery	17	31	553	3	plumbery
plume	9	48	1946	3	plu_me_
plumed	11	44	1288	3	plu_med
plumes	10	43	1813	3	plu_mes
plummest	14	27	641	3	plummest
plummets	14	30	477	3	plummets
plummy	15	37	566	3	plumm_y
plumped	14	31	864	3	plumped
plumpen	13	27	640	3	plumpen
plumpers	14	35	729	3	plumpers
plunder	10	38	1050	3	plunder
plunger	10	42	1124	3	plunger
plunker	13	39	1065	3	plunker
plusher	12	40	1038	3	plusher
primmer	13	43	1016	3	primmer
pummel	12	27	804	3	_pummel
pumper	12	44	1555	3	_pumper
rammer	10	35	1965	3	_rammer
rimmer	10	35	1603	3	_rimmer
rummers	11	35	1365	3	_rummers
rummier	11	30	956	3	_rummier
scammer	13	36	1197	3	scammer
scummed	14	34	791	3	scummed
scummers	14	27	778	3	scummers
scummier	14	4	508	3	scummier
shammer	14	46	1314	3	shammer
shimmer	14	33	1087	3	shimmer
simmer	10	41	1535	3	_simmer
skimmer	15	32	753	3	skimmer
slammed	12	35	1110	3	slammed
slammers	12	35	1122	3	slammers
slimier	9	32	1201	3	slimier
slimmed	12	36	847	3	slimmed
slimmers	12	36	963	3	slimmers
slubber	11	30	1076	3	slubber
slugger	9	36	1068	3	slugger
slumbers	12	31	1027	3	slumbers
slumbery	15	29	604	3	slumbery
slummy	13	32	586	3	slumm_y
slumped	12	37	1015	3	slumped
spammer	13	34	1043	3	spammer
spumier	11	3	790	3	spumier
stammer	11	60	1334	3	stammer
stemmer	11	32	1018	3	stemmer
strummer	12	3	478	3	strummer
stummed	12	34	855	3	stummed
stumper	11	36	1009	3	stumper
summed	11	40	1404	3	_summed
summers	11	36	1650	3	_summers
summery	14	32	941	3	_summery
swimmer	14	29	765	3	swimmer
thrummer	15	4	293	3	thrummer
thumper	14	35	695	3	thumper
trimmer	11	36	1083	3	trimmer
tummler	11	26	661	3	_tummler
umber	9	46	1759	3	__umber
yammer	13	37	1318	3	_yammer
yummier	14	30	684	3	_yummier

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	323	6.440	20811.6
3	Display Results	323	323	0.123	2626.0
	(SQL Overall)	178691	323	6.969	25640.8