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

Here are the results of your fuzzy-string dictionary search for “tittivating” with Change Limit: [1] [2] [3] [4] [5]

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.

79 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
tittivating	15	5	259	(None)
titivating	14	4	532	1	ti_tivating
activating	16	4	785	3	_activating
aestivating	15	4	580	3	aestivating
captivating	19	4	488	3	captivating
cultivating	17	4	494	3	cultivating
estivating	14	4	763	3	_estivating
intimating	13	4	1082	3	_intimating
litigating	12	4	674	3	li_tigating
mitigating	14	4	743	3	mi_tigating
motivating	16	4	680	3	_motivating
nictitating	14	4	438	3	nictitating
titillating	12	4	370	3	titillating
titivation	13	4	703	3	ti_tivation
titivations	14	4	626	3	ti_tivations
titrating	10	3	1011	3	ti_t_rating
tittivate	12	4	340	3	tittivat__e
tittivated	14	4	290	3	tittivat_ed
tittivates	13	5	332	3	tittivat_es
vitiating	13	3	840	3	vi_ti_ating
busticating	16	4	530	4	busticating
castigating	15	4	600	4	castigating
deactivating	19	5	345	4	deactivating
dictating	13	3	888	4	dict__ating
dissipating	15	5	631	4	dissipating
estimating	13	4	888	4	_estimating
extricating	21	4	669	4	extricating
festinating	15	4	737	4	festinating
filiating	13	3	924	4	fi_li_ating
filtrating	14	4	597	4	filt_rating
fustigating	16	5	405	4	fustigating
imitating	12	3	876	4	_i_mitating
inactivating	18	5	346	4	inactivating
indicating	14	4	969	4	_indicating
initiating	11	4	962	4	_initiating
innovating	14	4	461	4	_innovating
instigating	13	4	715	4	instigating
intonating	11	4	863	4	_intonating
intreating	11	6	1401	4	_intreating
intubating	13	7	671	4	_intubating
iodinating	12	4	696	4	_iodinating
irrigating	12	4	595	4	_irrigating
irritating	11	4	629	4	_irritating
iterating	10	3	1425	4	_i_terating
liquidating	22	5	257	4	liquidating
lixiviating	22	5	196	4	li_xiviating
masticating	16	4	783	4	masticating
metricating	16	4	736	4	metricating
micturating	16	4	488	4	micturating
militating	13	4	882	4	mi_litating
mistreating	14	4	928	4	mistreating
mutilating	13	4	907	4	_mutilating
nictating	12	3	757	4	nict__ating
nitrating	10	3	1267	4	ni_t_rating
outrivaling	15	4	375	4	outrivaling
passivating	17	4	378	4	passivating
patinating	13	3	987	4	_patinating
patriating	13	5	1020	4	patri_ating
reactivating	18	4	475	4	reactivating
remotivating	18	6	433	4	remotivating
rusticating	14	4	631	4	rusticating
salivating	14	4	743	4	_salivating
satiating	10	3	1180	4	_sati_ating
sibilating	13	4	696	4	si_bilating
situating	10	3	888	4	si_t_uating
striating	10	9	1419	4	_stri_ating
terminating	14	4	734	4	terminating
titivate	11	4	680	4	ti_tivat__e
titivated	13	4	544	4	ti_tivat_ed
titivates	12	4	643	4	ti_tivat_es
tittering	10	23	1031	4	titt__ering
tittuping	12	4	245	4	titt__uping
tittupping	15	4	136	4	titt_upping
triplicating	17	5	382	4	triplicating
triturating	12	4	543	4	triturating
ultimating	13	8	680	4	_ultimating
urticating	13	4	735	4	_urticating
ventilating	15	4	633	4	ventilating
vindicating	18	4	464	4	vindicating

Search took 10 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	148819	0.156	1145455.1
2	DLD Change Limit	148819	79	8.830	16853.8
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	9.032	19784.2