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

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

69 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
woofers	13	38	1058	(None)
hoofers	13	45	1332	1	hoofers
roofers	10	50	1390	1	roofers
wolfers	13	40	963	1	wolfers
wooers	9	37	1244	1	woo_ers
woofer	12	44	1136	1	woofer_
woolers	10	42	1402	1	woolers
boogers	10	45	1463	2	boogers
bookers	13	40	1661	2	bookers
boomers	11	41	1591	2	boomers
boozers	18	39	1244	2	boozers
coffers	15	41	1269	2	coffers
confers	12	41	2009	2	confers
cooers	8	43	2456	2	coo_ers
cookers	13	46	1946	2	cookers
coolers	9	35	2249	2	coolers
coopers	11	40	1948	2	coopers
cooters	9	45	2572	2	cooters
doffers	14	35	985	2	doffers
doozers	17	41	929	2	doozers
footers	10	46	1833	2	footers
gofers	10	47	1151	2	_gofers
goffers	14	40	921	2	goffers
golfers	11	44	1008	2	golfers
goobers	10	21	962	2	goobers
hoofer	12	40	1495	2	hoofer_
hookers	14	49	1651	2	hookers
hoopers	12	36	1648	2	hoopers
hooters	10	45	2047	2	hooters
hoovers	13	43	1270	2	hoovers
loafers	10	34	946	2	loafers
lookers	11	40	1407	2	lookers
loopers	9	39	1403	2	loopers
looters	7	44	1916	2	looters
mooners	9	40	1534	2	mooners
mooters	9	38	1862	2	mooters
noosers	7	49	1392	2	noosers
offers	12	34	996	2	_offers
poofters	13	3	692	2	poofters
poolers	9	42	1742	2	poolers
proofers	13	11	836	2	proofers
rolfers	10	40	1181	2	rolfers
roofer	9	44	1528	2	roofer_
roomers	9	54	1641	2	roomers
roosers	7	42	1787	2	roosers
rooters	7	45	2293	2	rooters
sooners	7	39	1664	2	sooners
spoofers	13	30	732	2	spoofers
swooners	11	33	686	2	swooners
swoopers	13	31	752	2	swoopers
toolers	7	44	1650	2	toolers
tooters	7	38	1877	2	tooters
twofers	13	6	405	2	twofers
wafers	12	43	1614	2	w_afers
whoopers	16	28	626	2	whoopers
wolfer	12	42	998	2	wolfer_
wolvers	13	34	931	2	wolvers
wonders	11	33	1599	2	wonders
wonners	10	43	1281	2	wonners
wooer	8	43	1669	2	woo_er_
woofed	13	45	1120	2	woofe_d
woofs	11	49	1800	2	woof__s
woolens	10	39	884	2	woolens
wooler	9	36	1587	2	wooler_
woomera	12	13	577	2	woomera
woomeras	13	13	511	2	woomeras
workers	14	46	1269	2	workers
wormers	12	40	1257	2	wormers
wowsers	13	48	876	2	wowsers

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.390	458182.1
2	DLD Change Limit	107671	69	2.970	36252.9
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	3.390	52711.2