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

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

33 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
petrochemicals	25	7	272	(None)
petrochemical	24	6	390	1	petrochemical_
neurochemicals	23	7	283	2	neurochemicals
agrochemicals	23	10	283	3	_agrochemicals
neurochemical	22	6	408	3	neurochemical_
agrichemicals	23	8	203	4	_agrichemicals
agrochemical	22	8	389	4	_agrochemical_
biochemicals	23	6	322	4	__biochemicals
cytochemical	23	6	414	4	cyt_ochemical_
electrochemical	23	7	272	4	electrochemical_
geochemical	21	5	452	4	ge__ochemical_
petrochemistry	26	7	227	4	petrochemistry
photochemical	27	12	497	4	photochemical_
phytochemical	30	16	424	4	phytochemical_
psychochemicals	31	8	244	4	psychochemicals
stereochemical	23	7	251	4	stereochemical_
agrichemical	22	10	278	5	_agrichemical_
biochemical	22	5	435	5	__biochemical_
biogeochemicals	27	8	180	5	biogeochemicals
chemicals	18	4	560	5	_____chemicals
cosmochemical	23	6	276	5	cosmochemical_
geochemically	26	5	484	5	ge__ochemically
histochemical	25	6	312	5	histochemical_
metronomical	18	5	416	5	metro_nomical_
neurochemists	20	6	358	5	neurochemi_sts
nonchemicals	21	10	362	5	__nonchemicals
petrological	17	5	859	5	petro_logical_
photochemically	32	6	409	5	photochemically
phytochemically	35	6	379	5	phytochemically
prophetical	20	5	584	5	p__rophetical_
psychochemical	30	7	315	5	psychochemical_
radiochemical	23	6	276	5	radiochemical_
thermochemical	28	7	308	5	thermochemical_

Search took 8 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	95024	0.126	1418182.5
2	DLD Change Limit	95024	33	6.983	13607.9
3	Display Results	33	33	0.033	1000.0
	(SQL Overall)	178691	33	7.142	25019.7