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

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

73 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
precondition	17	5	524	(None)
preconditions	18	5	489	1	preconditions
recondition	14	4	712	1	_recondition
decondition	15	4	541	2	_decondition
precognition	17	5	388	2	precognition
preconditioned	20	6	241	2	preconditioned
preconviction	22	5	370	2	preconviction
premonition	15	4	735	2	premon_ition
reconditions	15	4	682	2	_reconditions
condition	12	4	1116	3	___condition
deconditions	16	4	528	3	_deconditions
precognitions	18	5	359	3	precognitions
preconception	21	5	428	3	preconception
preconditioning	21	6	180	3	preconditioning
preconvention	20	7	400	3	preconvention
preconvictions	23	5	335	3	preconvictions
preignition	14	5	443	3	preign_ition
premonitions	16	4	685	3	premon_itions
premunition	15	4	557	3	premun_ition
preposition	15	10	858	3	prepo_sition
recognition	14	4	520	3	_recognition
reconditioned	17	8	327	3	_reconditioned
reconviction	19	5	508	3	_reconviction
recordation	14	4	926	3	_recordation
rendition	10	5	893	3	_re__ndition
conditions	13	4	1010	4	___conditions
deconditioned	18	8	223	4	_deconditioned
fecundation	17	4	357	4	_fecundation
percolation	15	4	922	4	perco_lation
perdition	12	4	901	4	p_e__rdition
personation	13	4	948	4	person_ation
precaution	14	4	724	4	prec__aution
precipitin	16	5	586	4	prec_ipiti_n
precision	13	4	1005	4	prec___ision
precocities	17	4	816	4	preco_cities
precognitive	20	5	275	4	precognitive
precombustion	21	6	224	4	precombustion
preconceptions	22	5	388	4	preconceptions
preconciliar	18	6	214	4	preconciliar
preconizing	25	4	823	4	precon_izing
predation	12	3	1346	4	pre___dation
prediction	15	4	1030	4	pre___diction
preformation	19	4	647	4	preformation
preignitions	15	5	400	4	preign_itions
preinduction	17	5	378	4	pre_induction
premunitions	16	4	498	4	premun_itions
prenotion	11	4	917	4	pre__n_otion
preoption	13	4	808	4	pre_o__ption
preordination	16	5	615	4	pre_ordination
preponderation	19	10	322	4	preponderation
preportion	14	4	887	4	prepo__rtion
prepositions	16	10	830	4	prepo_sitions
presentation	14	4	899	4	presentation
prevention	15	4	917	4	preven__tion
prolongation	15	6	371	4	prolongation
pronation	11	4	1570	4	pr__on_ation
proposition	15	8	874	4	propo_sition
protonation	13	5	1043	4	proton_ation
recantation	13	4	986	4	_recantation
recognitions	15	4	485	4	_recognitions
reconception	18	5	565	4	_reconception
recondite	12	4	896	4	_recondit__e
reconditely	17	5	280	4	_reconditely
reconditioning	18	7	251	4	_reconditioning
reconnection	16	5	599	4	_reconnection
reconvictions	20	5	487	4	_reconvictions
recordations	15	4	864	4	_recordations
reedition	10	4	783	4	_re__edition
refoundation	16	10	279	4	_refoundation
reignition	11	4	489	4	_reign_ition
renditions	11	4	918	4	_re__nditions
reposition	12	10	1014	4	_repo_sition
vendition	13	4	569	4	_ve__ndition

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	124790	0.403	443402.0
2	DLD Change Limit	124790	73	7.376	16918.4
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	7.825	22835.9