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

Here are the results of your fuzzy-string dictionary search for “scaping” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

114 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
scaping	12	37	1569	(None)
escaping	13	4	706	1	escaping
scaling	10	35	1937	1	scaling
scalping	13	34	1045	1	scalping
scamping	15	35	1019	1	scamping
scaring	10	34	2197	1	scaring
scarping	13	33	1246	1	scarping
scoping	12	35	1382	1	scoping
scraping	13	33	1086	1	scraping
shaping	13	31	1618	1	shaping
soaping	10	36	1622	1	soaping
aping	8	73	2723	2	__aping
caging	10	53	2102	2	_caging
caking	13	46	2467	2	_caking
camping	14	31	1897	2	_camping
caning	9	41	2862	2	_caning
capping	14	38	1967	2	_capping
caring	9	51	3799	2	_caring
carping	12	35	2108	2	_carping
casing	9	48	2910	2	_casing
caving	12	48	2261	2	_caving
cawing	12	43	2261	2	_cawing
coping	11	39	2766	2	_coping
craping	12	40	1871	2	craping
draping	11	42	1335	2	draping
escarping	14	3	520	2	escarping
gaping	10	56	1892	2	_gaping
heaping	13	30	1585	2	heaping
japing	16	50	1357	2	_japing
leaping	10	32	1599	2	leaping
raping	9	48	2985	2	_raping
reaping	10	36	2121	2	reaping
sacking	14	41	2270	2	sacking
sacring	10	31	1598	2	sacring
saning	7	51	2764	2	s_aning
sapling	10	32	1786	2	s_apling
sapping	12	35	1931	2	sapping
sating	7	47	3545	2	s_ating
saving	10	47	2451	2	s_aving
sawing	10	43	2381	2	s_awing
saying	10	43	2554	2	s_aying
scabbing	15	27	719	2	scabbing
scalding	12	33	939	2	scalding
scamming	15	32	854	2	scamming
scanning	11	33	1077	2	scanning
scanting	11	39	1476	2	scanting
scarfing	14	30	971	2	scarfing
scarphing	17	3	524	2	scarphing
scarring	11	25	1151	2	scarring
scarting	11	34	1526	2	scarting
scathing	14	26	970	2	scathing
scatting	11	33	1181	2	scatting
scooping	13	36	1063	2	scooping
scoring	10	31	1721	2	scoring
scowing	13	38	1209	2	scowing
scrapings	14	25	517	2	scrapings
scrapping	16	3	574	2	scrapping
scrying	13	3	866	2	scrying
sculping	13	29	894	2	sculping
sealing	8	35	2856	2	sealing
seaming	10	32	2211	2	seaming
searing	8	33	3092	2	searing
seating	8	41	3068	2	seating
seeping	10	38	1791	2	seeping
shading	12	31	1556	2	shading
shaking	15	33	1725	2	shaking
shaming	13	30	1674	2	shaming
sharing	11	37	2324	2	sharing
sharping	14	30	1137	2	sharping
shaving	14	34	1433	2	shaving
shawing	14	35	1488	2	shawing
siping	9	42	2063	2	s_iping
sipping	12	31	1743	2	sipping
skating	12	36	1385	2	skating
slaking	12	37	1747	2	slaking
slapping	13	35	1084	2	slapping
slating	8	37	2465	2	slating
slaving	11	35	1483	2	slaving
slaying	11	33	1684	2	slaying
sliping	10	33	1441	2	sliping
sloping	10	41	1407	2	sloping
snaking	12	39	1530	2	snaking
snapping	13	34	965	2	snapping
snaring	8	39	2095	2	snaring
snawing	11	36	1248	2	snawing
sneaping	11	34	949	2	sneaping
sniping	10	37	1205	2	sniping
soaking	12	31	1661	2	soaking
soaring	8	35	2189	2	soaring
sopping	12	39	1720	2	sopping
souping	10	42	1553	2	souping
spacing	12	36	1449	2	spacing
spading	11	31	1438	2	spading
spaeing	10	34	1354	2	spaeing
sparing	10	48	2387	2	sparing
spaying	13	30	1462	2	spaying
staging	9	38	1837	2	staging
staking	12	39	1980	2	staking
staling	8	39	2542	2	staling
stamping	13	33	1096	2	stamping
staning	8	39	2224	2	staning
stapling	11	28	1315	2	stapling
staring	8	45	2705	2	staring
stating	8	37	2516	2	stating
staving	11	39	1570	2	staving
staying	11	40	1732	2	staying
stoping	10	37	1662	2	stoping
supping	12	38	1453	2	supping
swaging	12	42	1063	2	swaging
swamping	16	30	792	2	swamping
swapping	16	34	867	2	swapping
swaying	14	36	1064	2	swaying
swiping	13	31	982	2	swiping
taping	9	42	2239	2	_taping

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	107671	0.373	479064.3
2	DLD Change Limit	107671	114	6.703	16063.1
3	Display Results	114	114	0.080	1425.0
	(SQL Overall)	178691	114	7.156	24970.8