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

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

314 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
thumper	14	35	695	(None)
humper	13	41	1588	1	_humper
thumped	15	38	741	1	thumped
thumpers	15	36	571	1	thumpers
bumper	12	37	1434	2	_bumper
champer	16	38	1341	2	champer
chomper	16	38	1007	2	chomper
chumped	17	37	949	2	chumped
dumper	11	46	1521	2	_dumper
hamper	13	45	1865	2	_hamper
hummer	13	36	1527	2	_hummer
humped	14	40	1524	2	_humped
humpers	14	27	1352	2	_humpers
humpier	14	31	1072	2	_humpier
jumper	17	36	1237	2	_jumper
lumper	10	38	1665	2	_lumper
mumper	12	35	1352	2	_mumper
plumper	13	31	877	2	plumper
pumper	12	44	1555	2	_pumper
stumper	11	36	1009	2	stumper
tamper	10	46	1851	2	t_amper
temper	10	39	1409	2	t_emper
thrummer	15	4	293	2	thrummer
thumbed	15	33	617	2	thumbed
thump	12	62	1157	2	thump__
thumps	13	44	935	2	thump_s
thunder	11	3	696	2	thunder
thymier	15	3	439	2	thymier
tramper	11	38	1216	2	tramper
trumped	12	43	971	2	trumped
trumpery	15	3	361	2	trumpery
trumpet	11	38	1072	2	trumpet
tumped	11	42	1623	2	t_umped
whimper	17	29	772	2	whimper
whumped	18	33	563	2	whumped
attemper	12	10	363	3	attemper
bethumped	19	4	149	3	bethumped
bummer	12	40	1410	3	_bummer
bumped	13	44	1400	3	_bumped
bumpers	13	39	1205	3	_bumpers
bumpier	13	35	920	3	_bumpier
camper	12	47	2221	3	_camper
chamber	16	40	1106	3	chamber
chamfer	17	39	986	3	chamfer
champed	17	41	1148	3	champed
champers	17	33	1162	3	champers
cheaper	14	40	1058	3	cheaper
cheeper	14	36	1074	3	cheeper
chimer	13	55	1720	3	chim_er
chipper	16	39	1258	3	chipper
chirper	14	35	996	3	chirper
chomped	17	32	977	3	chomped
chompers	17	36	959	3	chompers
chopper	16	36	1189	3	chopper
chudder	14	24	594	3	chudder
chuffer	18	33	714	3	chuffer
chugger	14	4	537	3	chugger
chukker	15	4	383	3	chukker
chummed	17	39	644	3	chummed
chummier	17	3	451	3	chummier
chump	14	53	1544	3	chump__
chumps	15	43	1382	3	chump_s
chunter	12	39	1148	3	chunter
churner	12	29	834	3	churner
clamper	13	40	1299	3	clamper
clumber	13	40	1144	3	clumber
clumped	14	36	1066	3	clumped
clumpier	14	3	558	3	clumpier
crimper	13	65	1042	3	crimper
crumber	13	33	964	3	crumber
crumped	14	43	1122	3	crumped
crumpet	13	37	1106	3	crumpet
crupper	13	33	856	3	crupper
cumber	12	40	1670	3	_cumber
cummer	12	44	1459	3	_cummer
cupper	12	43	1386	3	_cupper
damper	11	41	1775	3	_damper
drummer	12	40	750	3	drummer
dumber	11	44	1417	3	_dumber
dumped	12	38	1449	3	_dumped
dumpers	12	34	1266	3	_dumpers
dumpier	12	40	965	3	_dumpier
duper	8	55	1900	3	_du_per
exhumer	19	4	346	3	exhum_er
flumped	15	37	771	3	flumped
frumpier	15	3	417	3	frumpier
fumer	10	59	1823	3	_fum_er
fumier	11	3	1090	3	_fumier
gazumper	22	4	146	3	gazumper
glummer	12	41	798	3	glummer
glumpier	13	3	487	3	glumpier
grummer	12	33	878	3	grummer
grumped	13	33	733	3	grumped
grumpier	13	3	480	3	grumpier
gulper	9	34	1021	3	_gulper
gummer	11	46	1545	3	_gummer
hammer	13	81	2003	3	_hammer
hampers	14	36	1695	3	_hampers
harper	11	50	1840	3	_harper
heaper	11	41	1952	3	_heaper
helper	11	43	1309	3	_helper
hemmer	13	41	1264	3	_hemmer
hempen	13	3	896	3	_hempen
hempier	14	31	900	3	_hempier
hepper	13	34	1266	3	_hepper
hipper	13	38	1802	3	_hipper
homer	10	58	2845	3	_hom_er
homier	11	64	1699	3	_homier
hooper	11	45	1831	3	_hooper
hoper	10	58	2914	3	_h_oper
hopper	13	42	1848	3	_hopper
huger	9	49	1487	3	_hu_ger
hugger	11	47	1312	3	_hugger
huller	9	39	1910	3	_huller
humaner	12	25	766	3	_humaner
humbler	14	34	1194	3	_humbler
humeri	11	3	852	3	_hum_eri
hummed	14	48	1267	3	_hummed
hummers	14	38	1306	3	_hummers
humor	10	11	1051	3	_hum_or
humour	11	11	675	3	_humour
hump	11	62	2872	3	_hump__
humph	15	57	1221	3	_hump_h
humphed	18	3	542	3	_humphed
humphs	16	52	816	3	_humphs
humps	12	63	2280	3	_hump_s
humpy	15	51	1567	3	_hump_y
humvee	14	3	920	3	_humvee
hunger	10	40	1520	3	_hunger
hunker	13	39	1767	3	_hunker
hunter	9	48	1777	3	_hunter
hurler	9	47	1722	3	_hurler
hurter	9	39	1585	3	_hurter
husker	13	42	1270	3	_husker
hyper	13	52	1390	3	_h_yper
inhumer	12	7	538	3	inhum_er
jimper	17	38	986	3	_jimper
jumped	18	35	1155	3	_jumped
jumpers	18	39	984	3	_jumpers
jumpier	18	31	794	3	_jumpier
limper	10	41	1785	3	_limper
lumber	10	38	1777	3	_lumber
lumped	11	42	1696	3	_lumped
lumpen	10	40	1066	3	_lumpen
lumpers	11	35	1448	3	_lumpers
lumpier	11	34	1014	3	_lumpier
mummer	9	36	1454	3	_mummer
mumped	13	38	1316	3	_mumped
mumpers	13	33	1137	3	_mumpers
number	10	39	1322	3	_number
pamper	12	43	1666	3	_pamper
pauper	10	35	1194	3	pau_per
plumber	13	33	998	3	plumber
plumier	11	35	1004	3	plumier
plummer	13	29	852	3	plummer
plumped	14	31	864	3	plumped
plumpen	13	27	640	3	plumpen
plumpers	14	35	729	3	plumpers
pulper	10	35	1327	3	_pulper
pumped	13	39	1556	3	_pumped
pumpers	13	31	1367	3	_pumpers
rheumier	13	4	251	3	rheumier
rhymer	14	38	708	3	rhym_er
romper	10	42	1368	3	_romper
rummer	10	47	1548	3	_rummer
scamper	13	46	1316	3	scamper
scummer	13	39	875	3	scummer
scupper	13	6	742	3	scupper
shammer	14	46	1314	3	shammer
shaper	11	41	1993	3	sh_aper
sharper	12	43	1270	3	sharper
shimmer	14	33	1087	3	shimmer
shipper	14	35	1404	3	shipper
shlumped	16	4	344	3	shlumped
shopper	14	33	1263	3	shopper
shrimper	15	4	441	3	shrimper
shucker	16	37	1010	3	shucker
shudder	12	29	732	3	shudder
shunner	10	35	864	3	shunner
shunter	10	36	1173	3	shunter
shusher	13	28	811	3	shusher
shutter	10	37	1214	3	shutter
simper	10	36	1629	3	_simper
slumber	11	38	1100	3	slumber
slummer	11	37	1120	3	slummer
slumped	12	37	1015	3	slumped
spumier	11	3	790	3	spumier
stamper	11	37	1440	3	stamper
stomper	11	41	1123	3	stomper
strummer	12	3	478	3	strummer
strumpet	12	5	603	3	strumpet
stumped	12	42	1015	3	stumped
stumpers	12	31	831	3	stumpers
stumpier	12	5	588	3	stumpier
summer	10	40	1771	3	_summer
sumpter	11	3	887	3	_sumpter
super	7	49	2448	3	_su_per
supper	10	41	1543	3	_supper
swamper	14	34	931	3	swamper
tamer	7	52	3010	3	t_am_er
tamped	11	43	1704	3	t_amped
tampers	11	35	1674	3	t_ampers
taper	7	48	2977	3	t__aper
tapper	10	44	1961	3	t_apper
taunter	7	31	1145	3	taunter
taupe	7	3	1416	3	tau_pe_
taupes	8	2	1267	3	tau_pes
tauter	6	43	1802	3	tau_ter
teemer	8	55	1574	3	teem_er
temped	11	39	1289	3	t_emped
tempeh	13	35	746	3	t_empeh
tempera	11	32	904	3	t_empera
tempers	11	35	1301	3	t_empers
tempter	11	35	821	3	t_empter
termer	8	57	1725	3	term_er
thaler	9	46	1310	3	th_aler
thanker	14	30	959	3	thanker
thawer	12	48	934	3	th_awer
theater	10	40	1425	3	theater
theme	10	59	2173	3	them_e_
themed	12	59	1258	3	them_ed
themes	11	53	1925	3	them_es
thewier	13	3	606	3	thewier
thicker	16	36	1102	3	thicker
thinker	14	36	1068	3	thinker
thinner	10	35	897	3	thinner
thither	13	32	810	3	thither
thorpe	11	36	1009	3	thorpe_
thorpes	12	50	1035	3	thorpes
threaper	13	4	514	3	threaper
thriver	13	47	912	3	thriver
thrower	13	8	699	3	thrower
thrummed	16	4	284	3	thrummed
thrummers	16	4	241	3	thrummers
thrummier	16	4	179	3	thrummier
thruster	11	3	579	3	thruster
thudded	13	3	343	3	thudded
thuggee	12	4	526	3	thuggee
thuggery	16	4	256	3	thuggery
thumb	12	45	1128	3	thum__b
thumbs	13	37	744	3	thum_bs
thumping	16	29	671	3	thumping
thunders	12	3	695	3	thunders
thundery	15	3	382	3	thundery
thunked	15	38	685	3	thunked
thurifer	14	4	327	3	thurifer
thyme	13	46	1247	3	thym_e_
thymes	14	48	1074	3	thym_es
thymey	17	42	631	3	thym_ey
timber	10	40	1268	3	t_imber
timer	7	56	2604	3	t_im_er
tipper	10	39	1841	3	t_ipper
toper	7	52	3102	3	t__oper
topper	10	38	1760	3	t_opper
toucher	12	48	1435	3	toucher
tougher	11	42	1098	3	tougher
toupee	8	3	1613	3	tou_pee
tourer	6	41	1507	3	tou_rer
touter	6	38	2103	3	tou_ter
tramped	12	43	1243	3	tramped
trampers	12	32	1039	3	trampers
trampier	12	31	824	3	trampier
trampler	12	27	801	3	trampler
trapper	11	39	1280	3	trapper
trimer	8	57	1715	3	trim_er
trimmer	11	36	1083	3	trimmer
tripper	11	37	1192	3	tripper
trompe	10	56	1126	3	trompe_
tromped	12	42	1029	3	tromped
trompes	11	41	1162	3	trompes
trooper	9	42	1036	3	trooper
trouper	9	38	1143	3	trouper
trucker	13	40	1073	3	trucker
trudger	9	33	873	3	trudger
truer	5	49	1664	3	tru__er
trump	9	56	1512	3	trump__
trumpeter	13	4	315	3	trumpeter
trumpets	12	31	557	3	trumpets
trumps	10	46	1188	3	trump_s
trusser	7	40	1026	3	trusser
truster	7	31	1431	3	truster
tubber	10	43	1320	3	t_ubber
tuber	7	54	2068	3	t_u_ber
tucker	12	43	1695	3	t_ucker
tufter	9	31	993	3	t_ufter
tugger	8	40	1310	3	t_ugger
tumbler	11	34	1282	3	t_umbler
tummler	11	26	661	3	tummler
tumor	7	11	1069	3	t_um_or
tumour	8	13	740	3	t_umour
tump	8	59	2703	3	t_ump__
tumps	9	54	2079	3	t_ump_s
tuner	5	60	2268	3	t_u_ner
tupped	11	40	1323	3	t_upped
turner	6	39	1461	3	t_urner
tusker	10	42	1219	3	t_usker
tusser	6	46	1583	3	t_usser
tuyer	8	54	1429	3	t_u_yer
umber	9	46	1759	3	__umber
umped	10	47	1727	3	__umped
upper	9	37	1426	3	__upper
usurper	9	3	435	3	usurper
vamper	13	42	1265	3	_vamper
whapper	17	34	827	3	whapper
whimpers	18	27	661	3	whimpers
whipper	17	36	1138	3	whipper
whisper	15	29	801	3	whisper
whomped	18	34	547	3	whomped
whooper	15	29	715	3	whooper
whopper	17	32	850	3	whopper
whump	15	49	1004	3	whump__
whumps	16	42	709	3	whump_s
whupped	18	36	541	3	whupped
yauper	11	36	854	3	yau_per

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	314	6.436	20824.6
3	Display Results	314	314	0.110	2854.5
	(SQL Overall)	178691	314	6.952	25703.5