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

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

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.

64 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
pastorate	11	4	1117	(None)
pastorale	11	4	731	1	pastorale
pastorates	12	4	1014	1	pastorates
castrate	10	3	1386	2	cast_rate
pastoral	10	3	1048	2	pastora_l
pastorales	12	4	713	2	pastorales
pastorali	11	4	624	2	pastorali
pastorals	11	4	795	2	pastorals
pasturage	12	4	492	2	pasturage
apostolate	12	4	451	3	apostolate
ascorbate	13	4	446	3	_ascorbate
asperate	10	3	1237	3	_asperate
aspirate	10	3	994	3	_aspirate
automate	10	4	1194	3	_automate
castigate	12	4	796	3	castigate
castrated	12	3	951	3	cast_rated
castrater	11	4	852	3	cast_rater
castrates	11	3	1267	3	cast_rates
castrati	10	4	864	3	cast_rati
castrato	10	4	852	3	cast_rato
doctorate	12	4	679	3	doctorate
factorage	15	4	334	3	factorage
hastate	10	3	1391	3	hast__ate
lustrate	8	3	1044	3	lust_rate
masticate	13	4	1128	3	masticate
masturbate	14	4	347	3	masturbate
maturate	10	3	1261	3	ma_turate
ostomate	10	4	957	3	_ostomate
pandurate	12	4	588	3	pandurate
passionate	12	4	597	3	passionate
passivate	14	4	568	3	passivate
pastor	8	48	1748	3	pastor___
pastorally	15	6	544	3	pastorally
pastored	11	3	996	3	pastor_ed
pastoring	12	3	1085	3	pastoring
pastorium	13	4	769	3	pastorium
pastorly	13	4	578	3	pastor_ly
pastors	9	41	1900	3	pastor__s
pastrami	12	4	633	3	past_rami
pasturages	13	4	492	3	pasturages
pastural	10	3	841	3	pastura_l
pasture	9	3	1146	3	pastur__e
patinate	10	30	1631	3	pa_tinate
patriate	10	3	1193	3	pa_triate
perborate	13	5	1014	3	perborate
perforate	14	5	946	3	perforate
perorate	10	4	1792	3	p_erorate
phorate	12	4	1336	3	p__horate
postdate	11	3	965	3	post_date
postoral	10	3	1172	3	postora_l
postrace	12	3	1054	3	post_race
postulate	11	6	981	3	postulate
prestorage	13	4	490	3	prestorage
priorate	10	4	1173	3	p_riorate
prorate	9	4	1873	3	p__rorate
prostrate	11	4	1248	3	prost_rate
protonate	11	4	1257	3	protonate
pustulate	11	7	724	3	pustulate
rectorate	11	4	1136	3	rectorate
rostrate	8	3	1384	3	rost_rate
saturate	8	3	1281	3	sa_turate
stomate	9	3	1312	3	__stomate
storage	8	3	1047	3	__storage
tartrate	8	9	968	3	tart_rate

Search took 8 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	148641	0.423	422437.4
2	DLD Change Limit	148641	64	6.733	22076.5
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.189	24856.2