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

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

85 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
boffed	15	36	948	(None)
baffed	15	48	1217	1	baffed
biffed	15	44	988	1	biffed
buffed	15	43	1314	1	buffed
doffed	14	42	850	1	doffed
offed	12	35	916	1	_offed
baffled	16	41	806	2	baffled
barfed	12	54	1638	2	barfed
beefed	12	35	1087	2	beefed
bluffed	16	32	643	2	bluffed
boated	9	42	2197	2	boated
bobbed	10	43	1583	2	bobbed
boded	9	51	2496	2	bo_ded
bodied	10	38	1458	2	bodied
boff	12	47	2733	2	boff__
boffin	14	35	905	2	boffin
boffo	13	60	1037	2	boff_o
boffos	14	56	819	2	boffos
boffs	13	49	1550	2	boff_s
bogged	11	60	1928	2	bogged
boiled	9	50	2095	2	boiled
bolled	9	47	2265	2	bolled
bolted	9	46	1780	2	bolted
bombed	13	41	1387	2	bombed
bonded	10	47	1995	2	bonded
boned	8	51	3324	2	bo_ned
bonged	10	57	1960	2	bonged
bonked	13	55	1731	2	bonked
boobed	11	45	1487	2	boobed
booed	8	51	2727	2	bo_oed
booked	13	53	1950	2	booked
boomed	11	53	1813	2	boomed
booted	9	48	2273	2	booted
boozed	18	48	1383	2	boozed
bopped	13	44	1340	2	bopped
bored	8	50	3430	2	bo_red
borked	13	51	1729	2	borked
bossed	9	48	1653	2	bossed
bouffe	14	43	831	2	bouffe_
bouffes	15	38	863	2	bouffes
boused	9	53	2288	2	boused
bowed	11	45	3342	2	bo_wed
bowled	12	50	1814	2	bowled
bowsed	12	57	1597	2	bowsed
boxed	15	43	1861	2	bo_xed
buffer	14	45	1268	2	buffer
buffet	14	31	1378	2	buffet
coffee	14	41	1374	2	coffee
coffer	14	41	1286	2	coffer
coffled	16	29	736	2	coffled
coifed	12	41	1306	2	coifed
coiffed	16	3	541	2	coiffed
cuffed	15	43	1121	2	cuffed
daffed	14	42	949	2	daffed
doffer	13	39	1135	2	doffer
feoffed	13	3	281	2	feoffed
gaffed	14	42	1020	2	gaffed
goffer	13	40	951	2	goffer
golfed	11	56	976	2	golfed
goofed	11	49	1138	2	goofed
hoofed	13	46	1489	2	hoofed
huffed	16	37	1015	2	huffed
loafed	10	40	1115	2	loafed
lofted	10	38	1189	2	lofted
luffed	13	38	1082	2	luffed
miffed	15	39	871	2	miffed
muffed	15	42	1059	2	muffed
naffed	13	40	833	2	naffed
offend	13	36	566	2	_offend
offer	11	43	1138	2	_offer
poufed	12	44	971	2	poufed
pouffed	16	36	595	2	pouffed
puffed	15	35	1060	2	puffed
reffed	13	47	1251	2	reffed
riffed	13	38	1156	2	riffed
rolfed	10	45	1052	2	rolfed
roofed	10	52	1474	2	roofed
ruffed	13	43	1274	2	ruffed
scoffed	16	26	618	2	scoffed
tiffed	13	36	839	2	tiffed
toffee	12	33	1101	2	toffee
waffed	16	45	979	2	waffed
wolfed	13	42	801	2	wolfed
woofed	13	45	1120	2	woofed
yaffed	16	45	732	2	yaffed

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.343	520965.0
2	DLD Change Limit	82551	85	3.220	25637.0
3	Display Results	85	85	0.013	6538.5
	(SQL Overall)	178691	85	3.576	49969.5