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

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

89 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
pilfer	11	3	916	(None)
pilfers	12	3	896	1	pilfers
bilker	12	49	1344	2	bilker
biller	8	49	2348	2	biller
differ	13	39	1084	2	differ
fifer	11	55	1997	2	fi_fer
filer	8	54	3300	2	fil_er
filler	9	46	2362	2	filler
filmer	11	41	1240	2	filmer
filter	9	45	1763	2	filter
gilder	8	44	1553	2	gilder
giller	7	45	1973	2	giller
golfer	10	44	1118	2	golfer
hiller	9	44	2163	2	hiller
iller	5	48	2129	2	_iller
infer	8	42	1503	2	_infer
jilter	13	35	1251	2	jilter
killer	10	49	1795	2	killer
kilter	10	37	1434	2	kilter
liefer	9	52	957	2	liefer
lifer	8	58	2215	2	li_fer
milder	9	38	1845	2	milder
miler	7	57	3306	2	mil_er
milker	12	48	1432	2	milker
miller	8	46	2541	2	miller
milter	8	49	2123	2	milter
niffer	12	37	844	2	niffer
oiler	5	46	2828	2	oil_er
oilier	6	44	1723	2	oilier
paler	7	54	3693	2	pal_er
palier	8	50	2356	2	palier
palmer	10	58	1654	2	palmer
palter	8	44	2326	2	palter
pelter	8	33	2162	2	pelter
philter	12	10	821	2	philter
piaffer	15	10	444	2	piaffer
picker	14	44	2217	2	picker
piecer	10	52	1308	2	piecer
pier	6	60	3529	2	pi__er
piker	11	56	2284	2	pi_ker
pilar	7	52	2150	2	pil_ar
pile	6	56	4969	2	pil_e_
pilea	7	51	2395	2	pil_ea
piled	8	52	3299	2	pil_ed
pilei	7	40	2178	2	pil_ei
piles	7	47	4261	2	pil_es
pilfered	14	3	585	2	pilfered
pilferer	13	4	492	2	pilferer
pillar	8	3	1402	2	pillar
pilled	9	42	2275	2	pilled
pilsner	9	3	534	2	pilsner
pincer	10	40	1917	2	pincer
pinder	9	45	2345	2	pinder
pinger	9	43	2408	2	pinger
pinier	8	40	2469	2	pinier
pinker	12	53	2244	2	pinker
pinner	8	45	2149	2	pinner
piper	9	65	2319	2	pi_per
pipier	10	49	1398	2	pipier
pisher	11	43	1775	2	pisher
pisser	8	44	1638	2	pisser
pitier	8	40	1982	2	pitier
plier	7	52	2128	2	p_lier
plyer	10	62	1433	2	p_lyer
polder	9	40	1925	2	polder
poler	7	44	3179	2	pol_er
poller	8	39	2185	2	poller
prefer	11	38	1320	2	prefer
puffer	14	46	1073	2	puffer
puler	7	48	2662	2	pul_er
puller	8	38	2081	2	puller
pulper	10	35	1327	2	pulper
pulser	8	42	1519	2	pulser
rifer	8	47	2198	2	ri_fer
rifler	9	40	1426	2	rifler
rolfer	9	44	1227	2	rolfer
siller	6	40	2605	2	siller
silver	9	38	1581	2	silver
spiller	9	29	1432	2	spiller
telfer	9	37	989	2	telfer
tiler	5	61	3102	2	til_er
tiller	6	42	2253	2	tiller
tilter	6	34	1769	2	tilter
titfer	9	40	952	2	titfer
viler	8	63	2416	2	vil_er
wilder	10	36	1647	2	wilder
wilier	9	32	1707	2	wilier
willer	9	40	2106	2	willer
wolfer	12	42	998	2	wolfer

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	89	5.093	16208.7
3	Display Results	89	89	0.063	1412.7
	(SQL Overall)	178691	89	5.282	33830.2