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

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

52 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
tournaments	13	5	290	(None)
tournament	12	5	371	1	tournament_
ornaments	11	4	663	2	_o_rnaments
inurnments	12	4	593	3	inurn_ments
ornament	10	4	913	3	_o_rnament_
torments	10	3	1045	3	to_r__ments
adjournments	22	5	197	4	adjourn_ments
adornments	13	4	516	4	adorn_ments
armaments	13	4	747	4	__armaments
atonements	12	4	720	4	ato__nements
attornments	13	5	395	4	attorn_ments
attunements	13	5	372	4	attu_nements
couplements	17	5	619	4	couplements
courants	10	3	1080	4	cour_a__nts
duramens	11	9	515	4	_dur_amen_s
firmaments	17	4	429	4	_firmaments
foramens	13	3	782	4	fo_r_amen_s
fundaments	16	5	386	4	_fundaments
gourmets	11	4	415	4	gour__me_ts
governments	17	5	542	4	govern_ments
inurements	12	4	914	4	inur_ements
inurnment	11	4	672	4	inurn_ment_
journaleses	18	5	210	4	journaleses
journalists	18	5	363	4	journalists
monuments	13	9	763	4	mo__numents
muniments	13	4	614	4	_mu_niments
nourishments	17	5	369	4	nourishments
ointments	11	6	665	4	_o_intments
ornamental	12	6	464	4	_o_rnamental
ornamentals	13	5	390	4	_o_rnamentals
ornamented	13	4	295	4	_o_rnamented
orpiments	13	4	600	4	_o_rpiments
paraments	13	5	1155	4	_par_aments
portamenti	14	5	420	4	po_rtamenti
portamento	14	6	379	4	po_rtamento
pretournament	17	6	146	4	~~pre~~tournament_
rearmaments	15	5	426	4	rearmaments
rousements	12	4	733	4	rou_sements
sacraments	14	4	585	4	sacr_aments
surnamers	11	4	380	4	_surname_rs
surnames	10	3	727	4	_surname__s
tenements	11	4	996	4	t__enements
testaments	12	6	535	4	t_estaments
torment	9	3	1617	4	to_r__ment_
torrents	8	3	814	4	to_r__rents
tourmalines	13	4	348	4	tourmalines
tournedos	10	4	253	4	tourn__edos
tourneys	11	3	401	4	tourn__e_ys
tourniquets	20	5	75	4	tourniquets
treatments	12	4	628	4	t__reatments
turnabouts	12	5	210	4	t_urnabouts
worriments	15	4	415	4	wo_rriments

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.420	425454.8
2	DLD Change Limit	148819	52	8.690	17125.3
3	Display Results	52	52	0.030	1733.3
	(SQL Overall)	178691	52	9.140	19550.4