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

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

292 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
shysters	14	10	646	(None)
shyster	13	11	656	1	shyster_
clysters	13	22	784	2	clysters
keysters	15	32	633	2	keysters
oysters	10	34	1169	2	_oysters
roysters	11	36	1053	2	roysters
shatters	11	33	1391	2	shatters
sheeters	11	31	1186	2	sheeters
shelters	11	34	1281	2	shelters
shifters	14	31	986	2	shifters
shooters	11	28	1158	2	shooters
shouters	11	35	1062	2	shouters
shunters	11	32	1075	2	shunters
shushers	14	26	705	2	shushers
shutters	11	36	1135	2	shutters
shyers	12	47	1220	2	shy__ers
sisters	7	37	2159	2	s_isters
systems	12	3	468	2	s_ystems
trysters	11	29	837	2	trysters
xysters	17	30	716	2	_xysters
assisters	9	3	635	3	assisters
asters	6	56	3160	3	__asters
basters	9	49	3030	3	_basters
bisters	9	39	2261	3	_bisters
blasters	10	41	1614	3	blasters
blisters	10	40	1508	3	blisters
blusters	10	44	1389	3	blusters
boasters	10	39	1566	3	boasters
bolsters	10	37	1245	3	bolsters
boosters	10	40	1344	3	boosters
bursters	10	3	898	3	bursters
busters	9	47	2413	3	_busters
casters	9	47	2990	3	_casters
chanters	13	40	1674	3	chanters
chapters	15	40	1213	3	chapters
charters	13	41	1558	3	charters
chasers	12	37	1492	3	chas_ers
chastens	13	42	918	3	chastens
chaster	12	47	1850	3	chaster_
chatters	13	42	1395	3	chatters
cheaters	13	36	1351	3	cheaters
chitters	13	37	1117	3	chitters
chunters	13	39	1090	3	chunters
clusters	10	29	1240	3	clusters
clyster	12	31	745	3	clyster_
coasters	10	43	1733	3	coasters
costers	9	41	2833	3	_costers
dabsters	11	3	705	3	dabsters
daystars	12	4	390	3	daystars
diasters	9	29	1318	3	diasters
diesters	9	25	1360	3	diesters
dusters	8	49	1836	3	_dusters
easters	7	51	2568	3	_easters
esters	6	46	2773	3	__esters
feasters	11	5	1156	3	feasters
festers	10	41	2139	3	_festers
fibsters	13	12	641	3	fibsters
flusters	11	38	1150	3	flusters
fosters	10	42	2010	3	_fosters
gagsters	10	31	708	3	gagsters
gasters	8	56	2429	3	_gasters
geysers	11	3	570	3	geys_ers
glisters	9	39	1260	3	glisters
gristers	9	40	1340	3	gristers
gypsters	14	3	402	3	gypsters
hafters	13	46	1433	3	_hafters
halters	10	46	1980	3	_halters
hamsters	13	7	1042	3	hamsters
hastens	10	62	1481	3	_hastens
hastes	9	57	2707	3	_haste_s
haters	9	49	3040	3	_h_aters
hatters	10	42	2152	3	_hatters
heaters	10	42	2522	3	_heaters
hefters	13	43	1200	3	_hefters
heisters	11	34	1313	3	heisters
hinters	10	37	1958	3	_hinters
hipsters	13	26	879	3	hipsters
hissers	10	41	1231	3	_hissers
hitters	10	47	1759	3	_hitters
hoisters	11	35	1348	3	hoisters
holsters	11	32	1194	3	holsters
hooters	10	45	2047	3	_hooters
hosers	9	52	2396	3	_hos_ers
hosiers	10	42	1264	3	_hosiers
hostels	10	37	1231	3	_hostels
hostess	10	32	1024	3	_hostess
hostlers	11	33	1048	3	_hostlers
hunters	10	39	1573	3	_hunters
hurters	10	34	1364	3	_hurters
huskers	14	35	1004	3	_huskers
hustlers	11	34	920	3	_hustlers
hypers	14	48	1191	3	_hy_pers
hysteria	14	4	739	3	_hysteria
hysterias	15	4	715	3	_hysterias
hysteric	16	4	753	3	_hysteric
hysterics	17	4	605	3	_hysterics
jesters	14	41	1819	3	_jesters
jousters	15	32	1042	3	jousters
justers	14	38	1573	3	_justers
keesters	12	31	959	3	keesters
keisters	12	32	1204	3	keisters
keyster	14	25	615	3	keyster_
kiesters	12	33	1015	3	kiesters
klisters	12	39	1048	3	klisters
lamsters	10	9	975	3	lamsters
lasters	7	56	2769	3	_lasters
leisters	8	33	1282	3	leisters
listers	7	40	2653	3	_listers
lobsters	10	26	874	3	lobsters
lusters	7	39	2144	3	_lusters
masters	9	46	2892	3	_masters
meisters	10	33	1384	3	meisters
minsters	10	38	1392	3	minsters
misters	9	39	2751	3	_misters
mobsters	12	35	906	3	mobsters
monsters	10	33	1455	3	monsters
munsters	10	40	1055	3	munsters
musters	9	45	2251	3	_musters
mystery	15	43	652	3	_mystery
nesters	7	44	2279	3	_nesters
oldsters	9	9	673	3	oldsters
ousters	7	41	2279	3	_ousters
oyster	9	41	1170	3	_oyster_
pasters	9	45	3173	3	_pasters
pensters	10	30	1212	3	pensters
pesters	9	38	2709	3	_pesters
philters	13	9	817	3	philters
physeds	16	34	403	3	phys_eds
physes	14	39	978	3	phys_e_s
piasters	10	29	1281	3	piasters
plasters	10	35	1813	3	plasters
posters	9	39	2801	3	_posters
presters	10	34	1900	3	presters
punsters	10	33	1058	3	punsters
questers	17	16	876	3	questers
rasters	7	46	2902	3	_rasters
resters	7	41	3040	3	_resters
rhymers	15	36	554	3	rhy_mers
rhymesters	18	4	260	3	rhymesters
roasters	8	36	1593	3	roasters
roisters	8	36	1555	3	roisters
roosters	8	35	1466	3	roosters
rosters	7	37	2754	3	_rosters
rousters	8	43	1568	3	rousters
royster	10	31	1053	3	royster_
salters	7	36	2225	3	s_alters
saluters	8	31	986	3	saluters
saunters	8	29	1175	3	saunters
sayers	9	42	2159	3	say__ers
scamsters	13	3	499	3	scamsters
scatters	10	36	1275	3	scatters
scepters	12	3	779	3	scepters
schussers	14	4	255	3	schussers
scooters	10	35	1103	3	scooters
scoters	9	33	1381	3	s_coters
scouters	10	34	1132	3	scouters
scutters	10	33	1102	3	scutters
seamsters	11	3	633	3	seamsters
seaters	7	40	2894	3	s_eaters
seisers	7	38	1639	3	seis_ers
semesters	11	3	912	3	semesters
sestets	7	9	1147	3	s_estets
setters	7	38	2206	3	s_etters
shaders	11	59	1555	3	sh_aders
shakers	14	40	1556	3	sh_akers
shammers	15	37	1084	3	shammers
shanteys	14	39	551	3	shanteys
shapers	12	40	1689	3	sh_apers
sharers	10	47	2062	3	sh_arers
sharkers	15	40	1105	3	sharkers
sharpers	13	38	1094	3	sharpers
shatter	10	36	1570	3	shatter_
shavers	13	41	1509	3	sh_avers
shearers	11	39	1132	3	shearers
sheathers	15	5	755	3	sheathers
shedders	13	26	743	3	shedders
sheers	9	43	2240	3	sh__eers
sheeter	10	38	1491	3	sheeter_
shellers	11	28	1258	3	shellers
shelter	10	32	1496	3	shelter_
shelvers	14	38	881	3	shelvers
shewers	13	43	1205	3	sh_ewers
shickers	17	30	1282	3	shickers
shiers	9	49	2175	3	sh__iers
shifter	13	29	1108	3	shifter_
shikkers	14	32	652	3	shikkers
shimmers	15	26	941	3	shimmers
shiners	10	40	1594	3	sh_iners
shippers	15	30	1231	3	shippers
shirkers	15	31	958	3	shirkers
shists	9	65	1511	3	shist__s
shivers	13	37	1483	3	sh_ivers
shockers	17	31	946	3	shockers
shoers	9	45	1833	3	sh__oers
shooter	10	30	1399	3	shooter_
shoppers	15	30	1076	3	shoppers
shortens	11	28	899	3	shortens
shorter	10	35	1550	3	shorter_
shotes	9	53	2191	3	sh_ote_s
shouter	10	32	1308	3	shouter_
shovers	13	46	1300	3	sh_overs
showers	13	46	1268	3	sh_owers
shrivers	14	41	910	3	shrivers
shtetels	11	4	323	3	shtetels
shuckers	17	38	813	3	shuckers
shudders	13	31	664	3	shudders
shunners	11	31	774	3	shunners
shunter	10	36	1173	3	shunter_
shusher	13	28	811	3	shusher_
shushes	13	35	1030	3	shushe_s
shutes	9	35	1822	3	sh_ute_s
shutter	10	37	1214	3	shutter_
shuttlers	12	5	412	3	shuttlers
shyer	11	47	1478	3	shy__er_
shyness	13	4	499	3	shy_ness
sifters	10	37	1479	3	s_ifters
sighters	12	25	1060	3	sighters
sinters	7	40	2408	3	s_inters
sister	6	44	2158	3	s_ister_
sitters	7	42	2155	3	s_itters
skaters	11	35	1296	3	s_katers
skeeters	12	29	896	3	skeeters
skelters	12	34	937	3	skelters
skirters	12	33	724	3	skirters
skitters	12	34	955	3	skitters
slashers	11	33	1361	3	slashers
slaters	7	31	2373	3	s_laters
slitters	8	40	1413	3	slitters
slotters	8	40	1240	3	slotters
smashers	13	33	959	3	smashers
smatters	10	40	1171	3	smatters
smelters	10	33	1051	3	smelters
smiters	9	34	1436	3	s_miters
snifters	11	31	861	3	snifters
snorters	8	34	1058	3	snorters
songsters	10	4	611	3	songsters
sorters	7	42	2113	3	s_orters
souters	7	44	2260	3	s_outers
spatters	10	39	1470	3	spatters
specters	12	28	1106	3	specters
spelters	10	39	1224	3	spelters
spinsters	11	3	661	3	spinsters
spitters	10	41	1338	3	spitters
sporters	10	37	1406	3	sporters
spotters	10	43	1338	3	spotters
spouters	10	40	1116	3	spouters
spurters	10	33	1170	3	spurters
sputters	10	40	1287	3	sputters
spymasters	17	4	280	3	spymasters
starters	8	37	1477	3	starters
staters	7	39	2234	3	s_taters
stinters	8	33	1275	3	stinters
stutters	8	32	1047	3	stutters
stylers	10	35	935	3	sty_lers
sudsers	8	33	1042	3	suds_ers
suiters	7	36	1888	3	s_uiters
sumpters	12	3	802	3	sumpters
swashers	14	38	953	3	swashers
swatters	11	39	1179	3	swatters
sweaters	11	38	1106	3	sweaters
swelters	11	31	1019	3	swelters
swifters	14	27	748	3	swifters
swishers	14	32	805	3	swishers
swotters	11	44	848	3	swotters
syphers	15	31	727	3	s_yphers
system	11	3	574	3	s_yste_m
tapsters	10	31	880	3	tapsters
tasters	7	42	2564	3	_tasters
testers	7	41	2454	3	_testers
theaters	11	42	1190	3	theaters
thirsters	12	3	523	3	thirsters
thrusters	12	4	533	3	thrusters
tipsters	10	27	851	3	tipsters
toasters	8	39	1272	3	toasters
trusters	8	31	1226	3	trusters
tryster	10	36	951	3	tryster_
trystes	10	41	999	3	tryste_s
twisters	11	26	817	3	twisters
ulsters	7	27	1198	3	_ulsters
waisters	11	38	1152	3	waisters
wasters	10	40	2659	3	_wasters
websters	13	3	580	3	websters
westers	10	52	2196	3	_westers
whetters	14	24	665	3	whetters
whiskers	18	30	677	3	whiskers
whispers	16	26	699	3	whispers
whistlers	15	9	516	3	whistlers
whitters	14	35	940	3	whitters
wresters	11	27	1173	3	wresters
xyster	16	36	680	3	_xyster_
zesters	16	35	1729	3	_zesters
zosters	16	30	1541	3	_zosters

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	146162	0.406	440125.6
2	DLD Change Limit	146162	292	7.076	20656.0
3	Display Results	292	292	0.110	2654.5
	(SQL Overall)	178691	292	7.592	23536.7