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

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

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.

67 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
painters	10	30	1302	(None)
fainters	11	34	969	1	fainters
painter	9	38	1456	1	painter_
pointers	10	30	1372	1	pointers
printers	10	32	1490	1	printers
baiters	9	46	1930	2	bai_ters
banters	9	46	2311	2	ba_nters
canters	9	48	2772	2	ca_nters
cointers	10	36	1640	2	cointers
daunters	9	32	984	2	daunters
fainter	10	36	1105	2	fainter_
gainers	8	42	1459	2	gain_ers
gaiters	8	35	1653	2	gai_ters
haunters	11	32	953	2	haunters
hinters	10	37	1957	2	_hinters
inters	6	43	2804	2	__inters
jointers	15	28	932	2	jointers
linters	7	38	2262	2	_linters
minters	9	38	2246	2	_minters
painless	10	10	834	2	painless
painted	10	42	1463	2	painte_d
painterly	14	4	331	2	painterly
paintier	10	4	879	2	paintier_
paints	8	59	2183	2	paint__s
palters	9	40	2168	2	pa_lters
panders	10	34	2373	2	pa_nders
paniers	9	47	1733	2	pa_niers
panners	9	36	2127	2	pa_nners
panniers	10	48	885	2	panniers
panthers	13	5	1078	2	pa_nthers
panzers	18	40	1201	2	pa_nzers
partners	10	27	1113	2	partners
pasters	9	45	3173	2	pa_sters
paters	8	49	3582	2	pa__ters
patters	9	48	2519	2	pa_tters
pawners	12	43	1107	2	pawn_ers
philters	13	9	817	2	philters
piasters	10	29	1280	2	piasters
pincers	11	39	1650	2	p_incers
pinders	10	37	2047	2	p_inders
pingers	10	40	2074	2	p_ingers
pinkers	13	41	1860	2	p_inkers
pinners	9	35	1860	2	p_inners
plaisters	11	3	781	2	plaisters
plaiters	10	35	1263	2	plai_ters
planters	10	29	1532	2	planters
plinkers	14	30	939	2	plinkers
pointer	9	38	1493	2	pointer_
pointes	9	32	1675	2	pointe_s
prinkers	14	30	1038	2	prinkers
printer	9	39	1730	2	printer_
printery	13	31	843	2	printery
punters	9	36	1703	2	p_unters
ranters	7	33	2364	2	ra_nters
reinters	8	26	1477	2	reinters
saunters	8	29	1174	2	saunters
sinters	7	40	2407	2	_sinters
splinters	11	27	792	2	splinters
sprinters	11	32	936	2	sprinters
stinters	8	33	1274	2	stinters
taunters	8	25	926	2	taunters
tinters	7	42	2110	2	_tinters
vaunters	11	32	774	2	vaunters
waisters	11	38	1152	2	waisters
waiters	10	42	1862	2	wai_ters
wanters	10	44	2009	2	wa_nters
winters	10	37	2047	2	_winters

Search took 5 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	121059	0.140	1276364.3
2	DLD Change Limit	121059	67	4.656	26000.6
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	4.842	36904.4