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

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

81 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
olivary	13	4	516	(None)
bolivar	12	4	485	2	bolivar_
bolivars	13	4	497	2	bolivars
livery	12	49	1090	2	_livery
ovary	11	4	911	2	o__vary
salivary	14	4	473	2	salivary
solidary	12	4	510	2	solidary
solitary	11	4	650	2	solitary
vivary	15	3	698	2	_vivary
alary	8	61	2344	3	al__ary
apiary	11	39	1038	3	api_ary
ariary	9	41	1420	3	ari_ary
aviary	12	33	841	3	avi_ary
biliary	12	3	821	3	biliary
binary	11	3	1222	3	_binary
bleary	11	51	1255	3	bl_eary
bolivares	14	4	472	3	bolivares
briary	11	49	1200	3	bri_ary
calvary	15	3	718	3	calvary
chivalry	19	4	308	3	chivalry
chivari	15	3	604	3	chivari
ciliary	12	4	792	3	ciliary
clary	10	57	1961	3	cl__ary
clivers	12	34	1175	3	clivers
clovery	15	40	740	3	clovery
covary	14	3	874	3	_covary
culinary	13	5	585	3	culinary
delivery	15	28	655	3	delivery
diary	9	50	1697	3	_di_ary
flavory	16	4	474	3	flavory
foliar	9	32	1097	3	foli_ar_
friary	12	40	1009	3	fri_ary
glary	9	60	1854	3	gl__ary
goliard	9	3	607	3	goli_ard
holiday	14	3	614	3	holida_y
ivory	11	3	737	3	__ivory
leary	8	59	2738	3	_l_eary
liar	4	72	2968	3	_li_ar_
liard	6	54	1859	3	_li_ard
liars	5	47	2316	3	_li_ars
library	12	4	532	3	_library
lidar	6	3	1272	3	_lidar_
lidars	7	3	1078	3	_lidars
litany	9	3	905	3	_litany
lively	12	33	1081	3	_lively
liver	8	51	3296	3	_liver_
livers	9	49	2782	3	_livers
livre	8	56	1325	3	_liv_re
lizard	16	36	923	3	_lizard
miliary	12	4	946	3	miliary
military	13	4	723	3	military
obituary	13	4	285	3	obituary
ogival	10	3	587	3	ogiva_l
oilway	12	3	574	3	oilwa_y
oligarch	14	4	308	3	oligarch
oligarchy	18	5	212	3	oligarchy
olive	8	48	1715	3	oliv__e
olives	9	43	1395	3	oliv_es
olivine	10	3	884	3	olivine
ordinary	12	4	491	3	ordinary
ossuary	10	4	394	3	ossuary
ostiary	10	3	646	3	ostiary
ovipara	12	4	254	3	ovipara
ovulary	13	4	491	3	ovulary
plenary	12	3	754	3	plenary
polypary	18	5	511	3	polypary
primary	14	3	770	3	primary
privacy	17	4	423	3	privacy
quinary	19	3	693	3	quinary
quivery	22	26	546	3	quivery
rivalry	13	5	403	3	_rivalry
shivery	16	31	702	3	shivery
silvery	13	32	809	3	silvery
slavery	13	40	789	3	slavery
sliver	9	41	1659	3	sliver_
slivers	10	41	1525	3	slivers
topiary	12	4	581	3	topi_ary
trinary	10	3	917	3	trinary
unitary	10	3	861	3	unitary
urinary	10	3	724	3	urinary
vary	10	52	2606	3	___vary

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	134027	0.406	440125.6
2	DLD Change Limit	134027	81	6.796	19721.5
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	7.232	24708.4