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

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

76 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
dacoities	12	4	821	(None)
dakoities	14	4	467	1	dakoities
acuities	10	3	1245	2	_acuities
dacites	10	11	1459	2	dac_it_es
dacoits	10	7	907	2	dacoit__s
edacities	12	4	777	2	edac_ities
vacuities	14	4	714	2	vacuities
accidies	13	3	804	3	_accidies
acidities	12	8	1018	3	_acidities
aconites	10	3	1435	3	_aconit_es
agouties	9	33	769	3	_agouties
alacrities	12	4	668	3	alacrities
amities	9	3	1738	3	_a_mities
audacities	13	4	533	3	audac_ities
cacoethes	16	4	363	3	cacoethes
calvities	14	3	894	3	calvities
canities	10	15	1926	3	ca_nities
cavities	13	14	1261	3	ca_vities
cecities	12	3	1204	3	cec_ities
cities	8	45	2485	3	__c_ities
comities	12	3	1779	3	__comities
cooties	9	37	2573	3	__cooties
dacite	9	11	1588	3	dac_it_e_
dacoit	9	4	1545	3	dacoit___
dacoity	13	6	618	3	dacoit__y
dailies	8	42	1926	3	da__ilies
dainties	9	3	1240	3	da_inties
dairies	8	42	1773	3	da__iries
daisies	8	42	1709	3	da__isies
dakoits	12	4	529	3	dakoit__s
damnifies	15	4	554	3	damnifies
dandifies	14	7	689	3	dandifies
dauties	8	33	1576	3	da__uties
dawties	11	33	1270	3	da__wties
daylilies	13	4	312	3	daylilies
deaconries	13	4	517	3	deaconries
deities	8	26	2192	3	d__eities
densities	10	3	1079	3	densities
dhooties	12	3	764	3	d_hooties
diacritics	15	6	349	3	diacritics
diclinies	12	4	783	3	diclinies
dignities	11	4	959	3	dignities
dimities	11	3	1400	3	d_imities
docilities	13	4	900	3	docilities
doilies	8	40	1736	3	d__oilies
dualities	10	3	1044	3	dualities
facilities	15	4	982	3	facilities
faculties	14	5	514	3	faculties
falsities	12	4	813	3	falsities
fatuities	12	4	691	3	fatuities
gaseities	10	4	708	3	gaseities
jocosities	19	5	516	3	jocosities
laities	7	3	2034	3	la__ities
lanosities	10	4	791	3	lanosities
laxities	15	3	909	3	la_xities
majorities	19	4	585	3	majorities
mucosities	14	4	594	3	mucosities
opacities	13	4	794	3	opac_ities
pacifies	15	3	1122	3	pac_ifies
parities	10	5	2297	3	pa_rities
patooties	11	4	718	3	patooties
paucities	13	4	850	3	paucities
rachitides	16	4	453	3	rachitides
rachitis	13	4	835	3	rachiti_s
ramosities	12	4	686	3	ramosities
rarities	8	3	1633	3	ra_rities
raucities	11	4	816	3	raucities
sacristies	12	7	603	3	sacristies
sanctities	12	4	755	3	sanctities
sanities	8	12	1977	3	sa_nities
scotties	10	3	975	3	_scotties
tackifies	18	4	578	3	tackifies
taconites	11	4	847	3	taconit_es
vanities	11	14	1449	3	va_nities
varsities	12	3	924	3	varsities
vastities	12	4	893	3	vastities

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.453	394461.4
2	DLD Change Limit	148641	76	6.610	22487.3
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.093	25192.6