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

Here are the results of your fuzzy-string dictionary search for “offer” 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
offer	11	43	1138	(None)
coffer	14	41	1286	1	coffer
doffer	13	39	1135	1	doffer
goffer	13	40	951	1	goffer
offed	12	35	916	1	offed
offers	12	34	996	1	offers
ofter	8	41	1687	1	ofter
after	8	57	1979	2	after
boffed	15	36	948	2	boffed
buffer	14	45	1268	2	buffer
coffee	14	41	1374	2	coffee
coffers	15	41	1269	2	coffers
confer	11	40	1868	2	confer
defer	9	46	1975	2	defer
deffer	13	44	1130	2	deffer
differ	13	39	1084	2	differ
doffed	14	42	850	2	doffed
doffers	14	35	985	2	doffers
duffer	13	47	1166	2	duffer
feoffer	12	3	302	2	feoffer
fer	6	66	4612	2	__fer
fifer	11	55	1997	2	fifer
foyer	11	64	1655	2	foyer
gaffer	13	43	1013	2	gaffer
gofer	9	48	1428	2	gofer
goffers	14	40	921	2	goffers
golfer	10	44	1118	2	golfer
hoofer	12	40	1495	2	hoofer
iffier	12	3	676	2	iffier
infer	8	42	1503	2	infer
lifer	8	58	2215	2	lifer
loafer	9	36	1094	2	loafer
lofter	9	46	1472	2	lofter
niffer	12	37	844	2	niffer
oater	5	54	3373	2	oater
ocher	10	45	1610	2	ocher
ocker	11	39	1575	2	ocker
odder	7	45	1539	2	odder
off	9	63	3163	2	off__
offal	11	3	624	2	offal
offend	13	36	566	2	offend
offered	14	3	614	2	offered
offerer	13	3	554	2	offerer
offeror	13	4	294	2	offeror
officer	15	3	421	2	officer
offkey	19	3	234	2	offkey
offs	10	71	1701	2	off_s
offset	12	3	837	2	offset
often	8	46	1141	2	often
ogler	6	59	1744	2	ogler
oiler	5	46	2828	2	oiler
older	6	51	2117	2	older
omber	9	53	1644	2	omber
omer	6	70	2839	2	o_mer
order	6	50	1936	2	order
ormer	7	52	1837	2	ormer
osier	5	35	1801	2	osier
other	8	42	1910	2	other
otter	5	44	2397	2	otter
outer	5	56	3330	2	outer
over	7	72	2734	2	o_ver
owner	8	46	1331	2	owner
oxter	12	34	1409	2	oxter
oyer	7	59	2765	2	o_yer
proffer	15	12	693	2	proffer
puffer	14	46	1073	2	puffer
refer	8	48	2214	2	refer
reoffer	13	3	501	2	reoffer
rifer	8	47	2198	2	rifer
rolfer	9	44	1227	2	rolfer
roofer	9	44	1528	2	roofer
safer	8	47	2181	2	safer
scoffer	15	31	702	2	scoffer
softer	9	40	1531	2	softer
suffer	12	43	1451	2	suffer
toffee	12	33	1101	2	toffee
troffer	13	12	586	2	troffer
wafer	11	44	1764	2	wafer
wolfer	12	42	998	2	wolfer
woofer	12	44	1136	2	woofer
zaffer	21	39	715	2	zaffer

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	81	1.530	35163.4
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	1.873	95403.6