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

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

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

154 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
hamper	13	45	1865	(None)
camper	12	47	2221	1	camper
champer	16	38	1340	1	champer
damper	11	41	1775	1	damper
hammer	13	81	2003	1	hammer
hampers	14	36	1694	1	hampers
harper	11	50	1840	1	harper
humper	13	41	1588	1	humper
pamper	12	43	1666	1	pamper
tamper	10	46	1851	1	tamper
vamper	13	42	1265	1	vamper
amber	9	45	2320	2	_amber
ameer	7	56	1898	2	_ameer
amped	10	48	2051	2	_amped
ampere	10	5	1441	2	_ampere
ampler	10	43	1330	2	_ampler
aper	6	63	3623	2	_a_per
asper	7	55	2043	2	_asper
bumper	12	37	1434	2	bumper
camber	12	44	1847	2	camber
camped	13	47	2023	2	camped
campers	13	42	2028	2	campers
campier	13	33	1327	2	campier
caper	9	48	3162	2	ca_per
capper	12	44	2198	2	capper
carper	10	49	2363	2	carper
chamber	16	40	1105	2	chamber
chamfer	17	39	985	2	chamfer
champed	17	41	1147	2	champed
champers	17	33	1161	2	champers
chomper	16	38	1007	2	chomper
clamper	13	40	1299	2	clamper
dammer	11	43	1793	2	dammer
damner	9	52	1343	2	damner
damped	12	43	1558	2	damped
dampen	11	43	1059	2	dampen
dampers	12	39	1569	2	dampers
dapper	11	40	1663	2	dapper
dumper	11	46	1521	2	dumper
gamer	8	49	2894	2	gam_er
gamier	9	36	1793	2	gamier
gammer	11	123	1833	2	gammer
gaper	8	61	2512	2	ga_per
gasper	9	45	1554	2	gasper
gawper	12	49	969	2	gawper
hacker	15	48	2269	2	hacker
hafter	12	48	1588	2	hafter
hailer	9	47	2034	2	hailer
haler	8	50	3352	2	ha_ler
halter	9	44	2088	2	halter
hame	9	70	4313	2	ham_e_
hames	10	61	3870	2	ham_es
hamlet	11	37	2279	2	hamlet
hammed	14	41	1697	2	hammed
hammers	14	42	1605	2	hammers
hammier	14	35	1065	2	hammier
hampered	16	23	992	2	hampered
hamperer	15	37	909	2	hamperer
hamster	12	8	1042	2	hamster
hanaper	12	3	713	2	hanaper
hander	10	45	2643	2	hander
hanger	10	40	2325	2	hanger
hanker	13	46	2209	2	hanker
happed	14	48	2010	2	happed
happen	13	48	1219	2	happen
happier	14	33	1203	2	happier
harder	10	50	2240	2	harder
harmer	11	47	1955	2	harmer
harped	12	44	1840	2	harped
harpers	12	49	1620	2	harpers
hasped	12	50	1444	2	hasped
hater	8	50	3475	2	ha_ter
hatter	9	47	2487	2	hatter
hauler	9	50	1512	2	hauler
haver	11	51	2446	2	ha_ver
hawker	16	48	1266	2	hawker
hawser	12	59	1084	2	hawser
hayer	11	46	2024	2	ha_yer
hazer	17	48	2023	2	ha_zer
hazier	18	47	1240	2	hazier
heaper	11	41	1952	2	heaper
helper	11	43	1309	2	helper
hemmer	13	41	1264	2	hemmer
hempen	13	3	896	2	hempen
hempier	14	31	900	2	hempier
hepper	13	34	1266	2	hepper
hipper	13	38	1802	2	hipper
homer	10	58	2845	2	hom_er
homier	11	64	1699	2	homier
hooper	11	45	1831	2	hooper
hoper	10	58	2914	2	h_oper
hopper	13	42	1848	2	hopper
hummer	13	36	1527	2	hummer
humped	14	40	1524	2	humped
humpers	14	27	1352	2	humpers
humpier	14	31	1072	2	humpier
hyper	13	52	1390	2	h_yper
jammer	17	40	1413	2	jammer
japer	14	62	1888	2	ja_per
jasper	15	46	1038	2	jasper
jimper	17	38	986	2	jimper
jumper	17	36	1237	2	jumper
lamber	10	44	1849	2	lamber
lamer	7	52	3370	2	lam_er
lamped	11	40	1754	2	lamped
lampers	11	38	1733	2	lampers
lapper	10	43	1995	2	lapper
limper	10	41	1785	2	limper
lumper	10	38	1665	2	lumper
mammer	9	42	1886	2	mammer
mamzer	19	45	983	2	mamzer
mapper	12	45	1609	2	mapper
mumper	12	35	1352	2	mumper
namer	7	56	2210	2	nam_er
napper	10	37	1828	2	napper
pampero	13	32	809	2	pampero
pampers	13	36	1593	2	pampers
paper	9	51	2866	2	pa_per
pauper	10	35	1194	2	pauper
pumper	12	44	1555	2	pumper
rammer	10	35	1965	2	rammer
ramped	11	46	1790	2	ramped
raper	7	49	3275	2	ra_per
rapper	10	46	2157	2	rapper
rasper	8	39	1732	2	rasper
romper	10	42	1368	2	romper
sampler	11	32	1201	2	sampler
sapper	10	38	2235	2	sapper
scamper	13	46	1316	2	scamper
shammer	14	46	1314	2	shammer
shaper	11	41	1993	2	sha_per
sharper	12	43	1270	2	sharper
simper	10	36	1629	2	simper
stamper	11	37	1439	2	stamper
swamper	14	34	931	2	swamper
tamer	7	52	3010	2	tam_er
tamped	11	43	1704	2	tamped
tampers	11	35	1674	2	tampers
taper	7	48	2977	2	ta_per
tapper	10	44	1961	2	tapper
temper	10	39	1409	2	temper
thumper	14	35	695	2	thumper
tramper	11	38	1215	2	tramper
vamped	14	42	1101	2	vamped
vampers	14	31	1162	2	vampers
vampier	14	30	823	2	vampier
warper	11	40	1558	2	warper
whapper	17	34	827	2	whapper
whimper	17	29	772	2	whimper
yammer	13	37	1318	2	yammer
yapper	13	37	1451	2	yapper
yauper	11	36	854	2	yauper
yawper	14	43	795	2	yawper
zapper	19	34	1402	2	zapper

Search took 4 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	82551	0.110	1624463.6
2	DLD Change Limit	82551	154	2.890	28564.4
3	Display Results	154	154	0.063	2444.4
	(SQL Overall)	178691	154	3.063	58338.6