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

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

76 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
vacationing	17	5	304	(None)
vacationist	16	5	590	2	vacationist
auctioning	13	4	489	3	_auctioning
captioning	15	4	570	3	ca_ptioning
cautioning	13	4	572	3	ca_utioning
fractioning	17	4	433	3	frac_tioning
marathoning	17	5	282	3	marathoning
occasioning	16	5	251	3	occasioning
rationing	10	3	978	3	__rationing
recautioning	15	5	376	3	recautioning
sanctioning	14	5	399	3	sanctioning
sectioning	13	4	629	3	sec_tioning
stationing	11	4	528	3	_stationing
suctioning	13	4	534	3	suc_tioning
vacating	14	3	1035	3	vacat___ing
vacation	13	19	1189	3	vacatio__n_
vacationed	16	4	342	3	vacation_ed
vacationer	15	4	330	3	vacation_er
vacationers	16	5	248	3	vacationers
vacationists	17	5	458	3	vacationists
vacationland	18	6	81	3	vacationland
vacations	14	19	1055	3	vacatio__ns
abandoning	14	7	258	4	_abandoning
acetifying	19	4	445	4	_acetifying
agatizing	20	8	747	4	_agati_zing
ambitioning	16	5	278	4	ambitioning
atoning	8	35	1487	4	___at_oning
attaining	10	4	722	4	_attai_ning
auditioning	13	5	270	4	auditioning
cabining	13	3	864	4	__cabi_ning
calamining	15	4	593	4	calami_ning
cannoning	12	3	732	4	__cannoning
cantoning	12	3	1088	4	__cantoning
canyoning	15	3	687	4	__canyoning
caparisoning	17	7	206	4	caparisoning
captaining	15	4	607	4	captai_ning
cartoning	12	3	1111	4	__cartoning
cartooning	13	4	588	4	ca_rtooning
cationic	12	3	1001	4	__cationi_c
clarioning	13	4	518	4	_clarioning
cottoning	12	3	734	4	__cottoning
decisioning	15	4	393	4	decisioning
factoring	15	3	752	4	fac_t_oring
fashioning	17	4	439	4	fa_shioning
functioning	17	5	324	4	functioning
machining	17	4	693	4	mac_hi_ning
marathonings	18	5	143	4	marathonings
mentioning	13	4	579	4	_mentioning
misatoning	13	4	644	4	misat_oning
miscaptioning	20	6	140	4	miscaptioning
motioning	12	4	754	4	__motioning
munitioning	14	5	303	4	munitioning
optioning	12	4	655	4	__optioning
paragoning	14	4	595	4	para_goning
partitioning	15	5	297	4	partitioning
patining	11	3	1230	4	__pati_ning
pavilioning	17	5	237	4	pavilioning
petitioning	14	5	404	4	petitioning
picarooning	16	5	243	4	picarooning
platooning	13	4	465	4	_platooning
portioning	13	4	719	4	_portioning
positioning	14	5	455	4	positioning
questioning	21	5	324	4	questioning
ratooning	10	3	717	4	__ratooning
rattooning	11	4	395	4	ra_ttooning
restationing	13	5	426	4	restationing
vacationlands	19	6	58	4	vacationlands
vagabonding	19	5	157	4	vaga_bonding
vectoring	15	3	741	4	vec_t_oring
visioning	13	4	706	4	v__isioning
vocalising	16	4	552	4	vocali_sing
vocalizing	25	4	741	4	vocali_zing
vocation	13	23	1198	4	vocatio__n_
vocational	15	4	695	4	vocation_al
vocations	14	19	1142	4	vocatio__ns
wantoning	13	3	708	4	wa_nt_oning

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	76	9.140	16282.2
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	9.593	18627.2