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

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

60 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
cavitary	16	6	496	(None)
aviary	12	33	841	2	_avi_ary
caviar	11	3	1016	2	cavi_ar_
caviare	12	3	837	2	cavi_are
caviars	12	3	862	2	cavi_ars
cavitate	13	15	983	2	cavitate
cavity	14	3	1001	2	cavit__y
sanitary	11	4	675	2	sanitary
apiary	11	39	1038	3	_api_ary
ariary	9	41	1420	3	_ari_ary
avatar	9	3	752	3	_avatar_
avatars	10	3	644	3	_avatars
basilary	13	4	506	3	basilary
calamary	15	4	546	3	calamary
calvary	15	3	718	3	ca_lvary
canary	11	3	1469	3	ca__nary
capillary	16	13	426	3	capillary
capita	10	29	1377	3	capita__
capital	11	23	1152	3	capita_l
capitally	16	4	666	3	capitally
capitals	12	20	945	3	capitals
capitate	12	17	1218	3	capitate
capitulary	17	5	255	3	capitulary
caritas	9	33	1696	3	carita_s
casita	8	29	1370	3	casita__
casitas	9	33	1204	3	casita_s
catenary	13	4	658	3	catenary
cattery	12	38	1160	3	ca_ttery
cautery	12	34	959	3	ca_utery
cavalry	15	5	496	3	cav_alry
caviares	13	3	799	3	cavi_ares
cavicorn	15	4	383	3	cavicorn
caviler	12	4	906	3	caviler_
cavilers	13	4	811	3	cavilers
cavitated	15	17	735	3	cavitated
cavitates	14	16	896	3	cavitates
cavitied	14	12	681	3	cavitied
cavities	13	14	1261	3	cavities
ciliary	12	4	792	3	cili_ary
cometary	15	4	769	3	cometary
covary	14	3	874	3	cov__ary
culinary	13	5	585	3	culinary
datary	10	3	1024	3	da__tary
janisary	18	4	362	3	janisary
janizary	27	4	248	3	janizary
lactary	12	3	785	3	la_ctary
laminary	13	33	725	3	laminary
laniary	10	6	801	3	lani_ary
lapidary	14	5	409	3	lapidary
lavatory	14	4	570	3	lavatory
limitary	13	4	493	3	limitary
military	13	4	723	3	military
sagittary	13	4	220	3	sagittary
salivary	14	4	473	3	salivary
salutary	11	4	511	3	salutary
solitary	11	4	650	3	solitary
unitary	10	3	861	3	_unitary
vanitory	14	4	573	3	vanitory
vivary	15	3	698	3	__vivary
votary	12	24	833	3	__votary

Search took 9 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	146162	0.423	422437.4
2	DLD Change Limit	146162	60	8.030	18202.0
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	8.486	21057.2