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

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

79 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
offence	15	4	535	(None)
offences	16	4	502	1	offences
offense	13	4	368	1	offense
defence	13	3	989	2	defence
fence	10	53	1991	2	__fence
offend	13	36	566	2	offen_d
offended	16	4	365	2	offended
offender	15	4	372	2	offender
offends	14	23	429	2	offends
offenses	14	4	383	2	offenses
office	14	3	569	2	off_ice
outfence	13	5	697	2	outfence
refence	12	3	1223	2	refence
unfence	12	3	919	2	unfence
absence	11	3	770	3	absence
affect	14	4	890	3	affe_ct
affiance	16	4	565	3	affiance
affine	12	3	1050	3	affin_e
affluence	17	10	377	3	affluence
cadence	12	3	906	3	cadence
coffee	14	41	1374	3	coffe__e
commence	16	14	910	3	commence
defenced	15	3	720	3	defenced
defences	14	3	963	3	defences
defense	11	3	750	3	defense
efface	14	36	667	3	eff_ace
effect	14	3	744	3	effe_ct
effendi	14	4	242	3	effendi
effete	12	3	518	3	effe_te
effluence	17	10	407	3	effluence
essence	9	4	767	3	essence
faience	12	3	751	3	faience
fenced	12	44	1271	3	__fenced
fencer	11	46	1353	3	__fencer
fences	11	46	1711	3	__fences
fiance	11	3	1074	3	_fiance
fierce	11	34	891	3	_fierce
fleece	11	36	990	3	_fleece
flench	14	40	1081	3	_flench
flense	9	3	890	3	_flense
french	14	35	1121	3	_french
hence	10	49	2004	3	__hence
licence	11	11	936	3	licence
lucence	11	14	800	3	lucence
moffette	16	4	349	3	moffette
offed	12	35	916	3	offe__d
offenders	16	4	340	3	offenders
offensive	18	4	277	3	offensive
offer	11	43	1138	3	offe__r
offered	14	3	614	3	offered
offerer	13	3	554	3	offerer
offeror	13	4	294	3	offeror
offers	12	34	996	3	offe_rs
officer	15	3	421	3	off_icer
offices	15	3	624	3	off_ices
offing	13	36	864	3	offin_g
offings	14	28	583	3	offings
offline	13	4	578	3	offline
offside	14	5	369	3	offside
often	8	46	1141	3	often__
oftener	10	3	592	3	oftener
once	6	54	2308	3	o___nce
opulence	12	4	515	3	opulence
ounce	7	70	1993	3	o__unce
outfenced	15	5	509	3	outfenced
outfences	14	5	646	3	outfences
pence	9	49	2445	3	__pence
potence	11	7	1136	3	potence
refenced	14	3	899	3	refenced
refences	13	3	1184	3	refences
science	11	3	878	3	science
silence	9	3	1021	3	silence
spence	10	38	1379	3	_spence
thence	11	20	1084	3	_thence
toffee	12	33	1101	3	toffe__e
unfenced	14	3	773	3	unfenced
unfences	13	3	793	3	unfences
valence	12	6	877	3	valence
whence	14	18	792	3	_whence

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	79	9.376	14294.7
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	9.562	18687.6