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

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

86 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
ovate	8	42	1439	(None)
orate	5	51	3330	1	orate
abate	7	66	2784	2	abate
agate	6	65	2515	2	agate
alate	5	53	4033	2	alate
ate	3	70	5924	2	__ate
aviate	9	3	1520	2	aviate
bate	6	65	5242	2	_bate
blate	7	59	3378	2	blate
borate	8	50	2615	2	borate
cate	6	62	5460	2	_cate
comate	10	41	2484	2	comate
crate	7	65	3740	2	crate
date	5	64	4332	2	_date
donate	7	36	1950	2	donate
elate	5	53	3588	2	elate
enate	5	44	2815	2	enate
evade	9	3	818	2	evade
evite	8	53	1768	2	evite
fate	7	54	4428	2	_fate
folate	9	33	2039	2	folate
foveate	13	3	836	2	foveate
gate	5	57	4657	2	_gate
grate	6	49	3288	2	grate
hate	7	84	5017	2	_hate
iodate	7	3	1350	2	iodate
irate	5	56	2798	2	irate
late	4	75	6048	2	_late
lobate	8	29	1524	2	lobate
locate	8	39	1984	2	locate
lovage	10	3	735	2	lovage
lovat	8	3	2104	2	lovat_
lovats	9	3	907	2	lovats
mate	6	51	5422	2	_mate
notate	6	32	1786	2	notate
novae	8	59	1312	2	nova_e
oat	3	98	8826	2	o_at_
oaten	5	52	2240	2	o_aten
oater	5	54	3373	2	o_ater
oath	7	61	3215	2	o_ath
oats	4	65	5421	2	o_ats
oblate	8	22	1474	2	oblate
obovate	12	3	546	2	obovate
obviate	12	3	578	2	obviate
oleate	6	3	1888	2	oleate
opiate	8	5	1346	2	opiate
orated	7	42	2150	2	orated
orates	6	43	2861	2	orates
ornate	6	3	1514	2	ornate
outate	6	29	2340	2	outate
ova	6	68	2379	2	ova__
oval	7	71	1952	2	ova_l
ovals	8	54	1339	2	ovals
ovary	11	4	911	2	ovary
ovately	13	3	443	2	ovately
overate	10	6	2096	2	overate
ovine	8	63	1664	2	ovine
ovulate	10	3	945	2	ovulate
ovule	8	3	949	2	ovule
pate	6	53	5046	2	_pate
plate	7	46	3511	2	plate
prate	7	51	3598	2	prate
quate	14	45	2141	2	quate
rate	4	54	5876	2	_rate
rotate	6	33	2034	2	rotate
sate	4	55	5610	2	_sate
savate	9	3	1378	2	savate
skate	9	47	2155	2	skate
slate	5	54	3828	2	slate
solate	6	45	2607	2	solate
solvate	10	27	1021	2	solvate
spate	7	47	3158	2	spate
state	5	62	3733	2	state
tate	4	47	4860	2	_tate
togate	7	45	1568	2	togate
urate	5	54	3216	2	urate
vale	7	49	3734	2	_vale
vane	7	55	3469	2	_vane
vase	7	56	2965	2	_vase
vat	6	78	6345	2	_vat_
vats	7	68	4174	2	_vats
vatu	7	65	2433	2	_vatu
volte	8	53	2130	2	volte
volvate	13	31	799	2	volvate
vote	7	47	2862	2	_vote
zonate	15	41	1492	2	zonate

Search took 3 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	53800	0.330	541487.9
2	DLD Change Limit	53800	86	1.763	30516.2
3	Display Results	86	86	0.016	5375.0
	(SQL Overall)	178691	86	2.109	84727.8