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

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

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

278 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
smitten	9	3	669	(None)
mitten	8	39	1409	1	_mitten
sitten	6	41	1382	1	s_itten
bitten	8	47	1512	2	_bitten
emitted	10	30	1085	2	emitted
emitter	9	32	1108	2	emitter
kitten	10	46	1148	2	_kitten
litten	6	40	1487	2	_litten
mittens	9	34	988	2	_mittens
omitted	10	34	789	2	omitted
omitter	9	29	850	2	omitter
shitted	11	42	1205	2	shitted
shotten	10	28	846	2	shotten
sitter	6	33	2338	2	s_itter
skitter	11	38	1040	2	skitter
slitted	8	35	1331	2	slitted
slitter	7	36	1587	2	slitter
smarten	9	34	886	2	smarten
smatter	9	36	1333	2	smatter
smidgen	11	42	651	2	smidgen
smite	7	52	2487	2	smi_te_
smiter	8	36	1641	2	smi_ter
smites	8	39	2192	2	smi_tes
smutted	10	3	746	2	smutted
spitted	10	39	1270	2	spitted
spitter	9	40	1518	2	spitter
written	10	33	635	2	written
admitted	12	3	476	3	admitted
admittee	11	4	513	3	admittee
admitter	11	3	511	3	admitter
amities	9	3	1738	3	amities
batten	8	52	1712	3	_batten
bitted	9	44	1848	3	_bitted
bitter	8	46	2267	3	_bitter
bittern	9	48	1068	3	_bittern
chitter	12	41	1296	3	chitter
cittern	9	33	914	3	_cittern
critter	9	41	1303	3	critter
demitted	12	28	877	3	demitted
embitter	12	24	562	3	embitter
emitters	10	34	964	3	emitters
emitting	11	24	1035	3	emitting
fatten	9	43	1490	3	_fatten
fitted	10	47	1666	3	_fitted
fitter	9	41	2003	3	_fitter
flatten	10	42	965	3	flatten
flitted	11	40	1164	3	flitted
flitter	10	34	1390	3	flitter
fritted	11	36	1133	3	fritted
fritter	10	39	1277	3	fritter
gitted	8	40	1505	3	_gitted
gittern	8	33	750	3	_gittern
gittin	7	29	1055	3	_gittin
glisten	8	41	808	3	glisten
glitter	8	42	1180	3	glitter
gotten	7	34	1011	3	_gotten
gritted	9	41	1090	3	gritted
gritter	8	39	1335	3	gritter
grutten	8	8	528	3	grutten
hitmen	11	23	919	3	_hitmen
hitter	9	44	1986	3	_hitter
imbitter	12	26	528	3	imbitter
imitate	9	3	1087	3	imitate_
imitated	11	3	826	3	imitated
imitates	10	3	1050	3	imitates
jitter	13	33	1499	3	_jitter
kitted	11	51	1483	3	_kitted
kittel	10	36	887	3	_kittel
kittens	11	34	758	3	_kittens
knitted	12	33	742	3	knitted
knitter	11	34	813	3	knitter
latten	6	50	1820	3	_latten
listen	6	48	1681	3	_listen
litter	6	43	2485	3	_litter
marten	8	45	1826	3	_marten
matte	7	56	2684	3	_matte_
matted	9	45	2141	3	_matted
matter	8	43	2534	3	_matter
mattes	8	56	2453	3	_mattes
mattin	8	44	1663	3	_mattin
midden	10	41	1285	3	_midden
mien	6	50	2837	3	_mi__en
milden	9	41	1315	3	_milden
milted	9	39	1994	3	_milted
milter	8	49	2123	3	_milter
minted	9	42	2058	3	_minted
minter	8	44	2510	3	_minter
mispen	10	3	1217	3	_mispen
misted	9	36	2582	3	_misted
mistend	10	38	1252	3	_mistend
mister	8	47	2856	3	_mister
mite	6	62	4942	3	_mi_te_
miter	7	57	3479	3	_mi_ter
mites	7	51	4180	3	_mi_tes
mither	11	42	1856	3	_mither
mitier	8	36	2067	3	_mitier
mitogen	10	3	696	3	_mitogen
mitre	7	55	2242	3	_mitre_
mitred	9	44	1434	3	_mitred
mitres	8	39	2207	3	_mitres
mitt	6	61	4550	3	_mitt__
mittened	11	3	637	3	_mittened
mitts	7	55	2375	3	_mitt_s
mizen	16	48	1527	3	_mi_zen
mizzen	16	44	795	3	_mizzen
moisten	9	31	1014	3	moisten
molten	8	33	1181	3	_molten
motte	7	55	2697	3	_motte_
mottes	8	55	2369	3	_mottes
mutter	8	44	1888	3	_mutter
mutton	8	5	1045	3	_mutton
omitters	10	27	765	3	omitters
omitting	11	21	774	3	omitting
patten	8	44	1819	3	_patten
pitmen	10	25	1079	3	_pitmen
pitted	9	43	1959	3	_pitted
quieten	16	25	810	3	quieten
quitted	17	33	989	3	quitted
quitter	16	29	1075	3	quitter
ratten	6	42	1738	3	_ratten
remitted	11	33	1207	3	remitted
remittent	11	4	828	3	remittent
remitter	10	28	1032	3	remitter
ritter	6	38	2242	3	_ritter
rotten	6	41	1543	3	_rotten
sainted	8	41	1424	3	sainted
saithe	9	47	1391	3	saithe_
samisen	9	3	767	3	sami_sen
samite	8	30	2060	3	sami_te_
samites	9	31	1871	3	sami_tes
sateen	6	38	1501	3	s_ateen
scatted	10	35	1277	3	scatted
scatter	9	38	1517	3	scatter
scutter	9	35	1217	3	scutter
seitan	6	26	1323	3	sei_tan
semiopen	12	4	526	3	semiopen
semitone	10	4	897	3	semitone
settee	6	37	2102	3	s_ettee
setter	6	40	2372	3	s_etter
shatter	10	36	1570	3	shatter
shifted	14	35	998	3	shifted
shifter	13	29	1108	3	shifter
shipmen	14	31	728	3	shipmen
shippen	14	29	886	3	shippen
shittah	13	8	515	3	shittah
shittier	11	3	731	3	shittier
shittim	12	4	513	3	shittim
shitting	12	32	1266	3	shitting
shitty	12	41	1006	3	shitt_y
shorten	10	35	1141	3	shorten
shotted	11	39	1240	3	shotted
shutter	10	37	1214	3	shutter
sicken	12	46	1525	3	s_icken
sifted	10	43	1367	3	s_ifted
sifter	9	45	1623	3	s_ifter
silken	10	44	1085	3	s_ilken
silted	7	40	2001	3	s_ilted
sinter	6	36	2592	3	s_inter
siren	5	45	2582	3	s_i_ren
sister	6	44	2158	3	s_ister
site	4	70	5242	3	s_i_te_
sited	6	51	3074	3	s_i_ted
sites	5	60	4543	3	s_i_tes
sithens	10	3	938	3	s_ithens
sitters	7	42	2155	3	s_itters
sitting	8	35	1963	3	s_itting
sixte	12	62	1658	3	s_ixte_
sixteen	14	3	411	3	sixteen
sixtes	13	36	1240	3	s_ixtes
skirted	12	38	861	3	skirted
skirter	11	33	848	3	skirter
skite	9	51	2006	3	ski_te_
skited	11	43	1348	3	ski_ted
skites	10	44	1804	3	ski_tes
skitters	12	34	955	3	skitters
skittery	15	31	510	3	skittery
skittle	11	3	553	3	skittle
skittles	12	4	576	3	skittles
slatted	8	40	1518	3	slatted
slattern	8	3	709	3	slattern
slicken	13	30	929	3	slicken
slidden	9	3	515	3	slidden
slither	10	41	1298	3	slither
slitters	8	40	1413	3	slitters
slittier	8	3	700	3	slittier
slitting	9	30	1258	3	slitting
slitty	9	32	916	3	slitt_y
slotted	8	46	1388	3	slotted
slotter	7	33	1445	3	slotter
smarted	10	50	1261	3	smarted
smartens	10	28	666	3	smartens
smarter	9	41	1313	3	smarter
smatters	10	40	1171	3	smatters
smelted	10	39	909	3	smelted
smelter	9	33	1191	3	smelter
smidge	10	37	848	3	smidge_
smidgens	12	32	564	3	smidgens
smidgeon	12	30	327	3	smidgeon
smidges	11	44	819	3	smidges
smidgin	11	33	510	3	smidgin
smile	7	48	2392	3	smi_le_
smiled	9	37	1643	3	smi_led
smiler	8	39	1668	3	smi_ler
smiles	8	45	2229	3	smi_les
smiley	11	40	1230	3	smi_ley
smirked	14	30	723	3	smirked
smirker	13	32	742	3	smirker
smit	6	51	3841	3	smi_t__
smiters	9	34	1436	3	smiters
smith	10	78	1805	3	smi_t_h
smithers	13	36	979	3	smithers
smithery	16	32	570	3	smithery
smithies	13	3	791	3	smithies
smiths	11	47	1102	3	smi_ths
smithy	14	50	827	3	smi_thy
smiting	10	30	1444	3	smiting
smoothen	13	20	496	3	smoothen
smote	7	58	2028	3	sm_ote_
smother	12	35	1021	3	smother
smuttier	10	3	521	3	smuttier
smutting	11	27	806	3	smutting
smutty	11	26	632	3	smutt_y
snifter	10	34	962	3	snifter
soften	9	42	949	3	s_often
somite	8	45	1937	3	somi_te_
somites	9	42	1912	3	somi_tes
sotted	7	41	2140	3	s_otted
spatted	10	40	1414	3	spatted
spatter	9	40	1652	3	spatter
spirted	10	39	1307	3	spirted
spite	7	54	3066	3	spi_te_
spited	9	48	2044	3	spi_ted
spites	8	41	2733	3	spi_tes
spitters	10	41	1338	3	spitters
spitting	11	30	1232	3	spitting
spittle	9	3	792	3	spittle
spittles	10	3	833	3	spittles
spittoon	10	4	251	3	spittoon
spitzes	18	4	918	3	spitzes
splitter	10	34	844	3	splitter
spotted	10	37	1314	3	spotted
spotter	9	45	1488	3	spotter
sputter	9	40	1405	3	sputter
stetted	8	26	1040	3	stetted
stiffen	13	28	602	3	stiffen
stilted	8	35	1147	3	stilted
stinted	8	29	1419	3	stinted
stinter	7	36	1451	3	stinter
stotted	8	35	1142	3	stotted
stouten	7	30	733	3	stouten
stutter	7	29	1146	3	stutter
submitted	14	4	523	3	submitted
submitter	13	4	528	3	submitter
subteen	9	3	852	3	subteen
suite	5	48	2956	3	sui_te_
suited	7	40	1942	3	sui_ted
suiter	6	41	2181	3	sui_ter
suites	6	37	2740	3	sui_tes
suttee	6	37	2154	3	s_uttee
swatted	11	41	1069	3	swatted
swatter	10	41	1332	3	swatter
sweeten	10	26	731	3	sweeten
swidden	12	3	423	3	swidden
swifter	13	31	805	3	swifter
swithe	12	40	1068	3	swithe_
swither	13	37	1099	3	swither
swotted	11	39	871	3	swotted
swotter	10	39	947	3	swotter
titmen	8	23	988	3	_titmen
titter	6	34	2116	3	_titter
twitted	11	32	663	3	twitted
twitter	10	27	809	3	twitter
umpteen	11	4	384	3	umpteen
unbitten	10	4	521	3	unbitten
whiten	12	41	1192	3	whi_ten
whitter	13	91	1089	3	whitter
witted	10	42	1681	3	_witted
writhen	13	40	786	3	writhen

Search took 7 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	134027	0.410	435831.7
2	DLD Change Limit	134027	278	6.356	21086.7
3	Display Results	278	278	0.093	2989.2
	(SQL Overall)	178691	278	6.859	26052.0