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

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

157 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
vacillating	17	4	462	(None)
oscillating	14	4	398	2	oscillating
vacillatingly	22	6	125	2	vacillatingly
vacillation	16	4	532	2	vacillation
vacillations	17	4	488	2	vacillations
variolating	15	4	494	2	variolating
acidulating	15	4	429	3	_acidulating
acierating	13	4	832	3	_acierating
acylating	15	4	757	3	_ac_ylating
cantillating	15	6	505	3	cantillating
collating	12	3	1277	3	__collating
decollating	15	4	597	3	decollating
facilitating	18	5	401	3	facilitating
jaculating	20	4	730	3	jac_ulating
maculating	15	4	955	3	mac_ulating
tailgating	12	4	491	3	ta_ilgating
titillating	12	4	371	3	titillating
vacating	14	3	1036	3	vac___ating
vaccinating	19	4	519	3	vaccinating
vacillant	14	4	473	3	vacilla__nt
vacillate	14	5	685	3	vacillat__e
vacillated	16	5	463	3	vacillat_ed
vacillates	15	5	572	3	vacillat_es
vacillator	15	4	350	3	vacillat_or
vacillators	16	5	333	3	vacillators
validating	15	4	584	3	vali_dating
valuating	13	3	865	3	va__luating
variating	13	3	1095	3	vari__ating
variegating	16	4	321	3	variegating
violating	13	3	744	3	v__iolating
ablating	11	3	1200	4	_a__blating
acclimating	18	4	529	4	_acclimating
accolading	16	4	479	4	_accolading
acerbating	15	4	629	4	_acerbating
acetylating	17	5	328	4	_acetylating
activating	16	4	786	4	_activating
actuating	12	3	923	4	_ac_tuating
adulating	11	7	872	4	_a_dulating
affiliating	18	4	417	4	affiliating
agitating	11	3	886	4	_agi_tating
alienating	11	4	723	4	_alienating
alkylating	18	4	354	4	_alkylating
allaying	12	33	931	4	_a__llaying
ambulating	15	4	637	4	_ambulating
angulating	12	4	782	4	_angulating
animating	12	3	1251	4	_ani_mating
aviating	12	3	1102	4	_avi__ating
backdating	20	4	572	4	bac_kdating
backlisting	20	4	387	4	backlisting
backloading	21	5	382	4	backloading
ballasting	13	4	530	4	ba__llasting
balloting	12	3	839	4	ba__lloting
billeting	12	3	664	4	__billeting
cachinnating	20	9	211	4	cachinnating
calculating	16	6	679	4	calculating
calibrating	16	4	535	4	calibrating
cannulating	14	4	601	4	cannulating
canulating	13	4	955	4	ca_nulating
capitulating	17	7	397	4	capitulating
cavilling	15	3	639	4	cavill__ing
cavitating	16	4	691	4	cavi_tating
cellaring	12	3	853	4	__cellaring
chelating	15	4	936	4	__chelating
cleating	11	35	1814	4	__c_leating
collaging	13	3	792	4	__collaging
collaring	12	3	1055	4	__collaring
colleting	12	3	1106	4	__colleting
conciliating	17	7	562	4	conciliating
decimating	16	4	876	4	deci_mating
depilating	14	3	919	4	depi_lating
dilating	10	27	1491	4	__di_lating
ejaculating	21	4	483	4	ejac_ulating
emaciating	15	4	682	4	emaci__ating
epilating	12	3	1097	4	_epi_lating
escalating	13	4	709	4	esc_alating
etiolating	11	4	698	4	_etiolating
evacuating	16	4	568	4	evac__uating
evaginating	16	4	491	4	evagi_nating
evaluating	14	5	602	4	eva__luating
exculpating	23	4	355	4	exculpating
fabulating	16	4	552	4	fa_bulating
facelifting	20	5	212	4	facelifting
fascinating	17	4	525	4	fasci_nating
fellating	13	3	925	4	__fellating
fibrillating	18	5	271	4	fibrillating
filiating	13	3	925	4	__filiating
filleting	13	3	585	4	__filleting
flagellating	17	7	243	4	flagellating
fusillading	16	9	159	4	fusillading
gallanting	12	4	535	4	ga__llanting
galleting	11	3	763	4	ga__lleting
glaciating	14	4	560	4	glaci__ating
habilitating	18	5	338	4	habilitating
habituating	17	4	323	4	habituating
humiliating	17	4	408	4	humiliating
inculcating	16	4	554	4	inculcating
inculpating	16	4	522	4	inculpating
jubilating	20	4	523	4	jubi_lating
lacerating	13	4	945	4	lac_erating
lactating	12	3	919	4	lac__tating
laminating	13	4	873	4	lami_nating
lancinating	14	4	545	4	lanci_nating
lapidating	14	4	524	4	lapi_dating
lariating	10	3	1179	4	lari__ating
legislating	13	4	341	4	legislating
macerating	15	4	954	4	mac_erating
machinating	19	4	562	4	machinating
manipulating	17	5	375	4	manipulating
marinating	13	4	1027	4	mari_nating
mutilating	13	4	908	4	muti_lating
navigating	15	4	500	4	navi_gating
nucleating	13	4	694	4	nuc_leating
oppilating	15	4	486	4	oppi_lating
oscillation	13	4	550	4	oscillation
oscillations	14	4	512	4	oscillations
osculating	13	4	738	4	osc_ulating
paginating	14	4	753	4	pagi_nating
palleting	12	3	874	4	pa__lleting
palliating	13	4	789	4	pa_lliating
palpating	14	3	854	4	pa__lpating
patinating	13	3	988	4	pati_nating
peculating	15	4	916	4	pec_ulating
pillaging	13	4	556	4	__pillaging
pillaring	12	3	765	4	__pillaring
racializing	23	4	780	4	racializing
radiating	11	11	1213	4	radi__ating
radicating	14	5	907	4	radi_cating
reviolating	15	5	626	4	reviolating
sailboating	14	5	346	4	sa_ilboating
sailplaning	14	5	199	4	sa_ilplaning
salivating	14	4	744	4	sali_vating
sanitating	11	4	965	4	sani_tating
satiating	10	3	1181	4	sati__ating
sibilating	13	4	697	4	sibi_lating
tabulating	13	4	643	4	ta_bulating
tallaging	11	4	649	4	ta__llaging
vacuolation	16	4	440	4	vacuolation
vacuolations	17	4	378	4	vacuolations
vailing	11	38	1795	4	va_i_l__ing
valeting	12	3	885	4	va___leting
vallation	12	3	975	4	va__llation
vallations	13	3	909	4	va__llations
vanillin	11	4	591	4	vanill__in_
vanillins	12	4	555	4	vanill__ins
vaticinating	18	5	356	4	vaticinating
vaulting	12	22	723	4	va__ul_ting
vellicating	17	4	456	4	vellicating
ventilating	15	4	634	4	ventilating
vesicating	16	4	690	4	vesi_cating
vesiculating	18	4	467	4	vesiculating
vibrating	15	3	748	4	v__ibrating
villain	10	3	848	4	v__illa_in_
villains	11	3	801	4	v__illa_ins
villainy	14	4	488	4	v__illa_iny
villatic	13	4	623	4	v__illati_c
vitiating	13	3	841	4	v__itiating
vociferating	21	8	246	4	vociferating

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	148819	0.423	422437.4
2	DLD Change Limit	148819	157	8.233	18075.9
3	Display Results	157	157	0.093	1688.2
	(SQL Overall)	178691	157	8.749	20424.2