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

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

30 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
pearlescence	18	6	319	(None)
pearlescences	19	6	285	1	pearlescences
pearlescent	15	5	350	2	pearlescen_t
coalescence	14	5	509	3	coa_lescence
opalescence	17	5	375	3	opa_lescence
preadolescence	21	9	201	3	preadolescence
putrescence	17	11	427	3	putr_escence
adolescence	16	5	385	4	_adolescence
candescence	15	5	480	4	_candescence
coalescences	15	5	421	4	coa_lescences
defervescence	24	6	171	4	defervescence
detumescence	19	10	276	4	detumescence
evanescence	18	5	363	4	_evanescence
excrescence	21	5	373	4	_excrescence
florescence	18	8	441	4	flor_escence
incalescence	15	11	397	4	incalescence
obsolescence	18	6	261	4	obsolescence
opalescences	18	5	309	4	opa_lescences
paleocene	13	4	500	4	p_a_leocen_e
persistence	15	5	415	4	pe_rsistence
preadolescences	22	9	184	4	preadolescences
prepubescence	23	11	214	4	prepubescence
prescience	16	15	729	4	p__r_escience
presence	12	22	1351	4	p__r_es_ence
pubescence	18	5	476	4	p__ubescence
putrescences	18	11	388	4	putr_escences
recrudescence	17	6	212	4	recrudescence
senescence	14	13	607	4	se__nescence
turgescence	16	5	307	4	_turgescence
virescence	17	13	486	4	_vir_escence

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	124790	0.393	454684.5
2	DLD Change Limit	124790	30	8.156	15300.4
3	Display Results	30	30	0.013	2307.7
	(SQL Overall)	178691	30	8.562	20870.2