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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

111 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
deactivated	18	4	373	(None)
deactivate	16	4	462	1	deactivate_
deactivates	17	4	439	1	deactivates
reactivated	17	4	497	1	reactivated
activated	15	6	788	2	__activated
deactivator	17	5	284	2	deactivator
inactivated	17	4	455	2	inactivated
reactivate	15	4	584	2	reactivate_
reactivates	16	4	561	2	reactivates
activate	13	5	1037	3	__activate_
activates	14	4	968	3	__activates
aestivated	14	10	629	3	ae_stivated
captivated	18	4	476	3	_captivated
deactivating	19	5	345	3	deactivating
deactivation	18	15	608	3	deactivation
deactivators	18	5	257	3	deactivators
deaminated	14	4	801	3	dea_minated
decapitated	17	4	494	3	decapitated
decimated	15	4	895	3	de_c_imated
deracinated	15	4	486	3	derac_inated
estivated	13	10	832	3	_e_stivated
inactivate	15	4	569	3	inactivate_
inactivates	16	4	504	3	inactivates
nonactivated	18	5	362	3	nonactivated
remotivated	17	4	414	3	remotivated
activator	14	4	644	4	__activator
activized	24	4	520	4	__activized
actuated	11	3	875	4	__act_uated
aestivate	12	12	766	4	ae_stivate_
aestivates	13	10	736	4	ae_stivates
brachiated	18	4	467	4	brachi_ated
captivate	16	4	592	4	_captivate_
captivates	17	4	549	4	_captivates
castigated	14	4	632	4	_castigated
cultivated	16	4	567	4	_cultivated
deactivations	19	17	506	4	deactivations
deadlifted	16	4	239	4	deadli_fted
deaerated	11	3	1112	4	dea__erated
dealated	10	32	1360	4	dea___lated
deaminate	12	4	1017	4	dea_minate_
deaminates	13	4	938	4	dea_minates
debilitated	15	4	381	4	debilitated
decapitate	15	4	587	4	decapitate_
decapitates	16	5	564	4	decapitates
deceived	15	3	589	4	de_ceiv__ed
decimate	13	4	1112	4	de_c_imate_
decimates	14	4	1069	4	de_c_imates
decollated	14	13	628	4	de_collated
decorated	13	3	1221	4	de_c_orated
decorticated	18	14	417	4	decorticated
decussated	14	4	289	4	de_cussated
dedicated	14	3	1025	4	de__dicated
defoliated	15	4	583	4	defoli_ated
deglaciated	16	5	240	4	deglac_i_ated
delaminated	15	4	578	4	delaminated
delectated	14	4	672	4	delect__ated
denervated	15	4	511	4	de_nervated
denitrated	12	9	803	4	denit_rated
denominated	15	16	625	4	denominated
dentated	10	4	1170	4	de_nt__ated
depilated	13	3	965	4	de__pilated
deracinate	13	5	656	4	derac_inate_
deracinates	14	4	586	4	derac_inates
derivate	12	3	1120	4	de__rivate_
derivates	13	3	1009	4	de__rivates
desalinated	13	4	577	4	desalinated
destituted	12	5	525	4	de_stituted
detonated	11	3	821	4	de__tonated
detoxicated	22	5	349	4	detoxicated
deuterated	12	4	754	4	de_uterated
devastated	15	4	412	4	devast__ated
deviated	13	3	1104	4	de__vi_ated
dictated	12	3	920	4	d_ict__ated
echinated	15	4	648	4	_e_chinated
emaciated	14	4	693	4	emac_i_ated
estimated	12	10	944	4	_e_stimated
estivate	11	10	1000	4	_e_stivate_
estivates	12	10	975	4	_e_stivates
excavated	22	4	389	4	_exc_avated
festinated	14	4	753	4	fe_stinated
fractionated	18	5	308	4	fractionated
glaciated	13	6	576	4	glac_i_ated
lactated	11	3	887	4	_lact__ated
legitimated	15	5	369	4	legitimated
machinated	18	4	566	4	_machinated
masticated	15	4	823	4	_masticated
motivated	15	4	596	4	__motivated
negotiated	12	4	445	4	negoti_ated
nictitated	13	4	440	4	_nictitated
passivated	16	4	414	4	_passivated
patinated	12	39	1141	4	_pa_tinated
pectinate	13	4	955	4	pe_ctinate_
quantitated	21	5	293	4	quantitated
reactivating	18	4	475	4	reactivating
reactivation	17	17	695	4	reactivation
reactive	13	3	1047	4	reactiv__e_
reactivities	17	5	617	4	reactivities
reactivity	18	4	540	4	reactivit_y
reanimated	13	4	700	4	rea_nimated
recultivated	18	5	311	4	recultivated
reestimated	14	4	595	4	reestimated
remotivate	15	4	483	4	remotivate_
remotivates	16	4	477	4	remotivates
revaccinated	20	14	301	4	revaccinated
salivated	13	3	747	4	_sa_livated
satiated	9	3	1160	4	_sa_ti_ated
titivated	13	4	544	4	__titivated
tittivated	14	4	290	4	_tittivated
unmotivated	17	5	351	4	unmotivated
vaccinated	18	5	544	4	_vaccinated
ventilated	14	4	636	4	ve_ntilated

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.406	440125.6
2	DLD Change Limit	148819	111	8.576	17353.0
3	Display Results	111	111	0.063	1761.9
	(SQL Overall)	178691	111	9.045	19755.8