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

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

69 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
procaine	12	3	1227	1	procaine
procaines	13	3	1152	2	procaines
prochain	15	4	848	2	prochain_
brocading	15	5	625	3	brocading
cocain	10	13	1501	3	_cocain_
cocaine	11	13	1517	3	_cocaine
cocains	11	13	1392	3	_cocains
crocein	11	3	807	3	crocein_
croceine	12	4	803	3	croceine
croceins	12	3	810	3	croceins
crocine	11	3	1415	3	croc_ine
crocking	17	43	1344	3	crocking
frocking	18	30	957	3	frocking
marocain	12	4	706	3	marocain_
marocains	13	4	635	3	marocains
phocine	14	3	883	3	phoc_ine
pocking	16	39	1676	3	p_ocking
pooching	16	32	898	3	pooching
porcine	11	3	1284	3	porc_ine
porcini	11	3	763	3	porc_ini
porcino	11	3	811	3	porc_ino
pricing	12	34	1734	3	pric_ing
pricking	17	32	1260	3	pricking
proband	12	27	1024	3	proba_nd
probang	12	27	838	3	proba_ng
probating	14	3	1119	3	probating
probing	12	33	1444	3	pro_bing
procarp	13	4	682	3	proca_rp
procarps	14	4	597	3	procarps
prochein	15	4	752	3	prochein_
proclaim	14	4	607	3	proclai_m
proclaims	15	4	507	3	proclaims
procuring	14	3	799	3	procuring
prodding	13	18	934	3	prodding
profane	12	21	1186	3	profa_ne
profaning	15	3	729	3	profaning
progging	13	26	1038	3	progging
prolamin	12	13	975	3	prolamin_
prolamine	13	15	1056	3	prolamine
prolamins	13	15	970	3	prolamins
prolan	8	4	1469	3	prola_n_
prolans	9	3	1427	3	prola_ns
proline	9	23	2159	3	pro_line
promine	11	28	1944	3	pro_mine
promoing	13	3	1046	3	promoing
pronating	12	3	1376	3	pronating
pronging	12	35	1184	3	pronging
proofing	14	3	931	3	proofing
propane	11	27	1615	3	propa_ne
propine	11	30	2021	3	pro_pine
propping	12	28	1167	3	propping
prorating	12	3	1428	3	prorating
prosaic	11	3	1116	3	prosai_c
prosaism	12	6	804	3	prosaism
prosaist	10	6	1158	3	prosaist
prosing	10	33	1938	3	pro_sing
protamin	12	12	1054	3	protamin_
protamine	13	13	1091	3	protamine
protamins	13	14	1077	3	protamins
protein	9	24	1473	3	protein_
proteins	10	21	1428	3	proteins
proving	13	42	1407	3	pro_ving
prowling	14	4	999	3	prowling
ptomain	11	4	696	3	ptomain_
ptomaine	12	4	553	3	ptomaine
ptomains	12	4	605	3	ptomains
rocking	14	36	1963	3	_rocking
romaine	9	5	1212	3	_romaine
trocking	15	36	1242	3	trocking

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.423	422437.4
2	DLD Change Limit	146162	69	6.656	21959.4
3	Display Results	69	69	0.013	5307.7
	(SQL Overall)	178691	69	7.092	25196.1