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

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

190 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
prefixion	21	4	411	(None)
prefixions	22	4	387	1	prefixions
precision	13	4	1005	2	precision
prefixing	22	4	678	2	prefixing
prevision	14	4	800	2	prevision
infixion	18	4	368	3	_infixion
perdition	12	4	901	3	perdition
perfusion	14	10	588	3	perfusion
petition	10	7	1175	3	p_etition
precisian	13	4	781	3	precisian
precisions	14	4	937	3	precisions
predation	12	3	1346	3	predation
prediction	15	4	1030	3	prediction
prefiling	15	4	953	3	prefiling
prefiring	15	5	907	3	prefiring
prefix	18	35	685	3	prefix___
prefixal	20	4	454	3	prefix_al
prefixed	21	35	770	3	prefix_ed
prefixes	20	38	923	3	prefix_es
prelusion	11	5	660	3	prelusion
premixing	21	5	780	3	premixing
prenotion	11	4	917	3	prenotion
preoption	13	4	808	3	preoption
presidio	11	4	615	3	presidio_
presidios	12	4	577	3	presidios
preunion	10	4	689	3	pre_union
previsions	15	4	773	3	previsions
profusion	14	4	570	3	profusion
provision	14	4	763	3	provision
recision	10	3	1027	3	_recision
refixing	19	32	979	3	_refixing
reflexion	19	4	361	3	_reflexion
religion	9	9	674	3	_religion
revision	11	3	871	3	_revision
suffixion	22	5	224	3	suffixion
creation	10	28	1651	4	cre_ation
cremation	13	5	1164	4	cremation
crenation	11	4	1292	4	crenation
crucifixion	25	6	87	4	crucifixion
decision	11	4	852	4	_decision
deflexion	20	4	282	4	_deflexion
derision	9	3	907	4	_derision
edition	8	3	1085	4	__edition
elision	7	23	1110	4	__elision
erection	10	21	1551	4	ere_ction
erudition	10	4	617	4	erudition
flexion	17	3	507	4	fle__xion
fruition	11	10	610	4	fr_uition
imprecision	17	5	390	4	imprecision
infixions	19	4	384	4	_infixions
irreligion	11	5	182	4	irreligion
lenition	8	3	1008	4	_lenition
partition	11	4	869	4	partition
pavilion	13	4	490	4	p_avilion
pension	9	4	1220	4	p_e_nsion
perditions	13	4	887	4	perditions
pereion	9	3	1205	4	p_e_reion
perfection	17	4	836	4	perfection
perfidies	15	4	660	4	perfidies
perfidious	16	5	367	4	perfidious
perfusions	15	9	533	4	perfusions
perigon	10	3	985	4	p_eri_gon
permission	14	4	571	4	permission
persimmon	15	5	208	4	persimmon
pervasion	14	4	607	4	pervasion
petitions	11	5	1108	4	p_etitions
phelonion	14	4	401	4	phelonion
pinion	8	38	1589	4	p___inion
position	10	9	1219	4	p_osition
postilion	11	11	746	4	postilion
preassign	12	4	457	4	preassign
preaxial	17	4	697	4	pre_axial
prebidden	15	4	261	4	prebidden
precaution	14	4	724	4	precaution
precession	14	4	882	4	precession
precipice	17	4	595	4	precipice
precipitin	16	5	586	4	precipitin
precisians	14	4	641	4	precisians
precising	14	4	1327	4	precising
preclusion	14	4	521	4	preclusion
predations	13	8	1215	4	predations
predication	16	4	1243	4	predication
predictions	16	4	965	4	predictions
predictor	14	4	709	4	predictor
preemption	16	10	525	4	preemption
preexist	17	4	796	4	pre_exist
prefacing	17	11	874	4	prefacing
prefading	16	14	903	4	prefading
prefight	17	4	639	4	prefi_ght
prefigure	15	4	404	4	prefigure
prefile	12	34	1318	4	pref__ile
prefiled	14	33	1057	4	prefi_led
prefiles	13	31	1344	4	prefi_les
prefilled	15	3	551	4	prefilled
prefire	12	40	1281	4	pref__ire
prefired	14	43	1075	4	prefi_red
prefires	13	43	1328	4	prefi_res
prefrozen	23	5	284	4	prefrozen
prehension	15	4	631	4	prehension
prehiring	15	4	838	4	prehiring
preignition	14	5	443	4	preignition
prelection	14	15	1129	4	prelection
prelibation	15	12	866	4	prelibation
prelimit	12	5	912	4	prelimi_t
prelimits	13	6	601	4	prelimits
prelusions	12	5	637	4	prelusions
premising	14	4	1241	4	premising
premix	17	37	1033	4	premix___
premixed	20	33	801	4	premix_ed
premixes	19	31	1008	4	premix_es
premixt	18	35	1066	4	premix__t
premonition	15	4	735	4	premonition
premunition	15	4	557	4	premunition
prenoon	9	3	1004	4	pre__noon
prenotions	12	4	829	4	prenotions
preoptions	14	4	764	4	preoptions
preportion	14	4	887	4	preportion
preposition	15	10	858	4	preposition
preradio	11	4	572	4	preradio_
preriot	9	3	1641	4	pre__riot
preseason	11	4	412	4	preseason
presidia	11	4	727	4	presidi_a
presidial	12	4	721	4	presidial
presiding	13	5	1090	4	presiding
presidium	14	4	530	4	presidium
pretension	12	4	753	4	pretension
pretorian	11	5	1155	4	pretorian
pretrain	10	3	1092	4	pretrai_n
preunions	11	4	648	4	pre_unions
prevention	15	4	917	4	prevention
prevising	15	5	1087	4	prevising
previsional	16	5	532	4	previsional
previsioned	17	4	426	4	previsioned
previsit	13	4	1007	4	previsi_t
previsits	14	4	679	4	previsits
previsor	13	11	630	4	previ_sor
prewiring	15	4	789	4	prewiring
prexies	16	34	1500	4	pre__xies
prion	7	51	1999	4	pr____ion
prison	8	5	1402	4	pr__i_son
privation	14	3	1117	4	privation
proaction	13	4	1010	4	proaction
probation	13	4	1218	4	probation
profession	15	4	659	4	profession
proficient	17	5	624	4	proficient
profiling	15	4	823	4	profiling
profiting	15	4	998	4	profiting
profusions	15	4	525	4	profusions
prolixity	21	4	486	4	prolixity
prolusion	11	4	636	4	prolusion
promotion	13	5	950	4	promotion
pronation	11	4	1570	4	pronation
proration	11	4	1598	4	proration
prosimian	13	6	600	4	prosimian
prounion	10	4	682	4	pr_ounion
provisions	15	4	721	4	provisions
punition	10	3	837	4	p_unition
reaction	10	6	1260	4	_reaction
recisions	11	3	991	4	_recisions
reedition	10	4	783	4	reedition
refashion	15	4	335	4	_refashion
refection	14	15	1228	4	_refection
refiling	12	31	1653	4	_refiling
refining	12	24	1686	4	_refining
refinish	14	4	789	4	_refinish
refiring	12	35	1392	4	_refiring
refix	15	52	1248	4	_refix___
refixed	18	36	1115	4	_refix_ed
refixes	17	48	1317	4	_refix_es
reflation	12	4	1233	4	_reflation
reflexions	20	4	330	4	_reflexions
refrain	10	3	1004	4	_refrai_n
region	7	46	1490	4	_re__gion
relation	8	26	1977	4	_relation
relaxin	14	23	918	4	_relaxi_n
reliction	11	3	1069	4	_reliction
religions	10	8	660	4	_religions
remission	11	4	733	4	_remission
remixing	18	28	1033	4	_remixing
remotion	10	4	1023	4	_remotion
rendition	10	5	893	4	_rendition
resilin	7	29	1397	4	_resili_n
reunion	7	3	767	4	_re_union
revisions	12	3	859	4	_revisions
sedition	9	3	933	4	_sedition
suffixions	23	5	219	4	suffixions
tradition	10	4	759	4	tradition
transfixion	21	5	420	4	transfixion
tretinoin	9	4	328	4	tretinoin
vermilion	14	4	433	4	vermilion

Search took 14 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	165329	0.483	369960.7
2	DLD Change Limit	165329	190	12.720	12997.6
3	Display Results	190	190	0.093	2043.0
	(SQL Overall)	178691	190	13.296	13439.5