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

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

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.

59 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
delinquencies	25	12	168	(None)
delinquency	26	6	176	3	delinquenc__y
delinquents	21	5	256	3	delinquen__ts
deliquesces	23	5	174	3	deli_quesc_es
deficiencies	20	5	294	4	defi_ciencies
delinquent	20	5	339	4	delinquen___t
delinquently	25	6	178	4	delinquen_tly
deliquesce	22	5	182	4	deli_quesc_e_
deliquesced	24	5	143	4	deli_quesc_ed
deliquescing	25	6	124	4	deli_quescing
dependencies	18	5	408	4	depen_dencies
desinences	13	4	721	4	desin__enc_es
eloquences	21	5	320	4	_el_oquenc_es
eminencies	14	4	593	4	_emin__encies
reliquefies	23	5	198	4	reli_que_fies
sequencies	21	5	599	4	se___quencies
belligerencies	19	7	144	5	belligerencies
decadencies	17	5	387	5	de__cadencies
decencies	14	4	894	5	de____cencies
dehiscences	19	5	393	5	dehi_scenc_es
delicacies	15	4	513	5	deli___cacies
delineates	11	4	712	5	delin__e_ates
deliquescences	28	7	144	5	deli_quescences
deliquescent	24	6	217	5	deli_quescent
deliverances	18	14	269	5	deliveranc_es
deliveries	14	4	601	5	deli__ve_ries
denounces	12	4	541	5	de__nou_nc_es
dependences	17	4	588	5	depen_denc_es
desinence	12	5	750	5	desin__enc_e_
despondencies	19	6	214	5	despondencies
detergencies	16	5	435	5	de_tergencies
deviancies	16	4	459	5	devi___ancies
diligences	14	4	433	5	dili__genc_es
dominancies	16	5	395	5	domin__ancies
eloquence	20	5	333	5	_el_oquenc_e_
eminences	13	4	740	5	_emin__enc_es
exigencies	20	4	526	5	_exi__gencies
fluencies	14	4	593	5	_fl___uencies
frequencies	25	5	394	5	__frequencies
imminencies	17	5	396	5	immin__encies
infrequencies	27	6	248	5	infrequencies
leniencies	12	4	619	5	__len_iencies
liquefies	21	5	357	5	__li_que_fies
pendencies	15	4	702	5	pe__n_dencies
pertinencies	16	5	457	5	pertin__encies
piquancies	23	4	323	5	__pi_quancies
plangencies	16	5	379	5	_plan_gencies
relinquishes	24	5	199	5	relinqu_ishes
reliquaries	20	5	336	5	reli_qu_aries
reliquefied	24	5	159	5	reli_que_fied
renitencies	13	4	609	5	re__nitencies
residencies	14	4	597	5	resi__dencies
resiliencies	14	5	372	5	resi_liencies
reticencies	15	4	568	5	reti__cencies
saliencies	12	4	613	5	sali___encies
sentiencies	13	4	632	5	se__ntiencies
sequences	20	6	701	5	se___quenc_es
stringencies	15	5	352	5	strin_gencies
tendencies	13	4	634	5	te__n_dencies

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	124790	0.403	443402.0
2	DLD Change Limit	124790	59	8.580	14544.3
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	9.013	19825.9