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

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

75 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
pointer	9	38	1493	(None)
cointer	9	36	1672	1	cointer
jointer	14	37	971	1	jointer
painter	9	38	1456	1	painter
pointe	8	46	1931	1	pointe_
pointed	10	38	1398	1	pointed
pointers	10	30	1372	1	pointers
pointes	9	32	1675	1	pointes
pointier	10	3	830	1	pointier
printer	9	39	1730	1	printer
anointer	8	3	782	2	anointer
appointer	13	5	442	2	appointer
coiner	8	43	2378	2	coin_er
coinfer	12	41	939	2	coinfer
cointers	10	36	1640	2	cointers
counter	9	42	2014	2	counter
fainter	10	36	1105	2	fainter
goiter	7	41	1620	2	goi_ter
hinter	9	40	2130	2	_hinter
hoister	10	37	1420	2	hoister
inter	5	50	2849	2	__inter
joinder	15	33	759	2	joinder
joiner	13	41	1413	2	join_er
jointed	15	37	850	2	jointed
jointers	15	28	932	2	jointers
linter	6	46	2534	2	_linter
loiter	6	46	1917	2	loi_ter
minter	8	44	2510	2	_minter
moister	9	40	1537	2	moister
mounter	9	37	1317	2	mounter
painted	10	42	1463	2	painted
painters	10	30	1302	2	painters
paintier	10	4	879	2	paintier
philter	12	10	821	2	philter
pincer	10	40	1917	2	p_incer
pinder	9	45	2345	2	p_inder
pinger	9	43	2409	2	p_inger
pinier	8	40	2469	2	p_inier
pinker	12	53	2244	2	p_inker
pinner	8	45	2150	2	p_inner
pioneer	9	3	689	2	pioneer
planter	9	40	1780	2	planter
plinker	13	40	1096	2	plinker
poinded	11	35	897	2	poinded
point	7	53	3873	2	point__
pointmen	12	4	542	2	pointmen
points	8	56	1853	2	point_s
pointy	11	49	1328	2	point_y
poiser	8	42	1724	2	poi_ser
politer	9	24	1707	2	politer
ponder	9	45	2169	2	po_nder
pontes	8	36	2785	2	po_ntes
poofter	12	3	716	2	poofter
pornier	9	34	1312	2	pornier
porter	8	42	2441	2	po_rter
poster	8	41	2917	2	po_ster
potter	8	39	2698	2	po_tter
poulter	9	37	1201	2	poulter
pouncer	11	35	1123	2	pouncer
pounder	10	33	1399	2	pounder
pouter	8	39	2398	2	po_uter
powter	11	41	1603	2	po_wter
prinker	13	34	1274	2	prinker
printed	10	40	1637	2	printed
printers	10	32	1490	2	printers
printery	13	31	843	2	printery
punter	8	43	2002	2	p_unter
reinter	7	31	1684	2	reinter
roister	7	35	1620	2	roister
sinter	6	36	2592	2	_sinter
splinter	10	32	970	2	splinter
sprinter	10	38	1081	2	sprinter
stinter	7	36	1451	2	stinter
tinter	6	39	2364	2	_tinter
winter	9	42	2280	2	_winter

Search took 6 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	107671	0.156	1145455.1
2	DLD Change Limit	107671	75	4.906	21946.8
3	Display Results	75	75	0.063	1190.5
	(SQL Overall)	178691	75	5.125	34866.5