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

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

101 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
bumper	12	37	1434	(None)
bummer	12	40	1410	1	bummer
bumped	13	44	1400	1	bumped
bumpers	13	39	1205	1	bumpers
bumpier	13	35	920	1	bumpier
dumper	11	46	1521	1	dumper
humper	13	41	1588	1	humper
jumper	17	36	1237	1	jumper
lumper	10	38	1665	1	lumper
mumper	12	35	1352	1	mumper
pumper	12	44	1555	1	pumper
beeper	10	37	1409	2	beeper
bomber	12	50	1465	2	bomber
bopper	12	38	1383	2	bopper
bucker	14	54	2046	2	bucker
budder	10	43	1481	2	budder
budger	10	46	1771	2	budger
buffer	14	45	1268	2	buffer
bugger	10	44	1872	2	bugger
bugler	9	47	1772	2	bugler
bulger	9	49	1735	2	bulger
bumbler	13	40	1323	2	bumbler
bummed	13	42	1172	2	bummed
bummers	13	37	1244	2	bummers
bump	10	62	2824	2	bump__
bumpered	15	3	600	2	bumpered
bumph	14	49	1198	2	bump_h
bumphs	15	46	710	2	bumphs
bumps	11	59	2114	2	bump_s
bumpy	14	47	1505	2	bump_y
bunker	12	45	1937	2	bunker
bunter	8	50	2038	2	bunter
burger	9	40	2079	2	burger
burier	8	43	2465	2	burier
burker	12	52	2117	2	burker
burler	8	47	2383	2	burler
burner	8	38	1920	2	burner
burped	11	62	1550	2	burped
burrer	8	37	1847	2	burrer
busher	11	49	2220	2	busher
busier	8	52	1972	2	busier
busker	12	55	1783	2	busker
buster	8	47	2649	2	buster
butler	8	42	2003	2	butler
butter	8	47	2423	2	butter
buyer	10	50	1309	2	bu_yer
buzzer	16	37	911	2	buzzer
camper	12	47	2221	2	camper
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
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
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	1137	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
thumper	14	35	695	2	thumper
tumped	11	42	1623	2	tumped
umber	9	46	1759	2	_umber
umped	10	47	1727	2	_umped
upper	9	37	1426	2	_upper
vamper	13	42	1265	2	vamper

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.330	541487.9
2	DLD Change Limit	82551	101	2.406	34310.5
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	2.766	64602.7