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

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

80 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
protocoling	16	5	485	(None)
protocolling	17	5	302	1	protocolling
photocopying	25	6	374	3	photocopying
precooling	15	4	596	3	preco_oling
protecting	15	19	1021	3	protec_ting
protocol	12	4	647	3	protocol___
protocoled	15	4	498	3	protocol_ed
protocolled	16	5	288	3	protocolled
protocols	13	4	720	3	protocol__s
protonating	14	4	859	3	protonating
prototyping	19	5	385	3	prototyping
retooling	10	3	909	3	_reto_oling
articling	12	4	771	4	ar_tic_ling
drooling	10	26	1042	4	dr__o_oling
eroticizing	23	7	540	4	eroticizing
forthcoming	22	5	177	4	forthcoming
photocopied	21	5	639	4	photocopied
photocopier	20	6	649	4	photocopier
photocopies	20	5	891	4	photocopies
photoing	14	3	907	4	phot__o_ing
photolyzing	29	5	387	4	photolyzing
pistoling	12	6	849	4	pist__oling
pistolling	13	4	535	4	pisto_lling
platooning	13	4	465	4	plato_oning
pooching	16	32	898	4	p_o_oc_hing
pooling	10	32	1909	4	p___o_oling
portioning	13	4	719	4	port_ioning
potboiling	15	4	412	4	p_otboiling
prattling	12	4	630	4	prat__tling
preboiling	15	4	640	4	prebo_iling
prebooking	19	4	407	4	prebo_oking
precoding	15	10	973	4	pr__ecoding
precooking	19	4	504	4	preco_oking
prefocusing	19	5	313	4	prefocusing
prelocating	16	4	741	4	prelocating
prescoring	15	4	743	4	pr_escoring
pretelling	13	3	813	4	pret_elling
prickling	18	3	653	4	pr__ickling
princeling	15	4	465	4	pr_inceling
proctoring	15	4	667	4	pro_ctoring
procuring	14	3	799	4	pr__ocuring
producing	15	5	614	4	produc__ing
profiling	15	4	823	4	pr__ofiling
prognosing	14	4	442	4	pro_gnosing
projecting	22	17	724	4	projec_ting
prologing	13	3	895	4	pr__ologing
prologizing	24	4	523	4	prologizing
prologuing	14	4	386	4	prolo_guing
prolonging	14	4	480	4	prolo_nging
promoing	13	3	1046	4	pr__omo_ing
promoting	14	3	992	4	pr__omoting
pronouncing	16	5	292	4	pronouncing
proofing	14	3	931	4	pr__o_ofing
propelling	15	5	693	4	pro_pelling
proponing	14	3	999	4	pr__oponing
proposing	14	3	967	4	pr__oposing
propounding	17	4	405	4	propounding
prorogating	15	5	606	4	prorogating
proroguing	14	4	312	4	proro_guing
prosecting	15	18	981	4	prosec_ting
prosecuting	16	4	502	4	prosecuting
protending	14	4	681	4	prot_ending
protesting	13	19	1025	4	prot_esting
protozoan	20	4	594	4	protozo_an_
protozoans	21	5	553	4	protozo_ans
protozoic	22	4	615	4	protozo_i_c
protozoon	20	5	441	4	protozo_on_
protozoons	21	5	436	4	protozo_ons
protracting	16	4	693	4	protracting
protruding	14	5	363	4	prot_ruding
provoking	19	3	513	4	pr__ovoking
prowling	14	4	999	4	pr__o_wling
ratooning	10	3	717	4	_rato_oning
retackling	17	4	443	4	_retackling
retotaling	11	8	688	4	_retotaling
rockling	15	25	938	4	_r__ockling
rootling	9	26	995	4	_ro_o_tling
rototilling	12	5	264	4	_rototilling
stooling	9	31	1313	4	__sto_oling
tooling	8	29	1831	4	___to_oling

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.420	425454.8
2	DLD Change Limit	148819	80	9.173	16223.6
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	9.639	18538.3