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

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

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

147 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
prehensions	16	4	594	(None)
prehension	15	4	631	1	prehension_
pretensions	13	4	708	1	pretensions
apprehensions	20	10	246	2	apprehensions
precessions	15	4	855	2	precessions
pretension	12	4	753	2	pretension_
preventions	16	4	853	2	preventions
recensions	12	4	848	2	_recensions
reprehensions	18	5	319	2	reprehensions
apprehension	19	9	264	3	apprehension_
comprehensions	23	6	266	3	~~com~~prehensions
pensions	10	3	1169	3	p___ensions
perversions	16	4	541	3	perversions
precensors	14	4	546	3	precens_ors
precession	14	4	882	3	precession_
precisions	14	4	937	3	pre_cisions
preclusions	15	4	466	3	preclusions
prehensile	15	4	466	3	prehensi_le
prelections	15	12	1047	3	prelections
prelusions	12	5	637	3	pre_lusions
preseasons	12	4	405	3	preseas_ons
pretensioned	15	5	359	3	pretensioned
pretentious	13	12	559	3	pretentious
preunions	11	4	648	3	pre_un_ions
prevention	15	4	917	3	prevention_
previsions	15	4	773	3	pre_visions
processions	15	4	815	3	processions
professions	16	4	663	3	professions
recension	11	4	886	3	_recension_
recessions	12	4	893	3	_recessions
reprehension	17	5	337	3	reprehension_
retentions	10	16	1111	3	_retentions
reversions	13	4	757	3	_reversions
adhesions	13	4	379	4	_adhe_sions
ascensions	12	4	461	4	_ascensions
cohesions	14	4	709	4	_cohe_sions
comprehension	22	6	297	4	~~com~~prehension_
declensions	14	4	333	4	declensions
descensions	14	4	437	4	descensions
detentions	11	14	880	4	_detentions
dimensions	13	4	461	4	_dimensions
dissensions	12	17	557	4	dissensions
distensions	12	14	627	4	distensions
emersions	11	4	728	4	__emersions
eversions	12	3	836	4	__eversions
extensions	17	4	613	4	_extensions
greenstone	11	5	370	4	gre_enstone
greenstones	12	5	372	4	gre_enstones
hypertensions	21	9	406	4	hypertensions
inhesions	12	11	612	4	_inhe_sions
intensions	10	4	840	4	_intensions
pension	9	4	1220	4	p___ension_
pensione	10	3	977	4	p___ensione
pensiones	11	4	1000	4	p___ensiones
perceptions	17	9	819	4	perceptions
percussions	15	4	487	4	percussions
pereions	10	3	1085	4	p_ere__ions
perfections	18	4	814	4	perfections
perfusions	15	9	533	4	p_erfusions
permeations	15	4	988	4	permeations
permissions	15	4	533	4	permissions
persuasions	13	8	391	4	persuasions
pervasions	15	4	566	4	p_ervasions
perversion	15	4	585	4	perversion_
phelonions	15	4	355	4	phelon_ions
possessions	12	6	502	4	possessions
posttensions	14	5	246	4	posttensions
preassigns	13	4	355	4	pre_assigns
precautions	15	4	655	4	precautions
precensor	13	4	525	4	precens_o_r
precenting	15	10	1215	4	precenti_ng
precentors	14	8	834	4	precen_tors
precessing	15	9	874	4	precessi_ng
precessional	16	5	512	4	precessional
precisians	14	4	641	4	pre_cisians
precision	13	4	1005	4	pre_cision_
preclusion	14	4	521	4	preclusion_
preconscious	18	5	290	4	preconscious
predations	13	8	1215	4	pre_dations
predictions	16	4	965	4	predictions
prednisone	13	5	305	4	pre_dnisone
prednisones	14	5	298	4	pre_dnisones
preemptions	17	13	485	4	preemptions
preening	11	31	1584	4	pre_en_i_ng
prefixions	22	4	387	4	pre_fixions
preheating	16	3	1072	4	preheati_ng
prehensility	20	13	262	4	prehensility
preignitions	15	5	400	4	preignitions
prelection	14	15	1129	4	prelection_
prelusion	11	5	660	4	pre_lusion_
premonitions	16	4	685	4	premonitions
premunitions	16	4	498	4	premunitions
prenotions	12	4	829	4	pre_notions
preoptions	14	4	764	4	pre_options
preportions	15	4	826	4	preportions
prerinsing	13	4	764	4	prerinsi_ng
preseason	11	4	412	4	preseas_on_
presentations	15	4	813	4	presentations
presentient	13	4	832	4	presentient
presenting	13	10	1302	4	presenti_ng
presentisms	15	5	521	4	presentisms
pretending	14	3	861	4	pretendi_ng
pretenses	11	22	1059	4	pretens__es
pretensioning	16	6	280	4	pretensioning
pretensionless	16	6	124	4	pretension~~les~~s
preunion	10	4	689	4	pre_un_ion_
prevenient	15	4	781	4	preven_ient
preventing	16	12	1026	4	preventi_ng
preventives	19	4	572	4	preventives
prevision	14	4	800	4	pre_vision_
procession	14	4	841	4	procession_
profession	15	4	659	4	profession_
profusions	15	4	525	4	pr_ofusions
progressions	15	5	555	4	progressions
projections	22	5	847	4	projections
prolusions	12	4	588	4	pr_olusions
propulsions	15	5	330	4	propulsions
protections	15	5	1070	4	protections
protrusions	13	5	414	4	protrusions
provisions	15	4	721	4	pr_ovisions
rebellions	12	4	420	4	_rebellions
recensors	11	7	613	4	_recens_ors
receptions	14	4	974	4	_receptions
recession	11	4	910	4	_recession_
recisions	11	3	991	4	_re_cisions
reclusions	12	4	624	4	_reclusions
reconsigns	13	4	441	4	_reconsigns
recursions	12	4	540	4	_recursions
redesigns	11	4	407	4	_rede_signs
refections	15	18	1164	4	_refections
regressions	12	4	710	4	_regressions
rejections	19	15	1010	4	_rejections
remissions	12	4	661	4	_remissions
repressions	13	4	896	4	_repressions
repulsions	12	4	479	4	_repulsions
reseasons	9	4	487	4	_reseas_ons
resections	12	15	1303	4	_resections
responsions	13	6	377	4	_responsions
retention	9	16	1148	4	_retention_
retorsions	10	4	571	4	_retorsions
reunions	8	3	727	4	_re_un_ions
reversion	12	4	809	4	_reversion_
revisions	12	3	859	4	_re_visions
revulsions	13	4	426	4	_revulsions
secessions	12	4	646	4	_secessions
suspensions	13	5	384	4	suspensions
tensions	8	3	1022	4	___tensions

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	147	8.826	16861.4
3	Display Results	147	147	0.093	1580.6
	(SQL Overall)	178691	147	9.342	19127.7