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

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

65 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
projectional	23	5	541	(None)
productional	17	9	470	2	productional
projection	21	5	876	2	projection__
projections	22	5	847	2	projection_s
correctional	16	7	531	3	correctional
probational	15	4	708	3	pro_bational
processional	16	6	539	3	processional
professional	17	5	496	3	professional
projecting	22	17	724	3	projecti_n_g
projectionist	24	8	525	3	projectionist
promotional	15	5	563	3	pro_motional
proportional	16	5	581	3	proportional
protection	14	5	1147	3	protection__
protections	15	5	1070	3	protection_s
protectoral	15	5	493	3	protect_oral
affectional	19	5	388	4	_affectional
bisectional	15	5	463	4	_bisectional
connectional	16	4	671	4	connectional
convectional	19	4	703	4	convectional
directional	14	4	543	4	_directional
fractional	15	4	712	4	fr__actional
frictional	15	4	624	4	fr__ictional
inflectional	17	5	437	4	inflectional
perceptional	18	5	490	4	perceptional
perorational	14	4	639	4	pero_rational
positional	12	4	790	4	p_o_sitional
precessional	16	5	512	4	precessional
prelection	14	15	1129	4	prelection__
prelections	15	12	1046	4	prelection_s
preoperational	18	5	324	4	preoperational
prevocational	20	5	401	4	prevocational
proaction	13	4	1010	4	pro_action__
proactions	14	4	934	4	pro_action_s
processionals	17	5	414	4	processionals
production	15	4	789	4	production__
productions	16	4	753	4	production_s
professionals	18	6	404	4	professionals
progestational	17	6	275	4	progestational
progressional	16	6	396	4	progressional
projectile	21	4	455	4	projecti__le
projectiles	22	4	380	4	projecti_les
projectionists	25	9	411	4	projectionists
projective	24	4	681	4	projecti__ve
projectively	29	5	398	4	projectively
projector	20	18	668	4	project_o__r
projectors	21	18	717	4	project_o_rs
proportionals	17	6	402	4	proportionals
propositional	17	5	524	4	propositional
prosecting	15	18	981	4	prosecti_n_g
prosecution	15	4	607	4	prosecution__
prosecutions	16	4	561	4	prosecution_s
protecting	15	19	1021	4	protecti_n_g
protectionism	19	8	494	4	protectionism
protectionist	17	11	668	4	protectionist
provisional	16	5	546	4	pro_visional
redactional	14	5	434	4	_redactional
reductional	14	5	458	4	_reductional
reflectional	17	5	398	4	reflectional
rejection	18	17	1025	4	_rejection__
rejections	19	15	1010	4	_rejection_s
rotational	10	4	809	4	_ro_tational
sectional	11	4	941	4	___sectional
tractional	12	4	804	4	tr__actional
trajection	19	4	469	4	trajection__
trajections	20	4	451	4	trajection_s

Search took 8 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	124790	0.140	1276364.3
2	DLD Change Limit	124790	65	7.280	17141.5
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	7.450	23985.4