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

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

111 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
humped	14	40	1524	(None)
bumped	13	44	1400	1	bumped
chumped	17	37	949	1	chumped
dumped	12	38	1449	1	dumped
hummed	14	48	1267	1	hummed
humper	13	41	1588	1	humper
humphed	18	3	542	1	humphed
jumped	18	35	1155	1	jumped
lumped	11	42	1696	1	lumped
mumped	13	38	1316	1	mumped
pumped	13	39	1556	1	pumped
thumped	15	38	741	1	thumped
tumped	11	42	1623	1	tumped
umped	10	47	1727	1	_umped
whumped	18	33	563	1	whumped
amped	10	48	2051	2	_amped
bummed	13	42	1172	2	bummed
bumper	12	37	1434	2	bumper
burped	11	62	1550	2	burped
camped	13	47	2023	2	camped
champed	17	41	1148	2	champed
chomped	17	32	977	2	chomped
chummed	17	39	644	2	chummed
clumped	14	36	1066	2	clumped
comped	13	59	1987	2	comped
crumped	14	43	1122	2	crumped
cupped	13	44	1398	2	cupped
cusped	11	43	1204	2	cusped
damped	12	43	1558	2	damped
dumbed	12	40	1208	2	dumbed
dumper	11	46	1521	2	dumper
duped	9	51	1832	2	du_ped
dupped	12	44	1164	2	dupped
flumped	15	37	771	2	flumped
fumed	11	61	1882	2	fum_ed
gimped	12	39	1147	2	gimped
grumped	13	33	733	2	grumped
gulped	10	46	1037	2	gulped
gummed	12	38	1166	2	gummed
hammed	14	41	1697	2	hammed
hamper	13	45	1865	2	hamper
happed	14	48	2010	2	happed
harped	12	44	1840	2	harped
hasped	12	50	1444	2	hasped
heaped	12	45	1690	2	heaped
helped	12	47	1415	2	helped
hemmed	14	42	1146	2	hemmed
hempen	13	3	896	2	hempen
hipped	14	43	1769	2	hipped
homed	11	54	2542	2	hom_ed
hooped	12	55	1818	2	hooped
hoped	11	56	2818	2	h_oped
hopped	14	43	1811	2	hopped
hued	8	69	2585	2	hu__ed
huffed	16	37	1015	2	huffed
hugged	12	41	1364	2	hugged
hulked	14	46	1130	2	hulked
hulled	10	39	2001	2	hulled
humbled	15	37	1181	2	humbled
humid	11	42	1376	2	hum_id
hummer	13	36	1527	2	hummer
humored	13	3	672	2	humored
hump	11	62	2872	2	hump__
humpers	14	27	1352	2	humpers
humph	15	57	1221	2	hump_h
humphs	16	52	816	2	humphs
humpier	14	31	1072	2	humpier
humps	12	63	2280	2	hump_s
humpy	15	51	1567	2	hump_y
humvee	14	3	920	2	humvee
hunted	10	44	1701	2	hunted
hurled	10	46	1745	2	hurled
hushed	13	44	1667	2	hushed
husked	14	42	1222	2	husked
hutted	10	46	1633	2	hutted
hymned	15	3	532	2	hymned
hyped	14	53	1333	2	h_yped
imped	10	51	1798	2	_imped
jumper	17	36	1237	2	jumper
lamped	11	40	1754	2	lamped
limped	11	48	1712	2	limped
lumpen	10	40	1066	2	lumpen
lumper	10	38	1665	2	lumper
mummed	10	44	1155	2	mummed
mumper	12	35	1352	2	mumper
numbed	11	41	1144	2	numbed
pimped	13	49	1348	2	pimped
plumped	14	31	864	2	plumped
pulped	11	46	1253	2	pulped
pumper	12	44	1555	2	pumper
pupped	10	50	1327	2	pupped
ramped	11	46	1790	2	ramped
romped	11	45	1365	2	romped
rumpled	12	38	1001	2	rumpled
shlumped	16	4	344	2	shlumped
slumped	12	37	1015	2	slumped
stumped	12	42	1015	2	stumped
summed	11	40	1404	2	summed
supped	11	44	1570	2	supped
tamped	11	43	1704	2	tamped
temped	11	39	1289	2	temped
thumbed	15	33	617	2	thumbed
thumper	14	35	695	2	thumper
trumped	12	43	971	2	trumped
tupped	11	40	1323	2	tupped
upped	10	37	1516	2	_upped
urped	8	46	1528	2	_urped
vamped	14	42	1101	2	vamped
whomped	18	34	547	2	whomped
whupped	18	36	541	2	whupped
wimped	14	42	1151	2	wimped

Search took 3 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.356	501941.0
2	DLD Change Limit	82551	111	2.453	33653.1
3	Display Results	111	111	0.030	3700.0
	(SQL Overall)	178691	111	2.839	62941.5