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

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

151 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
sublimating	16	7	546	(None)
sublating	12	3	1098	2	subl__ating
sublimation	15	5	718	2	sublimation
sublimations	16	4	608	2	sublimations
subliming	14	4	654	2	sublim__ing
acclimating	18	4	529	3	acclimating
collimating	16	4	543	3	collimating
duplicating	17	4	540	3	duplicating
jubilating	20	4	523	3	jub_ilating
lubricating	16	4	471	3	lubricating
obligating	14	4	581	3	_obligating
rubricating	16	4	510	3	rubricating
salivating	14	4	744	3	s_alivating
sibilating	13	4	697	3	sib_ilating
spoliating	13	6	696	3	spoli_ating
stalemating	14	4	468	3	stalemating
subjugating	22	5	291	3	subjugating
subleasing	13	4	552	3	subl_easing
subletting	13	4	627	3	subl_etting
sublimate	13	4	744	3	sublimat__e
sublimated	15	4	587	3	sublimat_ed
sublimates	14	4	717	3	sublimat_es
sublimities	15	4	580	3	sublimities
submitting	15	4	497	3	submi_tting
subrogating	15	16	498	3	subrogating
subsisting	13	4	553	3	subsi_sting
sulfating	13	3	806	3	su_l_fating
sulphating	16	4	432	3	su_lphating
summating	14	3	794	3	su__mmating
supinating	13	5	783	3	su_pinating
supplicating	19	5	374	3	supplicating
ultimating	13	8	680	3	_ultimating
abdicating	16	8	615	4	_abdicating
ablating	11	3	1200	4	_abl__ating
animating	12	3	1251	4	__animating
auspicating	16	4	460	4	auspicating
automating	13	8	930	4	au_tomating
bleating	11	35	1450	4	__bl_eating
blighting	16	3	573	4	__blighting
bloating	11	35	1281	4	__bl_oating
bromating	14	3	918	4	__bromating
busticating	16	4	530	4	busticating
climaxing	21	4	349	4	__climaxing
colligating	15	4	571	4	colligating
culminating	16	4	573	4	culminating
cultivating	17	4	494	4	cultivating
debilitating	16	5	411	4	debilitating
decimating	16	4	876	4	_decimating
delimiting	14	4	584	4	_delimiting
estimating	13	4	888	4	_estimating
explicating	23	5	612	4	explicating
fabricating	19	4	503	4	fabricating
filiating	13	3	925	4	_fili_ating
foliating	13	3	925	4	_foli_ating
fulminating	17	4	468	4	fulminating
fumigating	17	4	465	4	fu_migating
fustigating	16	5	405	4	fustigating
habilitating	18	5	338	4	habilitating
humiliating	17	4	408	4	humiliating
imbricating	18	4	452	4	imbricating
implicating	18	5	574	4	implicating
intimating	13	4	1082	4	_intimating
ligating	10	22	1228	4	___ligating
limiting	11	3	881	4	___limiting
militating	13	4	882	4	_militating
mutilating	13	4	908	4	mu_tilating
nucleating	13	4	694	4	nucl_eating
obviating	15	4	505	4	_obvi_ating
outbleating	14	4	488	4	outbl_eating
palliating	13	4	789	4	palli_ating
pollinating	14	4	562	4	pollinating
prelimiting	16	4	538	4	prelimiting
publication	17	4	657	4	publication
publications	18	4	583	4	publications
publicising	18	5	276	4	publicising
publicizing	27	6	348	4	publicizing
publishing	18	4	400	4	publi_shing
pullulating	14	4	295	4	pullulating
pulsating	12	3	634	4	pu_l_sating
reanimating	14	4	723	4	reanimating
replicating	16	4	909	4	replicating
ruinating	10	3	959	4	ru__inating
ruminating	13	4	814	4	ru_minating
rusticating	14	4	631	4	rusticating
sailboating	14	5	346	4	sailboating
sanitating	11	4	965	4	s_anitating
satiating	10	3	1181	4	s_ati_ating
sealifting	14	4	463	4	seali_fting
seriating	10	9	1640	4	s_eri_ating
slating	8	37	2465	4	s__l__ating
slighting	14	3	637	4	s__lighting
sliming	10	29	1395	4	s__lim__ing
slimming	13	28	809	4	s__lim_ming
slitting	9	30	1258	4	s__li_tting
solating	9	3	1559	4	s_ol__ating
soliciting	13	4	681	4	s_oliciting
solvating	13	3	644	4	s_ol_vating
sonicating	13	4	831	4	s_onicating
speciating	15	4	812	4	speci_ating
splinting	12	3	819	4	s_pli_nting
splitting	12	3	656	4	s_pli_tting
striating	10	9	1419	4	s_tri_ating
subdividing	19	5	235	4	subdividing
subducting	16	4	431	4	sub_ducting
subediting	14	4	530	4	sub_editing
subheading	17	4	379	4	sub_heading
subirrigating	17	6	174	4	subirrigating
subjecting	22	4	555	4	sub_jecting
sublation	11	3	1101	4	subl__ation
sublations	12	4	1011	4	subl__ations
sublicensing	17	5	156	4	sublicensing
sublimable	16	4	350	4	sublima_ble
subliminal	14	5	341	4	sublim__inal
sublimit	12	4	751	4	sublim__i_t
sublimits	13	4	556	4	sublim__its
sublimity	16	4	493	4	sublim__ity
subluxation	20	4	382	4	subluxation
subluxations	21	4	338	4	subluxations
submarine	13	4	784	4	sub__marine
subordinating	17	5	309	4	subordinating
subpenaing	15	4	463	4	subpena_ing
subsampling	18	5	163	4	subsampling
subsiding	13	4	634	4	subsi__ding
subsidising	15	5	346	4	subsidising
subsidizing	24	5	411	4	subsidizing
substituting	15	5	324	4	substituting
subsuming	14	4	427	4	subsum__ing
subtilizing	23	4	600	4	subtilizing
subtitling	13	4	456	4	subti_tling
subtotaling	14	5	301	4	subtotaling
subtracting	16	4	527	4	subtracting
subverting	16	6	629	4	sub_verting
subwaying	18	4	387	4	sub__waying
sufflating	17	4	484	4	su_fflating
suffocating	20	5	288	4	suffocating
suiting	8	34	1900	4	su__i__ting
sulfonating	15	4	367	4	sulfonating
sulfurating	15	9	457	4	sulfurating
summiting	14	4	579	4	su__mmiting
suppurating	16	4	459	4	suppurating
surrogating	13	19	432	4	surrogating
susurrating	12	11	401	4	susurrating
syndicating	18	4	373	4	syndicating
tubulating	13	4	559	4	tub_ulating
ululating	10	3	664	4	_u_lulating
uplifting	15	3	496	4	_upli_fting
uplighting	17	4	336	4	_uplighting
urinating	10	3	1065	4	_u_rinating
urticating	13	4	735	4	_urticating
validating	15	4	584	4	_validating
vellicating	17	4	456	4	vellicating

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.440	406115.9
2	DLD Change Limit	148819	151	9.216	16147.9
3	Display Results	151	151	0.080	1887.5
	(SQL Overall)	178691	151	9.736	18353.6