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

Here are the results of your fuzzy-string dictionary search for “humper” 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
humper	13	41	1588	(None)
bumper	12	37	1434	1	bumper
dumper	11	46	1521	1	dumper
hamper	13	45	1865	1	hamper
hummer	13	36	1527	1	hummer
humped	14	40	1524	1	humped
humpers	14	27	1352	1	humpers
humpier	14	31	1072	1	humpier
jumper	17	36	1237	1	jumper
lumper	10	38	1665	1	lumper
mumper	12	35	1352	1	mumper
pumper	12	44	1555	1	pumper
thumper	14	35	695	1	thumper
bummer	12	40	1410	2	bummer
bumped	13	44	1400	2	bumped
bumpers	13	39	1205	2	bumpers
bumpier	13	35	920	2	bumpier
camper	12	47	2221	2	camper
champer	16	38	1340	2	champer
chomper	16	38	1007	2	chomper
chumped	17	37	949	2	chumped
cumber	12	40	1670	2	cumber
cummer	12	44	1459	2	cummer
cupper	12	43	1386	2	cupper
damper	11	41	1775	2	damper
dumber	11	44	1417	2	dumber
dumped	12	38	1449	2	dumped
dumpers	12	34	1266	2	dumpers
dumpier	12	40	965	2	dumpier
duper	8	55	1900	2	du_per
fumer	10	59	1823	2	fum_er
fumier	11	3	1090	2	fumier
gulper	9	34	1021	2	gulper
gummer	11	46	1545	2	gummer
hammer	13	81	2003	2	hammer
hampers	14	36	1694	2	hampers
harper	11	50	1840	2	harper
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
huger	9	49	1487	2	hu_ger
hugger	11	47	1312	2	hugger
huller	9	39	1910	2	huller
humaner	12	25	766	2	humaner
humbler	14	34	1194	2	humbler
humeri	11	3	852	2	hum_eri
hummed	14	48	1267	2	hummed
hummers	14	38	1306	2	hummers
humor	10	11	1051	2	hum_or
humour	11	11	675	2	humour
hump	11	62	2872	2	hump__
humph	15	57	1221	2	hump_h
humphed	18	3	542	2	humphed
humphs	16	52	816	2	humphs
humps	12	63	2280	2	hump_s
humpy	15	51	1567	2	hump_y
humvee	14	3	920	2	humvee
hunger	10	40	1520	2	hunger
hunker	13	39	1767	2	hunker
hunter	9	48	1777	2	hunter
hurler	9	47	1722	2	hurler
hurter	9	39	1585	2	hurter
husker	13	42	1270	2	husker
hyper	13	52	1390	2	h_yper
jimper	17	38	986	2	jimper
jumped	18	35	1155	2	jumped
jumpers	18	39	984	2	jumpers
jumpier	18	31	794	2	jumpier
limper	10	41	1785	2	limper
lumber	10	38	1777	2	lumber
lumped	11	42	1696	2	lumped
lumpen	10	40	1066	2	lumpen
lumpers	11	35	1448	2	lumpers
lumpier	11	34	1014	2	lumpier
mummer	9	36	1454	2	mummer
mumped	13	38	1316	2	mumped
mumpers	13	33	1136	2	mumpers
number	10	39	1322	2	number
pamper	12	43	1666	2	pamper
plumper	13	31	877	2	plumper
pulper	10	35	1327	2	pulper
pumped	13	39	1556	2	pumped
pumpers	13	31	1367	2	pumpers
romper	10	42	1368	2	romper
rummer	10	47	1548	2	rummer
simper	10	36	1629	2	simper
stumper	11	36	1009	2	stumper
summer	10	40	1771	2	summer
sumpter	11	3	887	2	sumpter
super	7	49	2448	2	su_per
supper	10	41	1543	2	supper
tamper	10	46	1851	2	tamper
temper	10	39	1409	2	temper
thumped	15	38	741	2	thumped
thumpers	15	36	571	2	thumpers
tumped	11	42	1623	2	tumped
umber	9	46	1758	2	_umber
umped	10	47	1727	2	_umped
upper	9	37	1426	2	_upper
vamper	13	42	1265	2	vamper
whimper	17	29	772	2	whimper
whumped	18	33	563	2	whumped

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.126	1418182.5
2	DLD Change Limit	82551	111	3.606	22892.7
3	Display Results	111	111	0.063	1761.9
	(SQL Overall)	178691	111	3.795	47085.9