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

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

315 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
drummer	12	40	750	(None)
drummed	13	30	632	1	drummed
drummers	13	31	616	1	drummers
grummer	12	33	878	1	grummer
rummer	10	47	1548	1	_rummer
brimmer	13	34	880	2	brimmer
bummer	12	40	1410	2	_bummer
crammer	13	40	1096	2	crammer
crimmer	13	33	1077	2	crimmer
crumber	13	33	964	2	crumber
crummier	14	3	560	2	crummier
cummer	12	44	1459	2	_cummer
dammer	11	43	1793	2	d_ammer
dimmer	11	41	1261	2	d_immer
drammed	13	37	807	2	drammed
dreamer	10	41	1084	2	dreamer
drubber	12	35	786	2	drubber
drudger	10	32	832	2	drudger
drumlier	11	3	452	2	drumlier
drunker	12	32	663	2	drunker
dumber	11	44	1417	2	d_umber
dumper	11	46	1521	2	d_umper
glummer	12	41	798	2	glummer
grimmer	12	35	1009	2	grimmer
grummet	12	29	887	2	grummet
gummer	11	46	1545	2	_gummer
hummer	13	36	1527	2	_hummer
krimmer	15	37	687	2	krimmer
mummer	9	36	1454	2	_mummer
plummer	13	29	852	2	plummer
primmer	13	43	1016	2	primmer
rammer	10	35	1965	2	_rammer
rimmer	10	35	1603	2	_rimmer
rummers	11	35	1365	2	_rummers
rummier	11	30	956	2	_rummier
scummer	13	39	875	2	scummer
slummer	11	37	1120	2	slummer
strummer	12	3	478	2	strummer
summer	10	40	1771	2	_summer
thrummer	15	4	293	2	thrummer
trimmer	11	36	1083	2	trimmer
armer	7	69	2444	3	ar__mer
brimmed	14	38	678	3	brimmed
brimmers	14	28	707	3	brimmers
bruiser	9	34	957	3	bruiser
bruiter	9	37	1063	3	bruiter
brume	9	58	1798	3	bru_me_
brumes	10	64	1707	3	bru_mes
brusher	12	38	1300	3	brusher
brusker	13	43	785	3	brusker
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
clammer	13	42	1179	3	clammer
clumber	13	40	1144	3	clumber
crammed	14	37	1012	3	crammed
crammers	14	36	934	3	crammers
creamer	11	37	1408	3	creamer
crimmers	14	29	854	3	crimmers
crimper	13	65	1042	3	crimper
cruder	9	56	1238	3	cru_der
crueler	9	3	902	3	crueler
cruiser	9	34	1043	3	cruiser
cruller	9	6	875	3	cruller
crumbed	14	37	847	3	crumbed
crumbers	14	33	822	3	crumbers
crumbier	14	5	636	3	crumbier
crummie	13	3	615	3	crummie
crummies	14	3	764	3	crummies
crummy	15	36	589	3	crumm_y
crumped	14	43	1122	3	crumped
crumpet	13	37	1106	3	crumpet
crupper	13	33	856	3	crupper
crusher	12	44	1232	3	crusher
cumber	12	40	1670	3	_cumber
cummers	13	37	1347	3	_cummers
dammar	11	43	890	3	d_ammar
dammed	12	42	1479	3	d_ammed
dammers	12	32	1427	3	d_ammers
damner	9	52	1343	3	d_amner
damper	11	41	1775	3	d_amper
dauber	9	41	1201	3	dau_ber
daubier	10	3	709	3	daubier
daunder	9	34	889	3	daunder
daunter	8	38	1175	3	daunter
defamer	13	27	1032	3	defamer
degummed	15	4	260	3	degummed
demurer	10	3	787	3	demurer
dimer	8	56	2560	3	d__imer
dimmed	12	41	1032	3	d_immed
dimmers	12	38	1156	3	d_immers
doomier	10	36	1012	3	doomier
dormer	9	44	1589	3	d_ormer
doubler	10	31	1008	3	doubler
doubter	10	29	835	3	doubter
dourer	7	42	1527	3	dou_rer
douser	7	56	2163	3	dou_ser
drabber	12	43	859	3	drabber
drafter	11	44	942	3	drafter
dragger	10	30	916	3	dragger
drainer	8	30	1284	3	drainer
draper	9	43	1569	3	dr_aper
drawer	10	47	1136	3	dr_awer
drawler	11	33	859	3	drawler
draymen	13	3	523	3	draymen
dreamed	11	43	1063	3	dreamed
dreamers	11	36	900	3	dreamers
dreamier	11	28	729	3	dreamier
dredger	10	34	744	3	dredger
dresser	8	36	1195	3	dresser
drier	6	44	2396	3	dr__ier
drifter	11	34	870	3	drifter
driller	8	43	1188	3	driller
drinker	12	34	947	3	drinker
dripper	12	34	922	3	dripper
driver	10	47	1449	3	dr_iver
droller	8	41	1028	3	droller
droner	7	47	1767	3	dr_oner
dropper	12	32	987	3	dropper
drover	10	46	1459	3	dr_over
drowner	11	36	980	3	drowner
drubbed	13	40	698	3	drubbed
drubbers	13	38	602	3	drubbers
drudge	9	31	790	3	drudge_
drudged	11	27	761	3	drudged
drudgers	11	32	684	3	drudgers
drudgery	14	27	363	3	drudgery
drudges	10	30	887	3	drudges
drugged	11	36	717	3	drugged
drugget	10	33	761	3	drugget
druggier	11	13	483	3	druggier
drugmaker	17	5	200	3	drugmaker
drum	7	65	2159	3	dru_m__
drumbeat	13	4	397	3	drumbeat
drumble	12	33	789	3	drumble
drumbled	14	26	603	3	drumbled
drumbles	13	27	772	3	drumbles
drumfire	14	4	254	3	drumfire
drumhead	15	4	265	3	drumhead
drumlin	10	4	442	3	drumlin
drumly	12	3	570	3	dru_mly
drumming	14	26	578	3	drumming
drums	8	54	1587	3	dru_m_s
drunken	12	26	371	3	drunken
drupe	8	50	1299	3	dru_pe_
drupes	9	49	1265	3	dru_pes
druse	6	48	1766	3	dru_se_
druses	7	55	1725	3	dru_ses
druthers	12	7	579	3	druthers
dryer	9	51	1146	3	dr__yer
dubber	11	38	1455	3	d_ubber
ducker	13	43	1799	3	d_ucker
dueler	7	42	1368	3	d_ueler
duffer	13	47	1166	3	d_uffer
duiker	11	41	1059	3	d_uiker
duller	7	40	1770	3	d_uller
dumbed	12	40	1208	3	d_umbed
dummied	13	34	672	3	d_ummied
dummies	12	30	1213	3	d_ummies
dummy	13	47	1278	3	d_umm_y
dumped	12	38	1449	3	d_umped
dumpers	12	34	1266	3	d_umpers
dumpier	12	40	965	3	d_umpier
dunker	11	36	1646	3	d_unker
dunner	7	39	1382	3	d_unner
duper	8	55	1900	3	d_u_per
duramen	10	9	690	3	duramen
duster	7	49	1972	3	d_uster
duumvir	13	4	119	3	duumvir
emmer	9	43	1446	3	__emmer
flummery	18	3	305	3	flummery
framer	11	48	1744	3	fr_amer
fruiter	10	30	968	3	fruiter
frumpier	15	3	417	3	frumpier
fumer	10	59	1823	3	_fu_mer
fumier	11	3	1090	3	_fumier
gammer	11	123	1833	3	_gammer
glimmer	12	43	771	3	glimmer
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
gummed	12	38	1166	3	_gummed
gummers	12	37	1219	3	_gummers
gummier	12	34	947	3	_gummier
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
krimmers	16	31	567	3	krimmers
kruller	11	4	515	3	kruller
kummel	14	26	617	3	_kummel
limmer	10	43	1479	3	_limmer
lumber	10	38	1777	3	_lumber
lumper	10	38	1665	3	_lumper
mammer	9	42	1886	3	_mammer
midsummer	13	4	129	3	midsummer
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
ormer	7	52	1837	3	or__mer
plumber	13	33	998	3	plumber
plumier	11	35	1004	3	plumier
plummet	13	27	835	3	plummet
plummier	14	3	412	3	plummier
plumper	13	31	877	3	plumper
premier	11	35	1563	3	premier
primer	10	51	1868	3	pr_imer
primmed	14	38	885	3	primmed
pruner	8	34	1345	3	pru_ner
pummel	12	27	804	3	_pummel
pumper	12	44	1555	3	_pumper
rammed	11	31	1730	3	_rammed
rammers	11	37	1504	3	_rammers
rammier	11	28	1102	3	_rammier
reamer	8	43	2521	3	_reamer
rhymer	14	38	708	3	_rhymer
rimer	7	54	2924	3	_r_imer
rimier	8	39	1626	3	_rimier
rimmed	11	48	1230	3	_rimmed
rimmers	11	38	1288	3	_rimmers
roamer	8	47	1516	3	_roamer
romper	10	42	1368	3	_romper
roomer	8	47	1863	3	_roomer
rubber	10	47	1579	3	_rubber
rubier	8	48	1473	3	_rubier
rudder	8	38	1280	3	_rudder
ruder	6	53	2054	3	_ru_der
ruer	4	61	2756	3	_ru__er
rugger	8	44	1451	3	_rugger
ruiner	6	40	1364	3	_ruiner
ruler	5	49	2334	3	_ru_ler
rulier	6	50	1635	3	_rulier
rumbler	11	35	1411	3	_rumbler
rumen	7	44	1950	3	_ru_men
rummager	13	4	359	3	_rummager
rummest	11	27	983	3	_rummest
rummies	11	32	1279	3	_rummies
rummy	12	42	1241	3	_rumm_y
rumor	7	10	1132	3	_ru_mor
rumour	8	12	737	3	_rumour
runner	6	38	1446	3	_runner
rusher	9	40	1965	3	_rusher
scammer	13	36	1197	3	scammer
scrummed	15	5	431	3	scrummed
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
slammer	11	39	1303	3	slammer
slimmer	11	42	1134	3	slimmer
slumber	11	38	1100	3	slumber
slummed	12	35	927	3	slummed
slummers	12	35	893	3	slummers
slummier	12	3	547	3	slummier
spammer	13	34	1043	3	spammer
spumier	11	3	790	3	spumier
stammer	11	60	1334	3	stammer
stemmer	11	32	1018	3	stemmer
strummed	13	4	447	3	strummed
strummers	13	3	369	3	strummers
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
thrummed	16	4	284	3	thrummed
thrummers	16	4	241	3	thrummers
thrummier	16	4	179	3	thrummier
thumper	14	35	695	3	thumper
trammed	12	38	1071	3	trammed
trammel	11	35	766	3	trammel
tramper	11	38	1215	3	tramper
trimer	8	57	1715	3	tr_imer
trimmed	12	34	893	3	trimmed
trimmers	12	28	891	3	trimmers
trommel	11	31	536	3	trommel
trucker	13	40	1073	3	trucker
trudger	9	33	872	3	trudger
truer	5	49	1664	3	tru__er
trumped	12	43	971	3	trumped
trumpery	15	3	361	3	trumpery
trumpet	11	38	1072	3	trumpet
trusser	7	40	1025	3	trusser
truster	7	31	1431	3	truster
tummler	11	26	661	3	_tummler
umber	9	46	1758	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.156	1145455.1
2	DLD Change Limit	134027	315	6.220	21547.7
3	Display Results	315	315	0.106	2971.7
	(SQL Overall)	178691	315	6.482	27567.3