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

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

296 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
oldster	8	9	657	(None)
oldsters	9	9	673	1	oldsters
blaster	9	40	1730	2	blaster
blister	9	44	1531	2	blister
bluster	9	42	1531	2	bluster
bolster	9	37	1342	2	bol_ster
cluster	9	40	1333	2	cluster
clyster	12	31	745	2	clyster
fluster	10	39	1306	2	fluster
glister	8	40	1334	2	glister
holster	10	35	1221	2	hol_ster
klister	11	34	1064	2	klister
laster	6	48	3063	2	_laster
lister	6	45	2725	2	_lister
lobster	9	28	885	2	lobster
luster	6	40	2367	2	_luster
molester	10	9	937	2	molester
older	6	51	2117	2	old__er
oleaster	8	3	726	2	oleaster
ouster	6	42	2373	2	o_uster
oyster	9	41	1170	2	o_yster
plaster	9	33	1869	2	plaster
pollster	10	3	710	2	pollster
roadster	9	3	546	2	roadster
ulster	6	37	1210	2	ul_ster
alastor	7	3	965	3	alastor
alder	6	54	2191	3	ald__er
alerter	7	21	1151	3	alerter
alter	5	48	2850	3	al__ter
aster	5	54	3489	3	__aster
baluster	10	3	705	3	baluster
baster	8	53	3359	3	_baster
bister	8	49	2276	3	_bister
blasted	10	42	1347	3	blasted
blasters	10	41	1614	3	blasters
blastier	10	24	949	3	blastier
blatter	9	44	1565	3	blatter
bleater	9	45	1530	3	bleater
blesser	9	32	929	3	blesser
blisters	10	40	1508	3	blisters
blistery	13	41	871	3	blistery
bloater	9	40	1342	3	bloater
blotter	9	46	1285	3	blotter
blunter	9	45	1203	3	blunter
blurter	9	41	983	3	blurter
blusher	12	41	1311	3	blusher
blusters	10	44	1389	3	blusters
blustery	13	36	800	3	blustery
boaster	9	46	1643	3	boaster
bolder	9	48	2093	3	bold__er
bolsters	10	37	1245	3	bol_sters
bolter	8	39	2075	3	bol__ter
booster	9	43	1455	3	booster
burster	9	3	1029	3	burster
buster	8	47	2649	3	_buster
cadaster	11	3	690	3	cadaster
caster	8	52	3257	3	_caster
chaster	12	47	1850	3	chaster
clasher	12	46	1551	3	clasher
clasper	11	38	1186	3	clasper
classer	9	36	1461	3	classer
clatter	9	40	1497	3	clatter
cloister	10	3	709	3	cloister
closer	8	49	1820	3	clos_er
clouter	9	35	1169	3	clouter
clusters	10	29	1240	3	clusters
clustery	13	31	711	3	clustery
clutter	9	42	1166	3	clutter
clysters	13	22	784	3	clysters
coaster	9	42	1904	3	coaster
colder	9	51	2185	3	cold__er
colter	8	46	2509	3	col__ter
coster	8	43	3129	3	_coster
dabster	10	3	670	3	dabster
dater	6	53	3231	3	__dater
deluster	9	3	690	3	deluster
deter	6	50	2804	3	__deter
diaster	8	28	1331	3	diaster
diester	8	30	1368	3	diester
doomster	11	3	584	3	doomster
dopester	11	3	725	3	dopester
doter	6	54	2862	3	__doter
duster	7	49	1972	3	_duster
easter	6	50	2798	3	_easter
elater	6	47	2420	3	el_ater
elder	6	40	2002	3	eld__er
enlister	8	4	780	3	enlister
ester	5	47	2771	3	__ester
faster	9	46	2577	3	_faster
feaster	10	8	1298	3	feaster
feldsher	15	4	324	3	feldsher
fester	9	47	2351	3	_fester
fibster	12	14	653	3	fibster
filister	11	3	740	3	filister
flasher	13	39	1406	3	flasher
flatter	10	38	1596	3	flatter
fleeter	10	32	1036	3	fleeter
flesher	13	36	1092	3	flesher
flirter	10	31	867	3	flirter
flitter	10	34	1390	3	flitter
floater	10	44	1335	3	floater
flosser	10	33	969	3	flosser
flouter	10	43	1134	3	flouter
flusher	13	30	1227	3	flusher
flusters	11	38	1150	3	flusters
fluter	9	53	1686	3	fl_uter
flutter	10	40	1209	3	flutter
folder	10	43	1754	3	fold__er
folksier	15	3	353	3	folksier
forester	11	3	1367	3	forester
foster	9	43	2222	3	_foster
gagster	9	31	763	3	gagster
gaster	7	50	2735	3	_gaster
glisten	8	41	808	3	glisten
glisters	9	39	1260	3	glisters
glitter	8	42	1180	3	glitter
gloater	8	37	1101	3	gloater
glosser	8	34	1081	3	glosser
goldener	10	4	540	3	goldener
golder	8	44	1760	3	gold__er
grister	8	39	1541	3	grister
gypster	13	3	395	3	gypster
hamster	12	8	1042	3	hamster
heister	10	36	1362	3	heister
hipster	12	28	878	3	hipster
hoister	10	37	1420	3	hoister
holder	10	46	1965	3	hold__er
holdover	15	4	408	3	holdover
holsters	11	32	1194	3	hol_sters
honester	11	3	971	3	honester
hoopster	13	3	554	3	hoopster
inditer	8	35	1423	3	inditer
jester	13	43	1915	3	_jester
jokester	19	3	444	3	jokester
jolter	13	35	1309	3	jol__ter
jouster	14	33	1104	3	jouster
juster	13	46	1701	3	_juster
keester	11	31	991	3	keester
keister	11	30	1157	3	keister
keyster	14	25	615	3	keyster
kiester	11	32	997	3	kiester
klisters	12	39	1048	3	klisters
lamster	9	10	991	3	lamster
laser	5	46	3332	3	_las_er
lasher	9	48	2453	3	_lasher
lasted	7	43	2360	3	_lasted
lasters	7	56	2769	3	_lasters
later	5	48	4392	3	_l_ater
latter	6	50	2789	3	_latter
lefter	9	36	1343	3	_lefter
leister	7	32	1275	3	leister
lesser	6	35	1485	3	_lesser
letter	6	37	2258	3	_letter
lifter	9	38	1481	3	_lifter
linter	6	46	2534	3	_linter
lisper	8	41	1443	3	_lisper
listed	7	43	2283	3	_listed
listee	6	42	2306	3	_listee
listel	6	42	1474	3	_listel
listen	6	48	1681	3	_listen
listers	7	40	2653	3	_listers
liter	5	47	3634	3	_l_iter
litter	6	43	2485	3	_litter
loadstar	9	4	337	3	loadstar
lobsters	10	26	874	3	lobsters
locater	9	31	1360	3	locater
lodestar	9	4	441	3	lodestar
lodger	8	65	1769	3	lod_ger
lofter	9	46	1472	3	_lofter
loiter	6	46	1917	3	_loiter
looser	6	52	1994	3	loos_er
looter	6	42	2232	3	_looter
loser	5	47	2867	3	_los_er
lotter	6	40	2560	3	_lotter
lousier	7	24	1162	3	lousier
lusher	9	38	1876	3	_lusher
lusted	7	43	1944	3	_lusted
lusters	7	39	2144	3	_lusters
lustier	7	38	1350	3	_lustier
lustre	6	40	1168	3	_lustre
maltster	10	3	530	3	maltster
master	8	48	3134	3	_master
meister	9	31	1416	3	meister
minster	9	39	1432	3	minster
mister	8	47	2856	3	_mister
mobster	11	29	921	3	mobster
modester	11	9	748	3	modester
moister	9	40	1537	3	moister
molder	9	38	1927	3	mold__er
moldier	10	31	1003	3	mold_ier
molested	11	17	824	3	molested
molesters	11	9	887	3	molesters
molter	8	41	1942	3	mol__ter
monster	9	32	1460	3	monster
munster	9	37	1052	3	munster
muster	8	47	2452	3	_muster
nester	6	41	2418	3	_nester
oater	5	54	3373	3	o__ater
odder	7	45	1539	3	o_d_der
oersted	8	3	955	3	oersted
ofter	8	41	1687	3	o__fter
olden	6	51	1485	3	old__en
oldest	7	21	1409	3	oldest__
oldie	6	4	1547	3	old_ie_
oldies	7	3	1442	3	old_ies
olds	5	59	2657	3	olds___
oldstyle	12	4	209	3	oldstyle
oldstyles	13	4	223	3	oldstyles
oleasters	9	3	673	3	oleasters
oleate	6	3	1888	3	oleate_
oleates	7	4	1783	3	oleates
olestra	7	4	617	3	olestra
omitter	9	29	850	3	omitter
orbiter	9	3	785	3	orbiter
order	6	50	1936	3	ord__er
orderer	8	12	794	3	orderer
osier	5	35	1801	3	o__sier
ostler	6	33	1219	3	o__stler
otter	5	44	2397	3	o__tter
ousted	7	37	2058	3	o_usted
ousters	7	41	2279	3	o_usters
outer	5	56	3330	3	o__uter
outsteer	8	3	755	3	outsteer
oxter	12	34	1409	3	o__xter
oysters	10	34	1169	3	o_ysters
paster	8	57	3437	3	_paster
penster	9	28	1195	3	penster
pester	8	48	2759	3	_pester
piaster	9	30	1288	3	piaster
pilaster	10	3	816	3	pilaster
plaister	10	6	801	3	plaister
plaiter	9	36	1539	3	plaiter
planter	9	40	1780	3	planter
plasher	12	42	1503	3	plasher
plasters	10	35	1813	3	plasters
plastery	13	27	970	3	plastery
plater	8	44	2769	3	pl_ater
platter	9	39	1741	3	platter
pleater	9	39	1633	3	pleater
plotter	9	41	1366	3	plotter
plusher	12	40	1038	3	plusher
polder	9	40	1925	3	pold__er
polestar	10	4	711	3	polestar
polisher	13	8	807	3	polisher
politer	9	24	1707	3	pol_iter
pollsters	11	3	717	3	pollsters
polluter	10	3	540	3	polluter
polyester	14	4	535	3	polyester
poster	8	41	2917	3	_poster
prester	9	35	1962	3	prester
punster	9	29	1110	3	punster
quester	16	14	1002	3	quester
raster	6	47	3144	3	_raster
rester	6	38	3243	3	_rester
roadsters	10	3	510	3	roadsters
roaster	7	41	1666	3	roaster
robuster	10	3	566	3	robuster
roister	7	35	1620	3	roister
rooster	7	44	1517	3	rooster
roster	6	43	2908	3	_roster
rouster	7	35	1708	3	rouster
royster	10	31	1053	3	royster
sedater	8	37	1363	3	sedater
shyster	13	11	656	3	shyster
sister	6	44	2158	3	_sister
slasher	10	45	1533	3	slasher
slater	6	44	2918	3	sl_ater
slitter	7	36	1587	3	slitter
slotter	7	33	1445	3	slotter
solder	7	39	2134	3	sold__er
solderer	9	4	718	3	solderer
soldier	8	28	1215	3	sold_ier
songster	9	3	579	3	songster
sudser	7	35	1128	3	suds_er
sudsier	8	6	878	3	sudsier
tapster	9	29	927	3	tapster
taster	6	49	3057	3	_taster
tester	6	42	2715	3	_tester
tipster	9	29	905	3	tipster
toaster	7	44	1446	3	toaster
truster	7	31	1431	3	truster
tryster	10	36	951	3	tryster
twister	10	30	895	3	twister
ulsters	7	27	1198	3	ul_sters
updater	10	34	725	3	updater
vaster	9	45	2102	3	_vaster
waister	10	38	1238	3	waister
waster	9	52	2894	3	_waster
webster	12	3	609	3	webster
wester	9	42	2289	3	_wester
woodsier	12	4	547	3	woodsier
wrester	10	28	1241	3	wrester
xyster	16	36	680	3	_xyster
yester	9	34	1798	3	_yester
zester	15	36	1779	3	_zester
zoster	15	37	1585	3	_zoster

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.406	440125.6
2	DLD Change Limit	134027	296	5.923	22628.2
3	Display Results	296	296	0.093	3182.8
	(SQL Overall)	178691	296	6.422	27824.8