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

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

61 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
persistence	15	5	415	(None)
persistences	16	5	386	1	persistences
persistency	18	5	265	1	persistency
persistencies	17	5	256	2	persistencies
persistent	12	4	603	2	persisten_t
consistence	15	5	567	3	consistence
desistance	13	4	458	3	de_sistance
existence	18	4	541	3	_e_xistence
insistence	12	4	601	3	_insistence
penitence	13	4	809	3	pe_ni_tence
percipience	19	5	315	3	percipience
persisted	12	4	714	3	persiste__d
persistently	17	5	243	3	persistently
persister	11	4	683	3	persiste__r
persisters	12	4	627	3	persiste_rs
persisting	13	4	665	3	persistin_g
pertinence	14	4	583	3	perti_nence
preexistence	23	5	235	3	preexistence
presentence	15	4	639	3	presentence
resistance	12	4	588	3	re_sistance
subsistence	15	5	326	3	subsistence
assistance	12	5	345	4	_assistance
coexistence	22	5	326	4	coexistence
consistences	16	5	542	4	consistences
consistency	18	5	397	4	consistency
dehiscence	18	5	438	4	de_hiscence
desinence	12	5	750	4	de_si_nence
desistances	14	4	419	4	de_sistances
essence	9	4	767	4	_e_s_s_ence
existences	19	4	482	4	_e_xistences
hesitance	14	4	555	4	he_si_tance
inexistence	20	5	421	4	inexistence
insistences	13	5	558	4	_insistences
insistency	15	5	397	4	_insistency
pearlescence	18	6	319	4	pearlescence
penitences	14	4	797	4	pe_ni_tences
percipiences	20	5	314	4	percipiences
peristome	13	4	659	4	per_ist_ome
peristyle	14	4	430	4	per_ist_yle
permanence	16	5	486	4	per_manence
permittee	13	4	668	4	permitte__e
persist	9	3	1585	4	persist____
persists	10	4	918	4	persist___s
pertinences	15	4	574	4	perti_nences
pertinency	17	5	416	4	perti_nency
pestilence	14	5	454	4	pe_stilence
preexistences	24	6	203	4	preexistences
prescience	16	15	729	4	pres_cience
presence	12	22	1351	4	p_r_es_ence
presentenced	17	5	404	4	presentenced
presentences	16	5	569	4	presentences
presidency	18	4	465	4	presi_dency
pretence	12	23	1212	4	p_r__etence
pristane	10	3	1034	4	p_r_istan_e
pristine	10	3	1350	4	p_r_istin_e
renitence	11	4	905	4	re_ni_tence
resentence	12	4	811	4	re_sentence
residence	12	6	890	4	re_si_dence
resilience	12	6	562	4	re_silience
resistances	13	4	537	4	re_sistances
subsistences	16	5	300	4	subsistences

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	148819	0.423	422437.4
2	DLD Change Limit	148819	61	8.580	17344.9
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	9.033	19782.0