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

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

69 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
pitiers	9	38	1265	(None)
pitier	8	40	1982	1	pitier_
pities	8	38	2808	1	pitie_s
biters	8	39	2524	2	bit_ers
bitters	9	49	2036	2	bitters
citers	8	50	2298	2	cit_ers
cithers	12	43	1577	2	cithers
cities	8	45	2485	2	citie_s
dithers	11	40	1615	2	dithers
fitters	10	45	1775	2	fitters
hitters	10	47	1759	2	hitters
jitters	14	43	1447	2	jitters
kiters	10	52	1859	2	kit_ers
liters	6	54	2988	2	lit_ers
litters	7	34	2257	2	litters
liviers	10	42	1107	2	liviers
metiers	9	33	1284	2	metiers
miters	8	43	2878	2	mit_ers
mithers	12	35	1673	2	mithers
mitier	8	36	2067	2	mitier_
niters	6	46	2421	2	nit_ers
paniers	9	47	1733	2	paniers
partiers	10	35	1424	2	partiers
paters	8	49	3583	2	pat_ers
patters	9	48	2519	2	patters
patzers	18	42	1057	2	patzers
peters	8	66	2459	2	pet_ers
petters	9	37	2236	2	petters
pickers	15	37	1809	2	pickers
piecers	11	41	1225	2	piecers
piers	7	59	2633	2	p__iers
pieties	9	4	1922	2	pietie_s
pikers	12	47	1739	2	pi_kers
pilfers	12	3	896	2	pilfers
pincers	11	39	1650	2	pincers
pinders	10	37	2047	2	pinders
pingers	10	40	2074	2	pingers
pinier	8	40	2469	2	pinier_
pinkers	13	41	1860	2	pinkers
pinners	9	35	1860	2	pinners
pipers	10	43	1866	2	pi_pers
pipier	10	49	1398	2	pipier_
pishers	12	38	1575	2	pishers
pissers	9	50	1475	2	pissers
pitchers	15	32	1148	2	pitchers
pithier	12	30	1029	2	pithier_
pitied	9	40	1725	2	pitie_d
pitiless	10	12	733	2	pitiless
pixies	15	49	1551	2	pixie_s
pliers	8	47	1515	2	p_liers
pothers	12	38	1862	2	pothers
potters	9	40	2434	2	potters
potzers	18	40	1054	2	potzers
priers	8	45	2119	2	p_riers
putters	9	42	1919	2	putters
puttiers	10	28	801	2	puttiers
ribiers	9	31	975	2	ribiers
ritters	7	40	2062	2	ritters
sitters	7	42	2155	2	sitters
spitters	10	41	1338	2	spitters
tidiers	8	38	977	2	tidiers
tiers	5	55	2652	2	__tiers
titers	6	45	2641	2	tit_ers
titfers	10	31	893	2	titfers
tithers	10	42	1673	2	tithers
titters	7	42	1962	2	titters
viziers	19	33	620	2	viziers
withers	13	44	1775	2	withers
zithers	19	39	1197	2	zithers

Search took 7 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.766	233278.1
2	DLD Change Limit	107671	69	5.813	18522.4
3	Display Results	69	69	0.016	4312.5
	(SQL Overall)	178691	69	6.595	27094.9