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

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

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.

82 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
petrolic	12	4	969	(None)
nitrolic	10	4	681	2	nitrolic
petrol	8	27	1406	2	petrol__
petrologic	15	4	773	2	petrologic
petrols	9	29	1308	2	petrol_s
pyrrolic	15	4	456	2	pyrrolic
aerobic	11	3	1021	3	ae_robic
ametropic	15	4	566	3	ametropic
catholic	15	15	838	3	catholic
cerotic	11	4	1506	3	ce_rotic
ecbolic	13	4	562	3	_ecbolic
eidolic	10	4	706	3	_eidolic
embolic	13	4	742	3	_embolic
enolic	8	4	1335	3	_e_nolic
entropic	12	4	968	3	entropic
epibolic	14	4	491	3	epibolic
erotic	8	26	2027	3	_e_rotic
ethylic	15	4	632	3	_ethylic
frolic	11	4	920	3	__frolic
geotropic	14	6	701	3	geotropic
heroic	11	35	1692	3	he_ro_ic
heterotic	14	4	902	3	heterotic
ketonic	13	4	992	3	ket_onic
ketotic	13	4	864	3	ket_otic
leprotic	12	4	858	3	leprotic
meropic	13	3	1026	3	me_ropic
metabolic	15	4	532	3	metabolic
metallic	12	4	764	3	metallic
meteoric	12	4	730	3	meteoric
methodic	16	5	691	3	methodic
methylic	18	4	601	3	methylic
metopic	13	3	976	3	met_opic
metric	10	3	1468	3	metr__ic
necrotic	12	3	1004	3	necrotic
neotropic	13	6	771	3	neotropic
neroli	6	11	1115	3	ne_roli_
nerolis	7	10	1277	3	ne_rolis
neuronic	10	4	901	3	neuronic
neurotic	10	3	969	3	neurotic
neutronic	11	4	594	3	neutronic
pantropic	15	4	775	3	pantropic
parodic	12	23	1172	3	p_arodic
parotic	11	25	1804	3	p_arotic
patriotic	13	10	758	3	patriotic
patrol	8	32	1302	3	patrol__
patrols	9	35	1351	3	patrol_s
peloric	11	3	1071	3	pe_loric
pentomic	14	4	814	3	pentomic
peptonic	14	4	883	3	peptonic
periodic	13	4	843	3	periodic
periotic	12	3	1344	3	periotic
peroxid	17	3	1027	3	pe_roxid
petaloid	11	4	875	3	petaloid
petiolar	10	4	617	3	petiolar
petiole	9	3	1130	3	petiol_e
petioled	11	3	799	3	petioled
petioles	10	3	1164	3	petioles
petrale	9	3	1262	3	petral_e
petrales	10	3	1298	3	petrales
petrel	8	31	1153	3	petrel__
petrels	9	27	937	3	petrel_s
petroleum	13	5	330	3	petroleum
petrology	15	4	733	3	petrology
petronel	10	4	814	3	petronel
petrosal	10	4	715	3	petrosal
petrous	9	27	1442	3	petro_us
phenolic	15	4	681	3	phenolic
phthalic	18	5	557	3	phthalic
plethoric	16	4	465	3	plethoric
podsolic	13	4	417	3	podsolic
podzolic	22	4	341	3	podzolic
prolix	15	3	868	3	p__rolix
ptotic	10	27	1337	3	p_t_otic
pythonic	18	4	755	3	pythonic
retrodict	12	4	750	3	retrodict
retrofit	11	4	830	3	retrofit
strobic	11	3	825	3	_strobic
tetradic	11	4	581	3	tetradic
tetroxid	16	4	644	3	tetroxid
tropic	10	30	1419	3	__tropic
vitriolic	14	4	303	3	vitriolic
xerotic	16	4	1086	3	xe_rotic

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	146162	0.420	425454.8
2	DLD Change Limit	146162	82	7.470	19566.5
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.920	22562.0