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

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

142 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
permissions	15	4	533	(None)
permission	14	4	571	1	permission_
demissions	13	4	566	2	de_missions
emissions	11	4	692	2	_e_missions
percussions	15	4	487	2	percussions
reemissions	13	4	415	2	reemissions
remissions	12	4	661	2	re_missions
admissions	13	4	346	3	_admissions
commissions	17	4	526	3	commissions
demission	12	4	603	3	de_mission_
derisions	10	3	884	3	der_i_sions
dismissions	14	5	400	3	dismissions
emission	10	4	767	3	_e_mission_
intermissions	15	9	414	3	intermissions
missions	10	3	1190	3	___missions
omissions	11	4	615	3	__omissions
percussion	14	4	499	3	percussion_
perditions	13	4	887	3	perdi_tions
perfusions	15	9	533	3	per_fusions
permeations	15	4	988	3	permeations
permissible	17	5	297	3	permissible
permissibly	20	5	229	3	permissibly
permissive	17	5	397	3	permissi_ve
persuasions	13	8	391	3	persuasions
pervasions	15	4	566	3	per_vasions
perversions	16	4	541	3	perversions
preadmissions	18	5	236	3	preadmissions
precessions	15	4	855	3	precessions
precisions	14	4	937	3	preci_sions
pretermissions	18	6	188	3	p~~ret~~ermissions
previsions	15	4	773	3	previ_sions
readmissions	15	5	273	3	readmissions
reemission	12	4	433	3	reemission_
remission	11	4	733	3	re_mission_
rescissions	13	4	459	3	rescissions
submissions	15	5	369	3	submissions
vermilions	15	4	387	3	vermi_lions
vermillions	16	5	272	3	vermillions
abscissions	15	5	240	4	abscissions
admission	12	4	373	4	_admission_
cessions	10	3	985	4	ce___ssions
commission	16	4	562	4	commission_
decisions	12	4	838	4	de_ci_sions
decommissions	20	5	285	4	decommissions
depressions	14	4	731	4	depressions
derision	9	3	907	4	der_i_sion_
dismission	13	5	436	4	dismission_
egressions	11	4	620	4	_egressions
elisions	8	22	1042	4	_e_li_sions
emersions	11	4	728	4	_e_mersions
emulsions	11	4	534	4	_e_mulsions
envisions	12	4	561	4	_envi_sions
erasions	8	3	1098	4	_er__asions
erosions	8	3	1034	4	_er__osions
excisions	18	4	638	4	_exci_sions
fermions	13	3	620	4	ferm___ions
fissions	11	3	803	4	___fissions
frissons	11	4	504	4	_fr_iss_ons
germinations	15	13	794	4	germinations
herniations	14	4	740	4	herniations
intermission	14	6	465	4	intermission_
intromissions	15	14	279	4	intromissions
lewissons	12	4	174	4	le_wiss_ons
manumissions	16	6	150	4	manumissions
mission	9	3	1274	4	___mission_
omission	10	4	653	4	__omission_
oppressions	15	4	572	4	oppr_essions
partitions	12	4	832	4	parti_tions
passions	10	3	1058	4	p___assions
pensions	10	3	1169	4	pe___nsions
perceptions	17	9	819	4	perceptions
percussing	15	4	522	4	percussi_ng
percussionist	17	12	336	4	percussionist
percussors	14	5	280	4	percuss_ors
perdition	12	4	901	4	perdi_tion_
pereions	10	3	1085	4	per___eions
perfections	18	4	814	4	perfections
perfidious	16	5	367	4	perfi_dious
perfusion	14	10	588	4	per_fusion_
perigons	11	3	1008	4	per_i__gons
perishing	15	3	953	4	per_ishi_ng
permeation	14	4	1056	4	permeation_
permissively	22	5	255	4	permissively
permissiveness	21	6	317	4	permissiveness
permitting	15	4	630	4	permitti_ng
permutations	16	4	650	4	permutations
pernicious	14	4	550	4	perni_cious
perorations	13	3	1406	4	perorations
persimmons	16	5	205	4	persi_mmons
persisting	13	4	665	4	persisti_ng
persons	9	37	1701	4	per___s_ons
persuasion	12	9	419	4	persuasion_
pertussis	11	4	332	4	pertussi__s
pertussises	13	5	212	4	pertussises
pervasion	14	4	607	4	per_vasion_
perversion	15	4	585	4	perversion_
petitions	11	5	1108	4	pe_ti_tions
possessions	12	6	502	4	possessions
preadmission	17	5	249	4	preadmission_
preassigns	13	4	355	4	p_reassigns
precession	14	4	882	4	precession_
precisians	14	4	641	4	preci_sians
precision	13	4	1005	4	preci_sion_
preclusions	15	4	466	4	preclusions
predictions	16	4	965	4	predictions
prefixions	22	4	387	4	prefi_xions
prehensions	16	4	594	4	prehensions
prelusions	12	5	637	4	p_relusions
premising	14	4	1241	4	premi_si_ng
premisses	13	28	876	4	premiss__es
pretensions	13	4	708	4	pretensions
pretermission	17	6	211	4	p~~ret~~ermission_
prevision	14	4	800	4	previ_sion_
prisons	9	3	1322	4	p_r_i_s_ons
prissies	10	17	1200	4	p_r_issi_es
prissing	11	30	1145	4	p_r_issi_ng
processions	15	4	815	4	processions
professions	16	4	663	4	professions
profusions	15	4	525	4	p_rofusions
prolusions	12	4	588	4	p_rolusions
provisions	15	4	721	4	p_rovisions
readmission	14	5	286	4	readmission_
recessions	12	4	893	4	re_cessions
recisions	11	3	991	4	re_ci_sions
recommissions	19	5	365	4	recommissions
regressions	12	4	710	4	regressions
repercussions	17	5	215	4	repercussions
repressions	13	4	896	4	repressions
rescission	12	4	486	4	rescission_
resubmissions	17	11	211	4	resubmissions
revisions	12	3	859	4	re_vi_sions
scissions	11	4	543	4	__scissions
secessions	12	4	646	4	se_cessions
seriations	10	3	1668	4	ser_iations
sessions	8	3	972	4	se___ssions
submission	14	5	374	4	submission_
supersessions	14	5	477	4	supersessions
supervisions	17	5	503	4	supervi_sions
terminations	14	14	976	4	terminations
vermilion	14	4	433	4	vermi_lion_
vermillion	15	5	325	4	vermillion_
versions	11	3	1035	4	ver___sions

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	142	9.046	16451.4
3	Display Results	142	142	0.076	1868.4
	(SQL Overall)	178691	142	9.545	18720.9