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

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

74 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
offences	16	4	502	(None)
offence	15	4	535	1	offence_
offenses	14	4	383	1	offenses
defences	14	3	963	2	defences
fences	11	46	1711	2	__fences
offended	16	4	365	2	offended
offender	15	4	372	2	offender
offenders	16	4	340	2	offenders
offends	14	23	429	2	offen_ds
offense	13	4	368	2	offense_
offices	15	3	624	2	off_ices
outfences	14	5	646	2	outfences
refences	13	3	1185	2	refences
unfences	13	3	793	2	unfences
absences	12	4	767	3	absences
affects	15	3	539	3	affe_cts
affiances	17	4	515	3	affiances
affines	13	3	948	3	affin_es
affluences	18	10	336	3	affluences
cadences	13	3	847	3	cadences
coffees	15	32	957	3	coffe__es
commences	17	13	958	3	commences
defence	13	3	989	3	defence_
defenced	15	3	720	3	defenced
defenses	12	3	791	3	defenses
effaces	15	27	727	3	eff_aces
effects	15	3	528	3	effe_cts
effendis	15	4	251	3	effendis
effluences	18	10	379	3	effluences
essences	10	4	756	3	essences
faeces	11	47	1312	3	_fae_ces
faiences	13	3	705	3	faiences
feces	10	56	2536	3	__fe_ces
fence	10	53	1991	3	__fence_
fenced	12	44	1271	3	__fenced
fencer	11	46	1353	3	__fencer
fencers	12	38	1062	3	__fencers
fiances	12	3	1067	3	_fiances
fleeces	12	39	964	3	_fleeces
flenches	16	34	1053	3	_flenches
flenses	10	3	947	3	_flenses
frenches	16	33	1163	3	_frenches
licences	12	12	933	3	licences
lucences	12	13	731	3	lucences
moffettes	17	4	346	3	moffettes
offend	13	36	566	3	offen__d
offensives	19	5	219	3	offensives
offered	14	3	614	3	offe_red
offerer	13	3	554	3	offe_rer
offerers	14	3	493	3	offerers
offerors	14	4	353	3	offerors
offers	12	34	996	3	offe__rs
office	14	3	569	3	off_ice_
officer	15	3	421	3	off_icer
officers	16	4	380	3	off_icers
offings	14	28	583	3	offin_gs
offsides	15	4	339	3	offsides
oftener	10	3	592	3	often_er
oftenest	11	4	886	3	often_est
oogenies	9	3	1158	3	oogenies
opulences	13	4	509	3	opulences
ounces	8	36	1777	3	o__unces
outfence	13	5	697	3	outfence_
outfenced	15	5	509	3	outfenced
potences	12	7	1069	3	potences
refence	12	3	1224	3	refence_
refenced	14	3	900	3	refenced
sciences	12	3	878	3	sciences
silences	10	3	1008	3	silences
spences	11	34	1392	3	_spences
toffees	13	32	708	3	toffe__es
unfence	12	3	919	3	unfence_
unfenced	14	3	773	3	unfenced
valences	13	8	851	3	valences

Search took 7 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.423	422437.4
2	DLD Change Limit	146162	74	6.313	23152.5
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	6.766	26410.1