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

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

77 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
chivaries	17	5	743	(None)
chivalries	18	4	396	1	chivalries
chivarees	17	4	438	1	chivarees
chivaried	18	4	405	1	chivaried
calvaries	14	4	980	2	calvaries
chicories	16	8	876	2	chicories
chivaree	16	4	636	2	chivar_ee
chivareed	18	4	312	2	chivareed
chivari	15	3	604	2	chivari__
chivies	15	34	1285	2	chiv__ies
chivvies	19	5	442	2	chiv_vies
covaries	13	4	1325	2	c_ovaries
shivarees	15	4	395	2	shivarees
vivaries	14	3	926	2	_vivaries
apiaries	10	3	1272	3	api_aries
aviaries	11	3	978	3	avi_aries
binaries	10	3	1418	3	_binaries
calvarias	14	4	766	3	calvarias
canaries	10	3	1894	3	c_anaries
caries	8	51	4762	3	c___aries
cavalries	14	4	636	3	c_avalries
caviares	13	3	799	3	caviar_es
chantries	14	3	1029	3	chantries
chares	11	56	3180	3	ch__ar_es
charges	13	46	1598	3	ch__arges
charier	12	43	1790	3	ch__arier
chariest	13	3	1550	3	ch__ariest
charivaried	20	5	185	3	charivaried
charivaris	18	5	307	3	charivari_s
charlies	13	34	1423	3	ch__arlies
cheapies	15	3	903	3	ch_eapies
cherries	13	18	1298	3	ch_erries
chevalier	17	4	361	3	chevalier
chevaliers	18	4	242	3	chevaliers
chevies	15	35	1144	3	chev__ies
chevres	15	37	979	3	chev_r_es
chiauses	13	3	648	3	chi_auses
chicaneries	18	5	391	3	chicaneries
chicanes	15	5	937	3	chica_nes
chiccories	16	4	383	3	chiccories
chickarees	21	6	322	3	chickarees
chickories	21	4	436	3	chickories
chilies	12	42	1830	3	chi__lies
chillies	13	41	1348	3	chi_llies
chimars	14	40	1059	3	chimar__s
chimblies	18	4	503	3	chimblies
chimeres	15	35	1131	3	chimer_es
chippies	17	30	975	3	chi_ppies
chirres	12	38	1225	3	chi__rres
chitties	13	3	1077	3	chi_tties
chivalric	19	5	270	3	chivalri_c
chivalrous	18	5	226	3	chivalrous
chivariing	19	4	280	3	chivariing
chives	14	43	1759	3	chiv___es
chivied	16	36	838	3	chiv__ied
chivvied	20	5	252	3	chiv_vied
civies	11	41	1644	3	c_iv__ies
civvies	15	5	584	3	c_iv_vies
claries	9	34	2220	3	c__laries
covaried	14	4	800	3	c_ovaried
diaries	8	33	2195	3	_di_aries
friaries	11	3	1008	3	fri_aries
ivories	10	3	1071	3	__ivories
liveries	11	3	1437	3	_liveries
ovaries	10	3	1265	3	__ovaries
primaries	13	4	1083	3	primaries
privacies	16	4	680	3	privacies
quinaries	18	5	787	3	quinaries
rivalries	12	4	500	3	_rivalries
shikarees	16	4	307	3	shikarees
shikaris	15	4	492	3	shikari_s
shivaree	14	4	566	3	shivar_ee
shivareed	16	4	285	3	shivareed
thieveries	16	4	347	3	thieveries
urinaries	9	4	920	3	urinaries
varies	9	43	3087	3	___varies
whirries	14	13	669	3	whi_rries

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	77	7.360	20195.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.810	22879.8