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

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

66 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
precanceling	19	5	277	(None)
precancelling	20	5	174	1	precancelling
canceling	14	3	1016	3	___canceling
precancel	15	4	620	3	precancel___
precanceled	18	5	245	3	precancel_ed
precancelled	19	5	159	3	precancelled
precancels	16	4	406	3	precancel__s
preconceiving	23	10	236	3	preconceiving
preconcerting	20	8	441	3	preconcerting
prehandling	18	5	342	3	prehan_dling
princeling	15	4	465	3	pr__inceling
rechanneling	18	5	245	3	_rechanneling
reconciling	16	4	548	3	_reconciling
repaneling	13	4	573	3	_repan_eling
cancelling	15	4	721	4	___cancelling
creneling	12	4	773	4	cre__n_eling
paneling	11	10	1362	4	p___an_eling
parceling	14	3	844	4	p___arceling
penancing	14	3	634	4	p_enanc__ing
penciling	14	3	741	4	p_e__nciling
prancing	13	26	1216	4	pr__anc__ing
preaccusing	18	4	316	4	pre_accusing
preaching	17	28	1116	4	pre_a_c_hing
preacting	14	24	1253	4	pre_a_c_ting
prealtering	14	4	617	4	pre_altering
precalculi	16	5	176	4	precalculi__
precancer	15	4	709	4	precance___r
precancerous	18	5	196	4	precancerous
precancers	16	4	525	4	precance__rs
precasting	15	16	983	4	preca__sting
preceding	15	12	936	4	pre___ceding
precensoring	17	5	322	4	precensoring
precenting	15	10	1215	4	precen__ting
prechecking	25	4	307	4	prechec_king
prechilling	19	4	374	4	prec_hilling
preconceive	20	5	335	4	preconce_ive
preconciliar	18	6	214	4	preconciliar
preconizing	25	4	823	4	precon_izing
precooling	15	4	596	4	prec__ooling
preenacting	16	12	537	4	preenac_ting
prefacing	17	11	874	4	prefa_c__ing
prehardening	19	5	258	4	prehardening
prelaunching	20	5	150	4	prelaunc_hing
premarketing	21	5	256	4	premarketing
prepacking	21	4	577	4	prepa_c_king
prepunching	21	4	256	4	prepunc_hing
prevailing	16	5	672	4	preva__iling
princelings	16	4	257	4	pr__incelings
reacceding	16	4	422	4	_re_acceding
reannexing	18	4	315	4	_re_annexing
recalling	12	22	1190	4	_reca__lling
recaning	11	14	1669	4	_recan___ing
recanting	12	24	1482	4	_recan__ting
recarpeting	16	7	436	4	_recarpeting
rechannelling	19	5	142	4	_rechannelling
recircling	15	4	357	4	_recirc_ling
reconceiving	20	9	345	4	_reconceiving
reconsoling	14	4	448	4	_reconsoling
reconvening	17	4	629	4	_reconvening
reconveying	20	4	463	4	_reconveying
recycling	17	3	490	4	_rec_yc_ling
rehandling	15	4	445	4	_rehan_dling
relabeling	13	4	419	4	_rela_beling
repanelling	14	4	347	4	_repanelling
retackling	17	4	443	4	_reta_ckling
spanceling	15	4	394	4	__spanceling

Search took 9 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.406	440125.6
2	DLD Change Limit	124790	66	7.703	16200.2
3	Display Results	66	66	0.046	1434.8
	(SQL Overall)	178691	66	8.155	21911.8