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

Here are the results of your fuzzy-string dictionary search for “prelocated” 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
prelocated	15	9	718	(None)
prelocate	13	10	951	1	prelocate_
prelocates	14	6	835	1	prelocates
relocated	12	7	1081	1	_relocated
predicated	16	4	914	2	predicated
prelected	14	3	913	2	prelec_ted
preloaded	13	3	592	2	prelo_aded
relocate	10	7	1353	2	_relocate_
relocatee	11	8	1063	2	_relocatee
relocates	11	7	1293	2	_relocates
allocated	12	4	809	3	_allocated
areolated	10	8	971	3	are_olated
collocated	15	4	616	3	collocated
colocated	14	3	961	3	_colocated
dislocated	14	9	752	3	dislocated
located	10	31	1418	3	___located
mislocated	15	19	625	3	mislocated
percolated	15	4	824	3	percolated
perforated	16	5	689	3	perforated
perorated	12	4	1246	3	p_erorated
personated	13	25	829	3	personated
phenolated	16	4	524	3	phenolated
placated	13	3	845	3	p__lacated
plicated	13	3	1064	3	p__licated
praelected	15	4	439	3	praelec_ted
preacted	13	27	1094	3	pre_ac_ted
precited	13	30	1381	3	pre__cited
predated	12	5	1327	3	pre__dated
predicate	14	4	1177	3	predicate_
predicates	15	4	1082	3	predicates
predicted	15	3	891	3	predic_ted
preelected	15	4	578	3	preelec_ted
preenacted	15	4	497	3	preenacted
preexcited	22	4	350	3	preexcited
prefocused	18	4	344	3	prefocused
preheated	15	3	981	3	pre_heated
prelate	9	5	1969	3	prel__ate_
prelates	10	4	1857	3	prel__ates
prelimited	15	4	549	3	prelimited
preload	10	4	981	3	prelo_a__d
prelocating	16	4	741	3	prelocating
presoaked	16	3	565	3	preso_aked
presorted	12	3	945	3	preso_rted
pretreated	13	4	762	3	pretreated
probated	13	4	1086	3	pr__obated
pronated	11	4	1405	3	pr__onated
prorated	11	5	1371	3	pr__orated
prorogated	14	4	572	3	prorogated
protonated	13	4	859	3	protonated
reallocated	14	4	377	3	_reallocated
recoated	11	34	1678	3	_reco_ated
refloated	13	4	701	3	_reflo_ated
related	8	33	2757	3	_rel__ated
relegated	11	3	976	3	_relegated
reloaded	10	5	910	3	_relo_aded
reloaned	9	3	972	3	_relo_aned
relocatees	12	7	522	3	_relocatees
relocked	15	21	774	3	_reloc_ked
reluctated	13	4	594	3	_reluctated
relucted	11	3	865	3	_reluc_ted
renovated	13	4	717	3	_renovated
replicated	15	4	877	3	_replicated
resonated	10	5	1061	3	_resonated
unlocated	12	3	838	3	_unlocated

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	64	6.220	22605.0
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	6.642	26903.2