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

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

85 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
escalloping	16	5	215	(None)
escaloping	15	4	372	1	esca_loping
scalloping	15	4	395	1	_scalloping
scallopini	14	5	278	2	_scallopini
scolloping	15	4	324	2	_scolloping
escalading	14	4	357	3	esca_lading
escalating	13	4	709	3	esca_lating
escallop	12	4	319	3	escallop___
escalloped	15	4	259	3	escallop_ed
escallops	13	4	319	3	escallop__s
escaping	13	4	706	3	esca___ping
escarping	14	3	520	3	esca__rping
galloping	13	5	625	3	__galloping
reswallowing	19	5	136	3	reswallowing
sallowing	13	5	738	3	_s_allowing
scallopinis	15	5	184	3	_scallopinis
scalping	13	34	1045	3	_sca_l_ping
shallowing	17	4	411	3	_shallowing
swallowing	17	4	304	3	_swallowing
walloping	15	4	559	3	__walloping
allowing	12	36	909	4	___allowing
alloying	12	33	914	4	___alloying
balloting	12	3	839	4	__balloting
calling	10	38	2677	4	__call__ing
callousing	13	4	427	4	__callousing
callusing	12	3	617	4	__callusing
disallowing	16	4	328	4	disallowing
dolloping	13	4	499	4	__dolloping
echeloning	16	4	286	4	e_cheloning
eloping	10	35	1283	4	e____loping
encamping	16	4	523	4	enca__mping
enclasping	15	4	410	4	enc_lasping
enclosing	12	5	758	4	enc__losing
enhaloing	13	4	536	4	enha_lo_ing
enveloping	16	4	291	4	e_nveloping
equalling	19	4	524	4	equall__ing
escalop	11	4	478	4	esca_lop___
escalope	12	4	452	4	esca_lop__e
escaloped	14	4	398	4	esca_lop_ed
escalopes	13	4	477	4	esca_lop_es
escalops	12	4	467	4	esca_lop__s
escoting	11	5	871	4	esc___oting
escrowing	15	4	481	4	esc__rowing
espaliering	14	4	269	4	espaliering
excelling	19	3	564	4	excell__ing
fallowing	16	6	643	4	__fallowing
galoping	12	5	802	4	__ga_loping
halloaing	13	8	703	4	__halloaing
halloing	12	15	1007	4	__hallo_ing
hallooing	13	6	634	4	__hallooing
hallowing	16	7	694	4	__hallowing
lolloping	12	4	469	4	__lolloping
miscalling	15	4	786	4	miscall__ing
oscillating	14	4	398	4	oscillating
outgalloping	16	5	91	4	outgalloping
recalling	12	22	1190	4	recall__ing
rescaling	12	22	1201	4	resca_l__ing
sallying	12	30	985	4	_s_all_ying
salvoing	12	3	642	4	_s_alvo_ing
scalding	12	33	939	4	_sca_l_ding
scaling	10	35	1937	4	_sca_l__ing
scallop	11	23	764	4	_scallop___
scalloped	14	4	446	4	_scallop_ed
scalloper	13	4	445	4	_scallop_er
scallopers	14	5	404	4	_scallopers
scallops	12	29	739	4	_scallop__s
scaloppine	16	5	222	4	_scaloppine
scamping	15	35	1019	4	_sca__mping
scaping	12	37	1569	4	_sca___ping
scarping	13	33	1246	4	_sca__rping
schlepping	20	4	174	4	_schlepping
schlumping	20	4	194	4	_schlumping
scooping	13	36	1063	4	_sc__ooping
scoping	12	35	1382	4	_sc___oping
scrooping	14	4	659	4	_sc_rooping
sculling	11	29	1099	4	_scull__ing
sculping	13	29	894	4	_sc_ul_ping
slaloming	12	4	474	4	_sla_loming
sloping	10	41	1407	4	_s___loping
spalling	11	32	1346	4	_spall__ing
stalling	9	51	1670	4	_stall__ing
tallowing	13	6	629	4	__tallowing
unhallowing	18	5	142	4	unhallowing
wallopings	16	5	271	4	__wallopings
wallowing	16	6	607	4	__wallowing

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	148819	0.420	425454.8
2	DLD Change Limit	148819	85	8.376	17767.3
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	8.842	20209.3