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

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

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.

70 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
shakier	14	34	1115	(None)
shadier	11	31	1115	1	shadier
shaker	13	43	1946	1	shak_er
shalier	10	31	1642	1	shalier
snakier	11	28	1000	1	snakier
beakier	13	40	1216	2	beakier
brakier	13	38	1236	2	brakier
cakier	12	31	1524	2	_cakier
chalkier	17	3	675	2	chalkier
charier	12	43	1790	2	charier
chokier	16	3	804	2	chokier
flakier	14	39	1020	2	flakier
hazier	18	47	1240	2	_hazier
hokier	13	42	1403	2	_hokier
lakier	10	47	1627	2	_lakier
leakier	11	40	1099	2	leakier
oakier	10	40	1139	2	_oakier
peakier	13	44	1144	2	peakier
quakier	20	23	920	2	quakier
sagier	7	37	1716	2	s_agier
saker	9	51	3202	2	s_ak_er
sarkier	11	34	1331	2	sarkier
scalier	9	43	1691	2	scalier
scarier	9	40	1787	2	scarier
seamier	9	31	1463	2	seamier
shabbier	15	3	518	2	shabbier
shackler	17	31	797	2	shackler
shader	10	42	1876	2	sha_der
shaggier	13	11	605	2	shaggier
shake	12	47	2640	2	shak_e_
shaken	13	41	1361	2	shak_en
shakers	14	40	1556	2	shak_ers
shakes	13	50	2459	2	shak_es
shakiest	15	19	1094	2	shakiest
shakily	17	3	690	2	shakily
shaking	15	33	1725	2	shaking
shakoes	14	45	1002	2	shakoes
shammer	14	46	1314	2	shammer
shaper	11	41	1993	2	sha_per
sharer	9	50	2548	2	sha_rer
sharker	14	43	1381	2	sharker
sharper	12	43	1270	2	sharper
shatter	10	36	1570	2	shatter
shaver	12	37	1891	2	sha_ver
shavie	12	43	1242	2	shavie_
shavies	13	42	1321	2	shavies
shier	8	54	2894	2	sh__ier
shikker	13	27	702	2	shikker
shinier	10	41	1314	2	shinier
shoalier	11	3	707	2	shoalier
showier	13	3	910	2	showier
silkier	11	44	1164	2	silkier
skankier	11	18	488	2	skankier
skier	9	51	1959	2	s__kier
slaker	10	42	1927	2	slak_er
slatier	7	40	1681	2	slatier
smokier	13	5	670	2	smokier
snarkier	12	33	651	2	snarkier
sneakier	12	4	514	2	sneakier
soaker	10	57	1753	2	soak_er
soapier	9	34	1171	2	soapier
spacier	11	40	1163	2	spacier
sparkier	14	29	803	2	sparkier
spikier	13	36	998	2	spikier
stagier	8	35	1344	2	stagier
stalkier	12	5	707	2	stalkier
suckier	13	36	1397	2	suckier
sulkier	11	38	1196	2	sulkier
swankier	15	22	550	2	swankier
whackier	20	4	467	2	whackier

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.390	458182.1
2	DLD Change Limit	107671	70	3.516	30623.2
3	Display Results	70	70	0.013	5384.6
	(SQL Overall)	178691	70	3.919	45596.1