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

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

71 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
trivialists	14	6	454	(None)
trivialises	14	8	468	1	trivialises
trivialist	13	6	607	1	trivialist_
tribalists	12	8	694	2	tri_balists
trivialise	13	6	516	2	trivialis_e
trivialised	15	6	351	2	trivialised
triviality	16	4	444	2	triviali_ty
trivializes	23	8	532	2	trivializes
privatists	15	17	605	3	priv_atists
racialists	12	4	770	3	_racialists
revivalists	17	5	356	3	_revivalists
ritualists	10	4	617	3	_ritualists
tribalisms	14	4	651	3	tri_balisms
tribalist	11	4	995	3	tri_balist_
trivialising	16	7	307	3	trivialising
trivialities	15	5	522	3	trivialities
trivialize	22	8	563	3	triviali_ze
trivialized	24	8	479	3	trivialized
aerialists	10	8	952	4	_aerialists
animalists	12	5	824	4	ani_malists
arbalists	11	4	848	4	ar__balists
aviarists	12	4	661	4	__aviarists
braillists	12	6	366	4	br_aillists
civilises	14	10	609	4	_civi_lises
dialists	9	4	1141	4	___dialists
finalists	12	30	1016	4	_fi_nalists
fiscalists	15	4	467	4	_fiscalists
gradualists	13	5	293	4	gradualists
idealists	10	4	722	4	__idealists
initialisms	13	5	614	4	initialisms
minimalists	15	11	460	4	_minimalists
nihilists	12	4	485	4	_nihi_lists
oralists	8	6	1180	4	or___alists
orientalists	12	12	577	4	orientalists
privatises	15	18	740	4	priv_atises
privatisms	17	16	595	4	priv_atisms
privatist	14	22	878	4	priv_atist_
racialisms	14	4	722	4	_racialisms
racialist	11	4	1120	4	_racialist_
realists	8	30	1484	4	_r__ealists
recitalists	13	4	650	4	_recitalists
revitalises	14	11	597	4	_revitalises
revivalisms	19	5	355	4	_revivalisms
revivalist	16	4	520	4	_revivalist_
ritualisms	12	4	600	4	_ritualisms
ritualist	9	4	864	4	_ritualist_
royalists	12	17	811	4	_r_oyalists
ruralists	9	4	764	4	_r_uralists
serialists	10	8	1036	4	_serialists
socialists	12	4	849	4	_socialists
specialists	15	4	620	4	specialists
survivalists	18	5	198	4	survivalists
timpanists	14	5	366	4	t_impanists
titlists	8	3	729	4	t___itlists
totalists	9	3	1075	4	t__otalists
triadisms	12	4	645	4	tr__iadisms
triaxiality	21	6	262	4	triaxiali_ty
tribadisms	15	4	353	4	tri_badisms
tribalism	13	4	789	4	tri_balis_m
tritheists	13	4	462	4	tri_theists
triumphalists	20	6	121	4	triumphalists
trivalent	12	4	648	4	triv_alent_
trivalves	15	4	414	4	triv_al_ves
trivial	10	3	871	4	trivial____
trivializing	25	5	441	4	trivializing
trivially	15	4	514	4	trivial__ly
troilisms	11	4	641	4	tr_oi_lisms
violists	11	3	766	4	___violists
virginalists	16	15	283	4	virginalists
visualists	13	4	489	4	_visualists
vitalists	12	3	922	4	_vi_talists

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.406	440125.6
2	DLD Change Limit	148819	71	8.156	18246.6
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	8.592	20797.4