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

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

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.

78 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
frequencies	25	5	394	(None)
frequences	24	4	493	1	frequenc_es
frequence	23	4	480	2	frequenc_e_
infrequencies	27	6	248	2	infrequencies
sequencies	21	5	599	2	_sequencies
fervencies	18	4	518	3	f_ervencies
fluencies	14	4	593	3	f__luencies
frequency	26	5	340	3	frequenc__y
frequented	23	4	342	3	frequen_ted
frequenter	22	4	341	3	frequen_ter
frequenters	23	5	264	3	frequenters
frequentest	23	5	265	3	frequen_test
frequenting	24	4	327	3	frequenting
frequentness	24	5	182	3	frequentness
frequents	21	4	444	3	frequen__ts
infrequences	26	5	330	3	infrequenc_es
recencies	13	3	1225	3	_re_cencies
regencies	12	4	928	3	_re_gencies
sequences	20	6	701	3	_sequenc_es
adequacies	22	5	216	4	adequ_acies
affluencies	19	10	256	4	affluencies
ardencies	12	4	785	4	ar__dencies
brevetcies	17	8	220	4	bre_vetcies
clemencies	16	4	473	4	cle_mencies
credences	14	9	814	4	cre_denc_es
decencies	14	4	894	4	_de_cencies
eloquences	21	5	320	4	eloquenc_es
emergencies	16	12	451	4	emergencies
equerries	18	4	488	4	__equerries
feculences	17	4	494	4	f_eculenc_es
flatulencies	17	5	177	4	flatulencies
fragrancies	17	5	330	4	fragrancies
freebies	13	3	787	4	fre__e_bies
freelances	15	4	522	4	freelanc_es
frenches	16	33	1163	4	fr___enches
frenzies	20	3	771	4	fr___enzies
frequent	20	4	642	4	frequen___t
frequentatives	29	14	136	4	frequentatives
frequently	25	5	380	4	frequen_tly
fromenties	15	4	667	4	fr_omenties
frounces	13	3	618	4	fr_ou_nc_es
frumenties	15	4	443	4	fr_umenties
greenies	9	3	1267	4	gre__en_ies
gyrofrequencies	33	14	73	4	~~gyro~~frequencies
infrequence	25	5	341	4	infrequenc_e_
leniencies	12	4	619	4	_leniencies
pendencies	15	4	702	4	_pendencies
piquancies	23	4	323	4	_piquancies
precedencies	19	5	372	4	precedencies
pregnancies	16	4	456	4	pregnancies
prepotencies	18	8	429	4	prepotencies
prepunches	19	5	401	4	prepu_nches
presences	13	21	1379	4	pre_senc_es
presidencies	17	5	448	4	presidencies
pretences	13	23	1261	4	pre_tenc_es
pruriencies	15	5	361	4	pruriencies
quenches	22	3	601	4	___quenches
recreancies	15	4	465	4	_recreancies
recumbencies	20	6	293	4	_recumbencies
recusancies	15	5	354	4	_recusancies
redenies	9	6	1571	4	_re_den_ies
redolencies	14	5	456	4	_redolencies
refences	13	3	1184	4	_re_fenc_es
refluences	15	4	551	4	_refluenc_es
regnancies	13	4	541	4	_regnancies
renitencies	13	4	609	4	_renitencies
residencies	14	4	597	4	_residencies
reticencies	15	4	568	4	_reticencies
retrenches	15	4	590	4	_retrenches
sequence	19	4	690	4	_sequenc_e_
sequenced	21	4	445	4	_sequenc_ed
sequencer	20	4	457	4	_sequenc_er
sequencers	21	4	309	4	_sequencers
sequencing	22	4	305	4	_sequencing
tendencies	13	4	634	4	_tendencies
truancies	11	4	688	4	tr__uancies
truculencies	16	7	217	4	truculencies
urgencies	12	5	664	4	ur__gencies

Search took 9 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	148819	0.436	409841.7
2	DLD Change Limit	148819	78	8.440	17632.6
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	8.922	20028.1