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

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

58 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
preventions	16	4	853	(None)
prevention	15	4	917	1	prevention_
prehensions	16	4	594	2	prehensions
prelections	15	12	1047	2	prelections
pretensions	13	4	708	2	pretensions
pretentious	13	12	559	2	pretentious
preventing	16	12	1026	2	preventi_ng
preventives	19	4	572	2	preventives
retentions	10	16	1111	2	_retentions
conventions	16	4	1053	3	conventions
detentions	11	14	880	3	_detentions
evections	14	25	1069	3	__evections
inventions	13	4	831	3	_inventions
perceptions	17	9	819	3	perceptions
perfections	18	4	814	3	perfections
permeations	15	4	988	3	permeations
perversions	16	4	541	3	perversions
precautions	15	4	655	3	precautions
precenting	15	10	1215	3	precenti_ng
precentors	14	8	834	3	precent_ors
precessions	15	4	855	3	precessions
predations	13	8	1215	3	pre_dations
predictions	16	4	965	3	predictions
preemptions	17	13	485	3	preemptions
prehension	15	4	631	3	prehension_
preignitions	15	5	400	3	preignitions
prelection	14	15	1129	3	prelection_
premonitions	16	4	685	3	premonitions
premunitions	16	4	498	3	premunitions
prenotions	12	4	829	3	pre_notions
preoptions	14	4	764	3	pre_options
preportions	15	4	826	3	preportions
presentations	15	4	813	3	presentations
presentient	13	4	832	3	presentient
presenting	13	10	1302	3	presenti_ng
presentisms	15	5	521	3	presentisms
pretension	12	4	753	3	pretension_
preunions	11	4	648	3	pre_un_ions
prevenient	15	4	781	3	preven_ient
preventers	15	4	739	3	prevent_ers
preventible	18	5	442	3	preventible
preventive	18	4	754	3	preventi_ve
prevents	13	30	1229	3	prevent___s
previsions	15	4	773	3	prev_isions
privations	15	3	1010	3	priv_ations
projections	22	5	847	3	projections
protections	15	5	1070	3	protections
recensions	12	4	848	3	_recensions
receptions	14	4	974	3	_receptions
refections	15	18	1164	3	_refections
reinventions	15	5	421	3	_reinventions
rejections	19	15	1010	3	_rejections
resections	12	15	1303	3	_resections
retention	9	16	1148	3	_retention_
revelations	14	4	1030	3	_revelations
reversions	13	4	757	3	_reversions
subventions	16	7	484	3	subventions
superventions	18	12	578	3	superventions

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	121633	0.406	440125.6
2	DLD Change Limit	121633	58	6.186	19662.6
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	6.622	26984.4