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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

113 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
locative	13	3	868	(None)
locatives	14	4	656	1	locatives
vocative	16	3	791	1	vocative
coactive	15	9	862	2	coactive
conative	13	12	1462	2	conative
donative	12	13	987	2	donative
evocative	17	4	629	2	evocative
laxative	18	4	509	2	laxative
ligative	12	5	880	2	ligative
localise	10	15	1185	2	localise
localite	10	14	1154	2	localite
localize	19	14	1048	2	localize
locate	8	39	1984	2	locat__e
locating	11	3	1150	2	locating
location	10	21	1391	2	location
lucrative	14	4	586	2	lucrative
placative	16	4	622	2	placative
rotative	11	3	1034	2	rotative
vocatives	17	4	588	2	vocatives
ablative	13	4	824	3	ablative
active	11	3	1374	3	_ac_tive
advocative	19	4	396	3	advocative
amative	12	3	1173	3	_amative
bioactive	16	4	413	3	bioactive
captive	14	3	897	3	__captive
cocaine	11	13	1517	3	coca_ine
combative	18	4	721	3	combative
costive	12	3	1284	3	co_stive
creative	13	28	1280	3	creative
curative	13	3	1040	3	curative
dative	10	3	1181	3	__dative
dilative	12	3	952	3	dilative
donatives	13	14	690	3	donatives
durative	12	3	907	3	durative
educative	15	13	655	3	educative
elative	10	3	1245	3	_elative
elective	13	3	1100	3	elec_tive
enactive	13	3	851	3	enactive
ergative	12	3	897	3	ergative
fictive	15	3	702	3	fic_tive
fixative	21	4	508	3	fixative
focalise	13	12	1037	3	focalise
focalize	22	13	950	3	focalize
formative	17	4	796	3	formative
fricative	17	4	674	3	fricative
hortative	15	4	643	3	hortative
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
inactive	13	4	820	3	inactive
lacerative	15	5	628	3	lacerative
laudative	13	4	475	3	laudative
laxatives	19	4	335	3	laxatives
legatine	9	13	1140	3	legatine
lenitive	11	4	849	3	lenitive
loathe	9	42	1138	3	lo_at_he
lobate	8	29	1524	3	lobat__e
lobation	10	21	1055	3	lobation
locale	8	39	1565	3	loca__le
localised	12	16	786	3	localised
localises	11	14	1146	3	localises
localism	12	13	1001	3	localism
localist	10	16	1396	3	localist
localites	11	12	1043	3	localites
locality	13	14	843	3	locality
localized	21	16	883	3	localized
localizer	20	14	771	3	localizer
localizes	20	15	1054	3	localizes
locatable	13	4	557	3	locatable
located	10	31	1418	3	locat_ed
locater	9	31	1360	3	locat_er
locaters	10	27	1007	3	locaters
locates	9	32	1881	3	locat_es
locations	11	25	1274	3	locations
locator	9	31	1042	3	locat_or
locators	10	29	1043	3	locators
locomotive	17	5	244	3	locomotive
locution	10	22	766	3	locution
longtime	11	4	436	3	longtime
monitive	13	4	999	3	monitive
motive	11	31	1214	3	mo__tive
mutative	13	4	828	3	mutative
native	9	6	1301	3	__native
negative	12	3	908	3	negative
nonactive	14	4	897	3	nonactive
nonnative	12	4	834	3	nonnative
normative	14	4	889	3	normative
octave	11	15	734	3	_oc_tave
olfactive	17	4	346	3	olfactive
optative	13	4	765	3	optative
portative	14	4	937	3	portative
positive	13	4	999	3	positive
precative	16	3	1257	3	precative
proactive	16	4	836	3	proactive
probative	16	4	917	3	probative
putative	13	4	837	3	putative
reactive	13	3	1047	3	reactive
relative	11	3	1314	3	relative
sanative	11	3	1047	3	sanative
sedative	12	3	885	3	sedative
siccative	16	4	510	3	siccative
sonatine	8	3	1332	3	sonatine
sorptive	13	4	647	3	sorptive
stative	10	26	1293	3	_stative
tractive	13	3	1004	3	tractive
violative	15	4	511	3	violative
vocalise	13	15	1081	3	vocalise
vocalize	22	13	1015	3	vocalize
vocation	13	23	1198	3	vocation
vocatively	21	4	447	3	vocatively
volatile	11	4	643	3	volatile
volitive	14	4	689	3	volitive
vomitive	16	4	585	3	vomitive
votive	12	34	893	3	vo__tive

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	146162	0.410	435831.7
2	DLD Change Limit	146162	113	7.873	18565.0
3	Display Results	113	113	0.046	2456.5
	(SQL Overall)	178691	113	8.329	21454.1