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

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

77 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
producers	14	5	488	(None)
producer	13	5	584	1	producer_
produces	13	4	790	1	produce_s
coproducers	18	6	253	2	coproducers
procurers	13	4	503	2	procurers
prodders	12	3	746	2	prod_ders
produce	12	6	751	2	produce__
produced	14	5	607	2	produce_d
products	13	7	651	2	produc_ts
reducers	11	4	726	2	_reducers
reproducers	16	5	332	2	reproducers
traducers	12	4	372	2	traducers
adducers	12	8	344	3	_adducers
arousers	8	48	1098	3	aro_users
conducers	14	13	656	3	conducers
coproducer	17	6	307	3	coproducer_
coproduces	17	6	372	3	coproduce_s
grocers	10	35	1125	3	gro__cers
groupers	11	35	864	3	gro_upers
grousers	9	38	1073	3	gro_users
grouters	9	59	1009	3	gro_uters
inducers	11	32	695	3	_inducers
introducers	14	14	322	3	introducers
plodders	12	3	552	3	plod_ders
policers	12	25	999	3	p_olicers
pouncers	12	34	920	3	p_ouncers
pourers	9	35	1367	3	p_o_urers
pouters	9	42	2187	3	p_o_uters
prancers	12	32	1034	3	pr_ancers
prefacers	16	3	629	3	prefacers
preluders	12	3	442	3	preluders
prepuces	14	3	858	3	prepuce_s
presumers	13	3	637	3	presumers
pricers	11	39	1506	3	pr__icers
probers	11	35	1458	3	pro__bers
process	11	3	1040	3	pro__cess
procurer	12	3	583	3	procurer_
procures	12	3	921	3	procure_s
procuress	13	4	409	3	procuress
prodder	11	4	795	3	prod_der_
producing	15	5	614	3	producing
product	12	7	923	3	produc__t
profaners	14	25	621	3	profaners
proffers	16	12	659	3	pro_ffers
profilers	14	23	629	3	profilers
profiters	14	22	831	3	profiters
proggers	12	25	816	3	pro_ggers
promisers	13	26	820	3	promisers
promoters	13	3	1009	3	promoters
prompters	15	3	755	3	prompters
pronouncers	15	6	328	3	pronouncers
pronucleus	14	7	274	3	pronucleus
proofers	13	11	836	3	pro_ofers
propers	11	36	1903	3	pro__pers
proposers	13	22	852	3	proposers
prosers	9	42	1964	3	pro__sers
prospers	12	30	1226	3	pro_spers
protecters	14	16	826	3	protecters
prouder	10	3	1038	3	pro_uder_
proudness	12	4	669	3	proudness
provers	12	38	1779	3	pro__vers
providers	15	3	559	3	providers
provokers	18	9	420	3	provokers
prowlers	13	32	893	3	pro_wlers
pruners	9	37	1072	3	pr__uners
reducer	10	5	900	3	_reducer_
reduces	10	5	1334	3	_reduce_s
reproducer	15	4	407	3	reproducer_
reproduces	15	4	493	3	reproduce_s
rousers	7	52	2014	3	_ro_users
routers	7	48	2287	3	_ro_uters
seducers	11	4	538	3	_seducers
traducer	11	4	458	3	traducer_
traduces	11	3	656	3	traduce_s
trouncers	11	3	481	3	trouncers
troupers	10	35	944	3	tro_upers
trousers	8	39	1063	3	tro_users

Search took 10 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	148641	0.453	394461.4
2	DLD Change Limit	148641	77	9.206	16146.1
3	Display Results	77	77	0.076	1013.2
	(SQL Overall)	178691	77	9.735	18355.5