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

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

72 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
sacrificers	18	13	222	(None)
sacrificer	17	13	306	1	sacrificer_
sacrifices	17	13	441	1	sacrifice_s
sacrifice	16	13	453	2	sacrifice__
sacrificed	18	13	337	2	sacrifice_d
scarifiers	15	4	410	2	scarifi_ers
artificers	15	4	349	3	_artificers
pacifiers	16	4	546	3	pac_ifi_ers
sacrificial	18	5	218	3	sacrificial
sacrificing	19	5	232	3	sacrificing
sanctifiers	16	5	237	3	sanctifi_ers
scarifier	14	4	665	3	scarifi_er_
scarifies	14	3	960	3	scarifi_e_s
scorifiers	15	4	360	3	scorifi_ers
tackifiers	19	4	293	3	tackifi_ers
accipiters	16	16	281	4	_accipiters
acetifiers	15	4	340	4	_acetifi_ers
acidifiers	16	11	322	4	_acidifi_ers
acridines	12	4	772	4	_acridine_s
aerifies	11	13	1339	4	_aerifi_e_s
artificer	14	4	402	4	_artificer_
artifices	14	4	647	4	_artifice_s
basifiers	14	4	520	4	ba_sifi_ers
clarifiers	15	4	401	4	clarifi_ers
falsifiers	16	4	323	4	falsifi_ers
gasifiers	13	4	452	4	ga_sifi_ers
glorifiers	14	4	259	4	glorifi_ers
magnifiers	16	4	381	4	magnifi_ers
micrifies	16	11	867	4	micrifi_e_s
nitrifiers	13	4	392	4	nitrifi_ers
opacifiers	17	4	251	4	opac_ifi_ers
orifices	13	4	648	4	__orifice_s
pacifier	15	5	750	4	pac_ifi_er_
pacifies	15	3	1122	4	pac_ifi_e_s
petrifiers	15	4	467	4	petrifi_ers
purifiers	14	3	587	4	_purifi_ers
rarefiers	12	4	402	4	ra_refi_ers
rarifies	11	3	1193	4	ra_rifi_e_s
ratifiers	12	3	645	4	ra_tifi_ers
rectifiers	15	4	517	4	rectifi_ers
sacralizes	21	4	823	4	sacralize_s
sacrileges	13	5	273	4	sacrilege_s
sacristies	12	7	603	4	sacristie_s
salifies	11	3	1479	4	sa_lifi_e_s
salsifies	12	4	725	4	salsifi_e_s
sanctifier	15	5	349	4	sanctifi_er_
sanctifies	15	5	498	4	sanctifi_e_s
sanitizers	19	10	449	4	sa_nitizers
saponifiers	16	5	186	4	saponifi_ers
satirizers	19	4	395	4	sa_tirizers
satisfices	15	4	276	4	satisfice_s
satisfiers	13	4	271	4	satisfi_ers
scarfers	13	40	846	4	scar_f__ers
scarified	15	4	729	4	scarifi_e_d
scimiters	13	4	512	4	s_c_imiters
scorifier	14	4	541	4	scorifi_er_
scorifies	14	4	802	4	scorifi_e_s
scribblers	16	18	310	4	s_cribblers
scribers	12	30	796	4	s_cr__ibers
scrimpers	15	5	464	4	s_cri_mpers
scripters	13	11	668	4	s_cri_pters
scriveners	15	4	314	4	s_criveners
servicers	14	4	466	4	s_er_vicers
signifiers	14	4	418	4	signifi_ers
specifiers	17	4	380	4	specifi_ers
sterilizers	20	4	362	4	sterilizers
sufficers	17	20	453	4	s__ufficers
surfacers	14	4	432	4	s_ur_facers
tackifier	18	4	414	4	tackifi_er_
tackifies	18	4	578	4	tackifi_e_s
terrifiers	13	14	457	4	terrifi_ers
verifiers	15	16	606	4	_verifi_ers

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.423	422437.4
2	DLD Change Limit	148819	72	9.326	15957.4
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	9.782	18267.3