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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

81 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
bumpers	13	39	1205	(None)
bummers	13	37	1244	1	bummers
bumper	12	37	1434	1	bumper_
dumpers	12	34	1266	1	dumpers
humpers	14	27	1352	1	humpers
jumpers	18	39	984	1	jumpers
lumpers	11	35	1448	1	lumpers
mumpers	13	33	1137	1	mumpers
pumpers	13	31	1367	1	pumpers
beepers	11	36	1238	2	beepers
bombers	13	45	1259	2	bombers
boppers	13	39	1192	2	boppers
buckers	15	35	1745	2	buckers
budders	11	38	1210	2	budders
budgers	11	43	1492	2	budgers
buffers	15	33	1079	2	buffers
buggers	11	43	1566	2	buggers
buglers	10	51	1532	2	buglers
bulgers	10	52	1514	2	bulgers
bumblers	14	37	1073	2	bumblers
bummer	12	40	1410	2	bummer_
bumped	13	44	1400	2	bumpe_d
bumpered	15	3	600	2	bumpered
bumphs	15	46	710	2	bump_hs
bumpier	13	35	920	2	bumpier_
bumps	11	59	2114	2	bump__s
bunkers	13	37	1595	2	bunkers
bunters	9	47	1712	2	bunters
burgers	10	39	1857	2	burgers
buriers	9	40	1719	2	buriers
burkers	13	37	1662	2	burkers
burlers	9	41	2027	2	burlers
burners	9	41	1567	2	burners
burrers	9	38	1449	2	burrers
bushers	12	40	1880	2	bushers
buskers	13	34	1409	2	buskers
busters	9	47	2413	2	busters
butlers	9	45	1805	2	butlers
butters	9	45	2172	2	butters
buyers	11	45	1100	2	bu_yers
buzzers	17	34	717	2	buzzers
campers	13	42	2029	2	campers
cumbers	13	45	1541	2	cumbers
cummers	13	37	1348	2	cummers
cuppers	13	37	1221	2	cuppers
dampers	12	39	1569	2	dampers
dumper	11	46	1521	2	dumper_
dupers	9	46	1560	2	du_pers
fumers	11	36	1338	2	fum_ers
gulpers	10	29	901	2	gulpers
gummers	12	37	1220	2	gummers
hampers	14	36	1695	2	hampers
hummers	14	38	1306	2	hummers
humper	13	41	1588	2	humper_
jumper	17	36	1237	2	jumper_
lampers	11	38	1733	2	lampers
limpers	11	38	1522	2	limpers
lumbers	11	38	1591	2	lumbers
lumpens	11	29	826	2	lumpens
lumper	10	38	1665	2	lumper_
mummers	10	37	1284	2	mummers
mumper	12	35	1352	2	mumper_
numbers	11	37	1124	2	numbers
pampers	13	36	1593	2	pampers
plumpers	14	35	729	2	plumpers
pulpers	11	46	1228	2	pulpers
pumper	12	44	1555	2	pumper_
rompers	11	34	1224	2	rompers
rummers	11	35	1365	2	rummers
simpers	11	30	1412	2	simpers
stumpers	12	31	831	2	stumpers
summers	11	36	1650	2	summers
sumpters	12	3	802	2	sumpters
supers	8	46	2240	2	su_pers
suppers	11	33	1470	2	suppers
tampers	11	35	1674	2	tampers
tempers	11	35	1301	2	tempers
thumpers	15	36	571	2	thumpers
umbers	10	42	1521	2	_umbers
uppers	10	29	1229	2	_uppers
vampers	14	31	1162	2	vampers

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	107671	0.373	479064.3
2	DLD Change Limit	107671	81	2.923	36835.8
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	3.326	53725.5