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

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

81 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
skitteriest	15	5	272	(None)
jitteriest	17	4	455	2	_jitteriest
skitterier	14	4	242	2	skitterie_r
bitterest	11	4	771	3	_bitter_est
butteriest	12	7	688	3	_butteriest
shittiest	12	3	833	3	shitt__iest
skittered	14	3	463	3	skitter_e_d
skittering	15	3	539	3	skitteri_ng
skitters	12	34	955	3	skitter__s_
slipperiest	15	5	239	3	slipperiest
slittiest	9	3	820	3	slitt__iest
smitheries	15	4	605	3	smitheries_
spideriest	13	4	528	3	spi_deriest
winteriest	13	4	881	3	_winteriest
batteries	11	6	1511	4	_batteries_
bitterish	14	4	613	4	_bitteri_sh
bitterness	12	4	555	4	_bitterness
bittiest	10	30	1204	4	_bitt__iest
butteries	11	7	1176	4	_butteries_
catteries	11	8	1552	4	_catteries_
featheriest	17	4	568	4	featheriest
fieriest	11	21	1224	4	_fi__eriest
flatteries	13	4	741	4	flatteries_
grittiest	10	17	698	4	gritt__iest
interest	8	3	1918	4	__inter_est
jitterier	16	4	443	4	_jitterie_r
jitteriness	18	4	327	4	_jitteriness
kittenish	16	4	261	4	_kitteni_sh
kitties	11	32	1362	4	_kitt__ies_
kittlest	12	29	757	4	_kitt__lest
lotteries	9	3	1107	4	_lotteries_
niteries	8	3	1838	4	_ni_teries_
nittiest	8	27	1260	4	_nitt__iest
potteries	11	3	1359	4	_potteries_
printeries	12	4	1063	4	printeries_
sagittaries	12	5	299	4	sagittaries_
saintliest	10	4	601	4	saint_liest
scattiest	11	26	836	4	scatt__iest
shiftiest	15	3	736	4	shift__iest
shinneries	13	4	571	4	shinneries_
shirtiest	12	3	932	4	shirt__iest
shutterless	14	5	213	4	shutterless
siltiest	8	35	1561	4	s_ilt__iest
sincerest	11	4	787	4	s_incer_est
sitarist	8	3	1528	4	s_i_tari_st
sitters	7	42	2155	4	s_itter__s_
sketchiest	19	4	316	4	sk_etchiest
skiddiest	15	4	381	4	ski__ddiest
skimpiest	17	3	450	4	ski__mpiest
skinniest	13	3	552	4	ski__nniest
skirters	12	33	724	4	skirter__s_
skitter	11	38	1040	4	skitter____
skittery	15	31	510	4	skitter___y
skittish	15	4	450	4	skitt__i_sh
skittles	12	4	576	4	skitt__les_
slitters	8	40	1413	4	slitter__s_
sluttiest	9	3	733	4	slutt__iest
smelteries	12	4	616	4	smelteries_
smuttiest	11	3	597	4	smutt__iest
sneeriest	9	3	931	4	s__neeriest
snippetiest	15	5	174	4	snippetiest
snottiest	9	16	797	4	snott__iest
spheriest	14	3	837	4	s__pheriest
spiceries	13	4	931	4	spi_ceries_
spinneries	12	4	573	4	spinneries_
spiriest	10	25	1345	4	spi___riest
spitters	10	41	1338	4	spitter__s_
spottiest	11	17	768	4	spott__iest
starriest	9	15	976	4	s__tarriest
stateliest	10	4	635	4	s_tateliest
steeliest	9	3	964	4	s__teeliest
sternest	8	3	1443	4	s___ternest
stitcheries	16	5	307	4	stitcheries_
sultriest	9	3	865	4	s_ult_riest
summeriest	14	7	608	4	s_ummeriest
sweltriest	13	4	328	4	swelt_riest
uninterest	10	4	567	4	uninter_est
wateriest	12	3	1223	4	__wateriest
wintriest	12	3	815	4	_wint_riest
wittiest	11	27	1152	4	_witt__iest
zitherist	21	4	660	4	_zitheri_st

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	81	7.813	19047.6
3	Display Results	81	81	0.046	1760.9
	(SQL Overall)	178691	81	8.279	21583.6