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

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

123 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
oscillating	14	4	398	(None)
oscillation	13	4	550	2	oscillation
oscillations	14	4	512	2	oscillations
osculating	13	4	738	2	osc_ulating
vacillating	17	4	462	2	vacillating
collating	12	3	1278	3	__collating
conciliating	17	7	562	3	conciliating
decollating	15	4	597	3	decollating
escalating	13	4	709	3	esc_alating
oppilating	15	4	486	3	oppi_lating
oscillate	11	4	547	3	oscillat__e
oscillated	13	4	385	3	oscillat_ed
oscillates	12	4	477	3	oscillat_es
oscillational	15	5	223	3	oscillational
oscillator	12	13	371	3	oscillat_or
oscillators	13	11	364	3	oscillators
oscillatory	16	13	311	3	oscillatory
titillating	12	4	371	3	titillating
acclimating	18	4	529	4	acclimating
acidulating	15	4	429	4	_acidulating
acierating	13	4	832	4	_acierating
acylating	15	4	757	4	_ac_ylating
affiliating	18	4	417	4	affiliating
aspirating	13	4	836	4	aspi_rating
assimilating	15	5	352	4	assimilating
auscultating	15	5	253	4	auscultating
billeting	12	3	664	4	__billeting
cantillating	15	6	505	4	cantillating
cellaring	12	3	853	4	__cellaring
chelating	15	4	936	4	__chelating
cleating	11	35	1814	4	__c_leating
collaging	13	3	793	4	__collaging
collaring	12	3	1056	4	__collaring
colleting	12	3	1106	4	__colleting
constellating	16	5	326	4	constellating
decimating	16	4	876	4	deci_mating
depilating	14	3	919	4	depi_lating
dilating	10	27	1491	4	__di_lating
domiciliating	19	9	137	4	domiciliating
epilating	12	3	1097	4	_epi_lating
escalading	14	4	357	4	esc_alading
escalloping	16	5	215	4	escalloping
escheating	16	4	588	4	esc_heating
estimating	13	4	888	4	esti_mating
estivating	14	4	763	4	esti_vating
etiolating	11	4	698	4	_etiolating
exculpating	23	4	355	4	exculpating
facilitating	18	5	401	4	facilitating
fascinating	17	4	525	4	fasci_nating
fellating	13	3	925	4	__fellating
fibrillating	18	5	272	4	fibrillating
filiating	13	3	925	4	__filiating
filleting	13	3	585	4	__filleting
fusillading	16	9	159	4	fusillading
humiliating	17	4	408	4	humiliating
inculcating	16	4	554	4	inculcating
inculpating	16	4	522	4	inculpating
inosculating	15	5	381	4	inosc_ulating
isolating	10	3	974	4	is__olating
jaculating	20	4	730	4	jac_ulating
jubilating	20	4	523	4	jubi_lating
legislating	13	4	341	4	legislating
maculating	15	4	955	4	mac_ulating
mutilating	13	4	908	4	muti_lating
nucleating	13	4	694	4	nuc_leating
obligating	14	4	581	4	obli_gating
obviating	15	4	505	4	obvi__ating
occulting	14	4	510	4	o_ccul_ting
officiating	20	5	292	4	officiating
opiating	11	4	1009	4	o_pi__ating
osculation	12	4	967	4	osc_ulation
osculations	13	4	837	4	osc_ulations
outbleating	14	4	488	4	outbleating
outfloating	15	4	436	4	outfloating
ovulating	13	3	695	4	o__vulating
oxalating	17	4	580	4	o__xalating
oxidating	18	4	505	4	o_xi_dating
peculating	15	4	916	4	pec_ulating
pillaging	13	4	557	4	__pillaging
pillaring	12	3	765	4	__pillaring
postulating	14	4	750	4	pos_tulating
reviolating	15	5	626	4	reviolating
sailboating	14	5	346	4	_sailboating
sailplaning	14	5	199	4	_sailplaning
salivating	14	4	744	4	_salivating
scalloping	15	4	395	4	_scalloping
scarlatina	12	9	405	4	_scarlatina
schilling	15	28	639	4	_schill__ing
scintillating	16	6	219	4	_sc~~int~~illating
scolloping	15	4	324	4	_scolloping
sculling	11	29	1099	4	_scull__ing
sculpting	14	3	500	4	_sc_ulpting
shilling	12	33	1538	4	_shill__ing
sibilating	13	4	697	4	_sibilating
silting	8	33	2048	4	_s_i_l_ting
simulating	13	4	761	4	_simulating
sinuating	10	3	968	4	_s_inuating
situating	10	3	888	4	_s_ituating
skilling	13	29	1133	4	_skill__ing
slating	8	37	2465	4	_s___lating
socialising	14	4	564	4	socialising
socializing	23	4	734	4	socializing
solating	9	3	1559	4	_s__olating
solvating	13	3	644	4	_s_olvating
sonicating	13	4	831	4	soni_cating
spilling	11	31	1394	4	_spill__ing
spoliating	13	6	696	4	_spoliating
stilling	9	34	1532	4	_still__ing
stilting	9	33	1240	4	_sti_l_ting
stimulating	14	4	568	4	_stimulating
stipulating	14	4	516	4	_stipulating
sublating	12	3	1098	4	_s_ublating
sufflating	17	4	484	4	_sufflating
sulfating	13	3	806	4	_s_ulfating
swilling	12	35	1193	4	_swill__ing
tailgating	12	4	491	4	_tailgating
tessellating	13	5	218	4	tessellating
vacillatingly	22	6	125	4	vacillatingly
vacillation	16	4	532	4	vacillation
vacillations	17	4	488	4	vacillations
variolating	15	4	494	4	variolating
vesiculating	18	4	467	4	vesiculating
violating	13	3	744	4	__violating

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	123	8.450	17611.7
3	Display Results	123	123	0.063	1952.4
	(SQL Overall)	178691	123	8.936	19996.8