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

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

151 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
staking	12	39	1980	(None)
shaking	15	33	1725	1	shaking
slaking	12	37	1747	1	slaking
snaking	12	39	1530	1	snaking
soaking	12	31	1661	1	soaking
stacking	15	42	1508	1	stacking
staging	9	38	1837	1	staging
staling	8	39	2542	1	staling
stalking	13	35	1222	1	stalking
staning	8	39	2224	1	staning
staring	8	45	2705	1	staring
stating	8	37	2516	1	stating
staving	11	39	1570	1	staving
staying	11	40	1732	1	staying
stoking	12	36	1559	1	stoking
taking	11	47	2595	1	_taking
awaking	15	4	781	2	awaking
baking	13	56	2662	2	_baking
betaking	15	30	1015	2	betaking
braking	14	39	1771	2	braking
caking	13	46	2467	2	_caking
estating	9	26	1499	2	estating
faking	14	55	2098	2	_faking
flaking	15	41	1449	2	flaking
laking	11	50	2704	2	_laking
leaking	12	36	1697	2	leaking
making	13	48	2385	2	_making
mistaking	16	9	969	2	mistaking
peaking	14	43	1769	2	peaking
quaking	21	3	931	2	quaking
raking	11	47	2842	2	_raking
retaking	13	31	1428	2	retaking
sacking	14	41	2270	2	sacking
saning	7	51	2764	2	s_aning
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
scaling	10	35	1937	2	scaling
scaping	12	37	1569	2	scaping
scaring	10	34	2197	2	scaring
sealing	8	35	2856	2	sealing
seaming	10	32	2211	2	seaming
searing	8	33	3092	2	searing
seating	8	41	3068	2	seating
seeking	12	40	1606	2	seeking
shacking	18	40	1408	2	shacking
shading	12	31	1556	2	shading
shaming	13	30	1674	2	shaming
shanking	16	36	1228	2	shanking
shaping	13	31	1618	2	shaping
sharing	11	37	2324	2	sharing
sharking	16	39	1297	2	sharking
shaving	14	34	1433	2	shaving
shawing	14	35	1488	2	shawing
sicking	14	37	2017	2	sicking
silking	12	37	1559	2	silking
sinking	12	33	2054	2	sinking
skanking	12	28	874	2	skanking
skating	12	36	1385	2	skating
slacking	15	39	1413	2	slacking
slating	8	37	2465	2	slating
slaving	11	35	1483	2	slaving
slaying	11	33	1684	2	slaying
smacking	17	35	1076	2	smacking
smoking	14	32	1052	2	smoking
snacking	15	34	1170	2	snacking
snaring	8	39	2095	2	snaring
snawing	11	36	1248	2	snawing
sneaking	13	32	1109	2	sneaking
soaping	10	36	1622	2	soaping
soaring	8	35	2189	2	soaring
socking	14	35	1860	2	socking
spacing	12	36	1449	2	spacing
spading	11	31	1438	2	spading
spaeing	10	34	1354	2	spaeing
spanking	15	39	1197	2	spanking
sparing	10	48	2387	2	sparing
sparking	15	28	1254	2	sparking
spaying	13	30	1462	2	spaying
speaking	15	32	1249	2	speaking
spiking	14	43	1288	2	spiking
spoking	14	32	1222	2	spoking
stabbing	13	23	876	2	stabbing
stabling	11	29	1365	2	stabling
staffing	15	24	749	2	staffing
stagging	11	33	1051	2	stagging
stagings	10	37	834	2	stagings
staig	6	55	1964	2	sta_i_g
stain	5	57	2794	2	sta_in_
staining	9	4	1337	2	staining
stains	6	49	2365	2	sta_ins
stalkings	14	31	498	2	stalkings
stalling	9	51	1670	2	stalling
stamina	9	3	1079	2	stamina
stamping	13	33	1096	2	stamping
standing	10	34	1363	2	standing
stang	6	64	2469	2	sta__ng
stanging	10	40	1365	2	stanging
stanine	7	34	1707	2	stanine
stapling	11	28	1315	2	stapling
starling	9	30	1712	2	starling
starring	9	23	1295	2	starring
starting	9	31	1617	2	starting
starving	12	25	1017	2	starving
stashing	12	35	1158	2	stashing
statin	6	39	2147	2	statin_
statins	7	37	1977	2	statins
steading	10	36	1359	2	steading
stealing	9	34	1660	2	stealing
steaming	11	40	1321	2	steaming
steeking	13	34	1135	2	steeking
stewing	11	34	1249	2	stewing
sticking	15	35	1346	2	sticking
sting	6	53	3024	2	st__ing
stinking	13	31	1354	2	stinking
stocking	15	29	1250	2	stocking
stoning	8	37	1744	2	stoning
stooking	13	27	1114	2	stooking
stoping	10	37	1662	2	stoping
storing	8	39	2112	2	storing
stowing	11	33	1513	2	stowing
strafing	12	21	1119	2	strafing
strawing	12	24	1162	2	strawing
straying	12	29	1269	2	straying
streaking	14	20	1032	2	streaking
striking	13	30	1223	2	striking
string	7	53	2756	2	st_ring
stroking	13	26	1094	2	stroking
stying	10	54	1457	2	st_ying
styling	11	29	1065	2	styling
sucking	14	32	1741	2	sucking
sulking	12	45	1431	2	sulking
swaging	12	42	1063	2	swaging
swanking	16	39	996	2	swanking
swaying	14	36	1064	2	swaying
tacking	14	44	2148	2	_tacking
takin	9	49	2130	2	_takin_
takings	12	45	1257	2	_takings
takins	10	51	1740	2	_takins
talking	12	38	1582	2	_talking
taming	9	40	2343	2	_taming
tanking	12	39	1879	2	_tanking
taping	9	42	2239	2	_taping
taring	7	39	3228	2	_taring
tasking	12	46	1632	2	_tasking
tawing	10	45	2155	2	_tawing
taxing	14	38	1671	2	_taxing
toking	11	44	2072	2	_toking
tsking	11	42	1042	2	_tsking
waking	14	48	2138	2	_waking

Search took 4 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	151	3.266	32967.2
3	Display Results	151	151	0.063	2396.8
	(SQL Overall)	178691	151	3.702	48268.8