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

Here are the results of your fuzzy-string dictionary search for “precatory” with Change Limit: [1] [2] [3] [4]

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.

64 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
precatory	16	4	912	(None)
predatory	15	4	771	1	predatory
prefatory	17	4	669	1	prefatory
crematory	16	4	722	2	crematory
deprecatory	19	5	437	2	deprecatory
imprecatory	20	5	351	2	imprecatory
piscatory	16	4	527	2	piscatory
placatory	16	4	572	2	placatory
preceptory	19	4	548	2	preceptory
predator	11	3	1006	2	predator_
predators	12	3	1009	2	predators
predicatory	19	4	557	2	predicatory
probatory	16	4	711	2	probatory
rectory	12	35	1273	2	_rec_tory
aleatory	11	4	883	3	ale_atory
appreciatory	21	5	322	3	appreciatory
creator	9	37	1445	3	cre_ator_
creators	10	28	1442	3	cre_ators
cremator	12	6	920	3	cremator_
cremators	13	6	983	3	cremators
depreciatory	20	6	343	3	depreciatory
depredatory	18	5	317	3	depredatory
directory	15	4	588	3	direc_tory
educatory	15	4	544	3	educatory
erector	9	35	1381	3	erec_tor_
erectors	10	35	1426	3	erec_tors
executory	21	4	372	3	executory
oratory	10	3	940	3	or__atory
palpatory	16	4	523	3	palpatory
peremptory	19	5	311	3	peremptory
persecutory	18	5	262	3	persecutory
piscator	12	4	692	3	piscator_
piscators	13	4	708	3	piscators
potatory	13	4	841	3	p_otatory
precative	16	3	1257	3	precative
precentor	13	4	873	3	precentor_
precentors	14	8	834	3	precentors
preceptor	15	4	732	3	preceptor_
preceptors	16	5	705	3	preceptors
precursory	17	5	205	3	precursory
prehistory	18	4	533	3	prehistory
prelature	11	4	627	3	prelature
prelusory	14	4	288	3	prelusory
premature	13	4	779	3	premature
preparatory	18	5	377	3	preparatory
prestore	10	42	1735	3	pre_store
pretor	8	3	1575	3	pre__tor_
pretors	9	3	1681	3	pre__tors
proctor	11	3	1043	3	proc_tor_
proctors	12	3	1151	3	proc_tors
pronator	10	3	1178	3	pronator_
pronators	11	4	1130	3	pronators
protectory	17	15	748	3	protec_tory
pulsatory	14	7	461	3	pulsatory
purgatory	15	4	441	3	purgatory
reactor	9	30	1166	3	_reactor_
reactors	10	32	1229	3	_reactors
recarry	12	4	506	3	_reca_rry
rector	8	40	1975	3	_rec_tor_
rectors	9	35	2052	3	_rec_tors
relator	7	40	1638	3	_relator_
relators	8	33	1614	3	_relators
rogatory	12	4	615	3	_rogatory
rotatory	11	4	721	3	_rotatory

Search took 8 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	148641	0.420	425454.8
2	DLD Change Limit	148641	64	6.563	22648.3
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.016	25469.1