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

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

80 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
prostrate	11	4	1248	(None)
prostate	10	3	1453	1	prost_ate
prostrated	13	4	942	1	prostrated
prostrates	12	4	1199	1	prostrates
rostrate	8	3	1384	1	_rostrate
frustrate	12	4	558	2	frustrate
postdate	11	3	965	2	p_ostdate
postrace	12	3	1054	2	p_ostrace
prorate	9	4	1873	2	pro__rate
prostates	11	3	1442	2	prost_ates
protrade	11	4	821	2	pro_trade
apostate	10	4	985	3	apost_ate
arbitrate	11	13	737	3	arbitrate
aristate	8	3	1213	3	arist_ate
castrate	10	3	1386	3	_castrate
costate	9	40	1927	3	_cost_ate
cristate	10	3	1060	3	crist_ate
frostbite	14	4	341	3	frostbite
frustrated	14	4	410	3	frustrated
frustrates	13	4	500	3	frustrates
lustrate	8	3	1044	3	_lustrate
outrate	7	23	2318	3	__outrate
pastorate	11	4	1118	3	p_astorate
penetrate	11	4	923	3	penetrate
perorate	10	4	1792	3	pero__rate
perpetrate	14	7	665	3	perpetrate
phorate	12	4	1336	3	pho__rate
phosphate	19	7	727	3	phosphate
postage	10	32	1485	3	p_ost_age
postbase	12	4	644	3	p_ostbase
postdated	13	4	688	3	p_ostdated
postdates	12	4	886	3	p_ostdates
postface	15	6	612	3	p_ostface
postgame	13	4	552	3	p_ostgame
posthaste	14	5	660	3	p_osthaste
postulate	11	6	981	3	p_ostulate
prestorage	13	4	490	3	prestorage
prestrike	15	4	749	3	prestrike
priorate	10	4	1173	3	pr_iorate
pristane	10	3	1034	3	prist_ane
probate	11	4	1448	3	pro__bate
procreate	13	4	814	3	procreate
proette	9	3	1236	3	proet__te
prograde	12	4	718	3	pro_grade
prolate	9	4	1979	3	pro__late
pronate	9	4	1887	3	pro__nate
propagate	14	4	612	3	propagate
propitiate	14	4	738	3	propitiate
prorated	11	5	1371	3	pro__rated
prorates	10	4	1807	3	pro__rates
prorogate	12	4	769	3	prorogate
proscribe	15	8	562	3	proscribe
prosecute	13	4	595	3	prosecute
proselyte	14	4	484	3	proselyte
prosomata	13	4	674	3	prosomata
prostatic	13	4	1085	3	prost_atic
prostie	9	16	1774	3	prost__ie
prostitute	12	5	519	3	prostitute
prostrating	14	4	939	3	prostrating
prostration	13	4	1079	3	prostration
prostyle	13	18	727	3	prost_yle
protease	10	20	989	3	pro_tease
protonate	11	4	1257	3	protonate
protract	12	5	1060	3	pro_tract
protracted	15	4	576	3	pro_tracted
protracts	13	4	702	3	pro_tracts
protrude	11	4	470	3	pro_trude
proustite	11	4	711	3	proust_ite
proximate	20	4	577	3	proximate
prussiate	11	4	452	3	prussiate
pyrostat	13	4	716	3	pyrost_at_
pyrostats	14	4	491	3	pyrost_ats
restate	7	38	2488	3	_rest_ate
roseate	7	6	1345	3	_ros_eate
rostra	6	3	1093	3	_rostra__
rostral	7	3	1133	3	_rostra_l
rosulate	8	3	1090	3	_rosulate
rotate	6	33	2034	3	_ro_t_ate
substrate	11	17	879	3	substrate
tristate	8	3	1103	3	trist_ate

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.420	425454.8
2	DLD Change Limit	148641	80	7.360	20195.8
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	7.826	22833.0