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

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

47 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
goffers	14	40	921	(None)
coffers	15	41	1269	1	coffers
doffers	14	35	985	1	doffers
gaffers	14	42	871	1	gaffers
gofers	10	47	1151	1	go_fers
goffer	13	40	951	1	goffer_
golfers	11	44	1008	1	golfers
offers	12	34	996	1	_offers
buffers	15	33	1079	2	buffers
coffees	15	32	957	2	coffees
coffer	14	41	1286	2	coffer_
confers	12	41	2009	2	confers
differs	14	33	997	2	differs
doffer	13	39	1135	2	doffer_
duffers	14	34	1009	2	duffers
feoffers	13	3	313	2	feoffers
gaffer	13	43	1013	2	gaffer_
gaffes	13	48	1110	2	gaffe_s
gauffers	15	6	383	2	gauffers
goers	6	55	2025	2	go__ers
gofer	9	48	1428	2	go_fer_
goffered	16	3	452	2	goffered
goiters	8	40	1444	2	goiters
golfer	10	44	1118	2	golfer_
gomers	9	41	1688	2	go_mers
goners	7	44	2017	2	go_ners
goobers	10	21	962	2	goobers
gophers	13	3	898	2	gophers
gorgers	9	48	1364	2	gorgers
gougers	9	49	1176	2	gougers
hoofers	13	45	1332	2	hoofers
loafers	10	34	946	2	loafers
lofters	10	39	1290	2	lofters
niffers	13	28	736	2	niffers
offer	11	43	1138	2	_offer_
proffers	16	12	659	2	proffers
puffers	15	34	920	2	puffers
reoffers	14	3	469	2	reoffers
rolfers	10	40	1181	2	rolfers
roofers	10	50	1390	2	roofers
scoffers	16	28	613	2	scoffers
suffers	13	31	1354	2	suffers
toffees	13	32	708	2	toffees
troffers	14	12	543	2	troffers
wolfers	13	40	963	2	wolfers
woofers	13	38	1058	2	woofers
zaffers	22	38	677	2	zaffers

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	47	2.813	38276.2
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	3.202	55806.1