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

Here are the results of your fuzzy-string dictionary search for “products” 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
products	13	7	651	(None)
produces	13	4	790	1	produces
product	12	7	923	1	product_
aeroducts	12	4	387	2	aeroducts
byproducts	20	5	198	2	byproducts
coproducts	17	5	335	2	coproducts
predicts	13	3	961	2	predicts
produce	12	6	751	2	produc_e
produced	14	5	607	2	produced
producer	13	5	584	2	producer
producers	14	5	488	2	producers
projects	19	3	641	2	projects
prosects	12	3	947	2	prosects
protects	12	3	974	2	protects
abducts	12	6	531	3	_abducts
adducts	11	7	460	3	_adducts
aeroduct	11	5	563	3	aeroduct_
byproduct	19	5	224	3	byproduct_
conducts	13	11	871	3	conducts
coproduces	17	6	372	3	coproduces
coproduct	16	6	452	3	coproduct_
croquets	19	5	521	3	croquets
deducts	11	6	659	3	_deducts
ducts	8	53	1989	3	___ducts
educts	9	43	989	3	__educts
eructs	8	36	1079	3	er__ucts
geoducks	16	4	228	3	geoducks
grouts	7	50	1561	3	gro_u_ts
inducts	10	25	957	3	_inducts
oviducts	14	4	207	3	oviducts
pandects	13	3	584	3	pandects
parodists	12	4	851	3	parodists
paroquets	20	4	364	3	paroquets
poults	8	46	1348	3	p_o_ults
pouts	7	55	3032	3	p_o_u_ts
preacts	11	32	1136	3	pr_eacts
preadults	12	4	428	3	preadults
precuts	11	17	1047	3	precu_ts
prededucts	16	4	222	3	prededucts
predict	12	3	1532	3	predict_
predusks	15	4	342	3	predusks
prefects	15	9	813	3	prefects
prelects	12	9	972	3	prelects
prepuces	14	3	858	3	prepuces
probits	11	27	1257	3	pro_bits
procures	12	3	921	3	procures
prodders	12	3	746	3	prodders
prodrugs	12	4	248	3	prodrugs
prods	8	55	2355	3	prod___s
producing	15	5	614	3	producing
production	15	4	789	3	production
productions	16	4	753	3	product~~ion~~s
productive	18	4	551	3	productive
profits	12	29	1124	3	pro_fits
project	18	3	845	3	project_
projets	16	3	916	3	pro_jets
prompts	13	3	747	3	pro_mpts
prophets	15	3	950	3	prophets
propjets	19	3	549	3	propjets
prosect	11	3	1339	3	prosect_
prospects	15	4	510	3	prospects
protect	11	3	1363	3	protect_
protests	10	3	1049	3	protests
protists	10	3	1336	3	protists
protracts	13	4	702	3	protracts
proudest	11	3	894	3	proudest
provosts	13	3	608	3	provosts
redacts	10	5	1094	3	_redacts
reduces	10	5	1334	3	_reduces
relucts	9	36	967	3	_relucts
reproduces	15	4	493	3	reproduces
rodents	8	6	1154	3	_rodents
roquets	16	39	894	3	_roquets
rousts	6	170	1672	3	_ro_usts
routs	5	71	3341	3	_ro_u_ts
sprouts	9	4	998	3	spro_u_ts
subducts	13	10	609	3	subducts
subproducts	18	5	218	3	~~sub~~products
traduces	11	3	656	3	traduces
trouts	6	61	1663	3	tro_u_ts
viaducts	14	4	229	3	viaducts
woodcuts	14	4	359	3	woodcuts

Search took 7 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	6.423	22756.0
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	6.873	25999.0