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

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

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.

66 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
printmakers	19	5	221	(None)
printmaker	18	5	231	1	printmaker_
kingmakers	16	15	280	3	_kingmakers
prinkers	14	30	1038	3	prin___kers
printers	10	32	1490	3	print___ers
printmaking	20	5	285	3	printmaking
printmakings	21	5	181	3	printmakings
rainmakers	16	4	406	3	rain_makers
shirtmakers	20	5	220	3	shirtmakers
tentmakers	16	4	309	3	_tentmakers
winemakers	19	4	428	3	_winemakers
brainteasers	14	5	141	4	brainteasers
cabinetmakers	23	6	83	4	cabinetmakers
diemakers	16	4	526	4	_di_emakers
dressmakers	18	5	176	4	dressmakers
drinkers	13	27	782	4	drin___kers
drugmakers	18	4	180	4	dr_ugmakers
filmmakers	21	4	231	4	_filmmakers
grimacers	14	6	355	4	gri__macers
hatmakers	18	10	517	4	__hatmakers
icemakers	17	4	401	4	__icemakers
intakes	11	3	1094	4	__int_ake_s
intimaters	12	9	785	4	__intimaters
kingmaker	15	14	294	4	_kingmaker_
mistakers	15	11	708	4	_mist_akers
noisemakers	17	5	270	4	noisemakers
pacemakers	20	10	426	4	p_acemakers
painters	10	30	1302	4	paint___ers
papermakers	21	5	325	4	papermakers
partakers	15	3	656	4	p_art_akers
peacemakers	21	10	246	4	peacemakers
phrasemakers	23	5	168	4	phrasemakers
pinkers	13	41	1860	4	p_in___kers
platemakers	19	5	282	4	platemakers
playmakers	21	4	310	4	p_laymakers
plinkers	14	30	939	4	plin___kers
pointers	10	30	1372	4	point___ers
polltakers	16	4	240	4	pollt_akers
prenumbers	16	4	271	4	prenum_bers
prickers	16	37	1067	4	pri___ckers
primages	13	15	927	4	pri__mage_s
primates	12	15	1593	4	pri__mate_s
primavera	16	4	240	4	pri__mavera
primaveras	17	4	193	4	pri__maveras
primers	11	42	1567	4	pri__m__ers
prinker	13	34	1274	4	prin___ker_
printer	9	39	1730	4	print___er_
printeries	12	4	1063	4	printerie_s
printery	13	31	843	4	print___ery
printless	11	3	751	4	print__less
pristanes	11	4	1043	4	prist_ane_s
rainmaker	15	4	439	4	rain_maker_
remakers	14	38	1130	4	_r__emakers
retakers	12	35	1113	4	_r_et_akers
ringmasters	14	13	280	4	_ringmasters
sailmakers	16	4	378	4	sai_lmakers
shirtmaker	19	5	233	4	shirtmaker_
spinnakers	16	4	191	4	spin_nakers
springwaters	18	5	130	4	springwaters
sprinters	11	32	936	4	sprint___ers
tentmaker	15	4	311	4	_tentmaker_
unmakers	14	25	665	4	__un_makers
urinometers	13	4	469	4	urinometers
vintagers	13	12	390	4	_vint_agers
wigmakers	19	4	338	4	_wi_gmakers
winemaker	18	4	435	4	_winemaker_

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	148819	0.280	638182.1
2	DLD Change Limit	148819	66	8.813	16886.3
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	9.126	19580.4