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

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

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.

89 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
offended	16	4	365	(None)
offender	15	4	372	1	offender
defended	14	3	722	2	defended
fended	11	42	1691	2	__fended
forfended	17	4	374	2	forfended
offence	15	4	535	2	offence_
offences	16	4	502	2	offences
offend	13	36	566	2	offen__d
offenders	16	4	340	2	offenders
offends	14	23	429	2	offend_s
offense	13	4	368	2	offense_
offenses	14	4	383	2	offenses
offered	14	3	614	2	offe_red
offhanded	20	4	192	2	offhanded
affected	17	4	479	3	affected
affined	14	3	641	3	affin_ed
afforded	16	4	343	3	afforded
amended	11	32	831	3	_amended
appended	14	3	548	3	appended
ascended	12	4	651	3	ascended
attended	10	3	576	3	attended
bended	10	55	2123	3	__bended
blended	11	47	1071	3	_blended
coffered	17	3	767	3	coffe_red
coffined	17	3	599	3	coffin_ed
cofounded	16	4	346	3	cofounded
commended	17	13	701	3	commended
contended	13	3	927	3	contended
defenced	15	3	720	3	defenced
defender	13	3	729	3	defender
defensed	13	3	622	3	defensed
defunded	14	3	516	3	defunded
depended	13	3	798	3	depended
effected	17	4	499	3	effected
effendi	14	4	242	3	effend_i
effendis	15	4	251	3	effendis
emended	11	32	960	3	_emended
ended	7	44	2126	3	___ended
expended	19	13	654	3	expended
extended	17	13	583	3	extended
fenced	12	44	1271	3	__fenced
fender	10	37	1872	3	__fender
feuded	11	40	1000	3	__feuded
fielded	12	20	681	3	_fielded
flensed	11	3	661	3	_flensed
fomented	14	3	780	3	fomented
fonded	11	57	1704	3	__fonded
forefended	18	4	324	3	forefended
founded	12	40	1142	3	_founded
friended	13	3	503	3	friended
fronded	12	38	886	3	_fronded
funded	11	44	1389	3	__funded
goffered	16	3	452	3	goffe_red
impended	14	3	595	3	impended
intended	10	23	1041	3	intended
mended	10	44	1868	3	__mended
nonfunded	14	4	338	3	nonfunded
obtunded	12	4	352	3	obtunded
offed	12	35	916	3	off___ed
offending	17	4	409	3	offending
offerer	13	3	554	3	offe_rer
offloaded	17	4	184	3	offloaded
offside	14	5	369	3	offside_
offsides	15	4	339	3	offsides
oftener	10	3	592	3	often_er
omened	9	37	1100	3	o_men_ed
opened	9	43	1186	3	o_pen_ed
oriented	9	3	748	3	oriented
outfenced	15	5	509	3	outfenced
pended	10	38	1901	3	__pended
portended	13	4	564	3	portended
refenced	14	3	899	3	refenced
refunded	13	3	695	3	refunded
remended	12	30	1039	3	remended
rended	8	45	2410	3	__rended
scended	11	32	987	3	_scended
sended	8	51	2123	3	__sended
softened	12	3	566	3	soften_ed
tended	8	38	1948	3	__tended
trended	9	40	1176	3	_trended
unbended	12	27	997	3	unbended
unended	9	28	1182	3	_unended
unfenced	14	3	773	3	unfenced
unfunded	13	3	647	3	unfunded
unmended	12	29	909	3	unmended
untended	10	26	1115	3	untended
upended	11	26	732	3	_upended
vended	11	44	1635	3	__vended
wended	11	36	1615	3	__wended

Search took 10 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	146162	0.156	1145455.1
2	DLD Change Limit	146162	89	8.813	16584.8
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	9.015	19821.5