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

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

69 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
preempting	17	4	539	(None)
preediting	14	4	793	2	preediting
preemption	16	10	525	2	preemption
preemptions	17	13	485	2	preemptions
preemptive	19	4	414	2	preemptive
preexempting	26	6	137	2	preexempting
prompting	16	3	720	2	pr_ompting
attempting	15	4	292	3	attempting
coempting	16	3	607	3	_coempting
creeping	13	33	1010	3	cree_p_ing
cremating	14	3	1220	3	cr_emating
exempting	21	4	422	3	_exempting
greeting	10	31	1235	3	gree__ting
peeping	12	36	1521	3	p_ee_p_ing
permeating	15	3	992	3	permeating
permuting	14	4	655	3	p_ermuting
preacting	14	24	1253	3	pr_eacting
preadapting	17	4	365	3	preadapting
preadopting	17	4	399	3	preadopting
precasting	15	16	983	3	precasting
precenting	15	10	1215	3	precenting
precomputing	21	5	327	3	precomputing
precutting	15	4	642	3	precutting
predating	13	5	1465	3	pr_edating
predicting	16	4	987	3	predicting
preeing	10	38	1767	3	pree___ing
preelecting	16	4	647	3	preelecting
preempt	13	3	772	3	preempt___
preempted	16	4	468	3	preempt_ed
preemptor	15	4	415	3	preempt_or
preemptors	16	4	423	3	preemptors
preempts	14	4	454	3	preempt__s
preenacting	16	12	537	3	preenacting
preening	11	31	1584	3	pree__ning
preerecting	16	4	614	3	preerecting
preexciting	23	4	375	3	preexciting
preexisting	21	4	422	3	preexisting
preexposing	23	5	261	3	preexposing
preheating	16	3	1072	3	preheating
preimposing	18	4	290	3	preimposing
prelecting	15	3	1016	3	prelecting
prelimiting	16	4	538	3	prelimiting
premising	14	4	1241	3	pr_emising
premixing	21	5	780	3	pr_emixing
prepasting	15	16	888	3	prepasting
prepping	12	30	976	3	pr_e_pping
presenting	13	10	1302	3	presenting
presetting	13	10	1083	3	presetting
presifting	16	3	808	3	presifting
presorting	13	3	998	3	presorting
pretaping	14	3	913	3	pretap_ing
pretasting	13	23	928	3	pretasting
pretesting	13	18	1068	3	pretesting
pretexting	20	20	697	3	pretexting
pretyping	17	6	494	3	pretyp_ing
preuniting	13	4	730	3	preuniting
preventing	16	12	1026	3	preventing
prewriting	16	4	724	3	prewriting
priesting	12	3	948	3	prie_sting
primping	15	33	889	3	pr_imp_ing
promoting	14	3	992	3	pr_omoting
receipting	15	4	675	3	_receipting
reediting	11	3	1095	3	_reediting
reemitting	13	4	663	3	_reemitting
reesting	9	31	1827	3	_ree_sting
remating	11	23	2242	3	_r_emating
remeeting	12	3	1143	3	_remeeting
remelting	12	3	1170	3	_remelting
tempting	13	5	734	3	__tempting

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	69	6.530	21531.9
3	Display Results	69	69	0.033	2090.9
	(SQL Overall)	178691	69	6.969	25640.8