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

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

269 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
bastard	10	30	1242	(None)
bastards	11	33	1031	1	bastards
bastardy	14	32	600	1	bastardy
bustard	10	38	972	1	bustard
dastard	9	27	970	1	dastard
bastardly	15	26	429	2	bastardly
basted	9	52	2723	2	bast_ed
baster	8	53	3359	2	baster_
basters	9	49	3030	2	basters
bayard	12	44	1166	2	ba_yard
brassard	11	4	468	2	brassard
bustards	11	30	851	2	bustards
costard	10	41	1335	2	costard
custard	10	38	997	2	custard
dastards	10	27	808	2	dastards
eastward	12	4	499	2	eastward
mustard	10	35	953	2	mustard
aboard	9	3	1261	3	_aboard
abstain	9	4	725	3	abstain
absurd	9	3	590	3	abs_urd
afeard	10	5	826	3	_afeard
altar	5	55	2064	3	_altar_
altars	6	45	1815	3	_altars
ascared	10	39	952	3	_ascared
ascarid	10	39	1072	3	_ascarid
aster	5	54	3489	3	_aster_
astern	6	48	1581	3	_astern
asters	6	56	3160	3	_asters
astir	5	55	1709	3	_astir_
astral	6	69	1928	3	_astral
astray	9	56	1554	3	_astray
aswarm	11	10	791	3	_aswarm
attar	5	65	1669	3	_attar_
attars	6	45	1531	3	_attars
award	9	71	1804	3	_a_ward
baaed	8	52	1816	3	ba__aed
baccara	13	4	714	3	baccara
backward	20	4	810	3	backward
backyard	20	4	684	3	backyard
badland	11	4	765	3	badland
baited	9	53	1924	3	bait_ed
baiter	8	44	2255	3	baiter_
baiters	9	46	1930	3	baiters
ballad	9	43	1532	3	balla_d
ballyard	14	4	589	3	ballyard
bandaid	11	3	1048	3	bandaid
bandstand	13	4	393	3	bandstand
bankcard	17	7	402	3	bankcard
bantam	10	3	1406	3	banta_m
bantams	11	4	906	3	bantams
banter	8	48	2533	3	banter_
bantered	11	33	1363	3	bantered
banters	9	46	2311	3	banters
bard	7	56	4886	3	b___ard
barmaid	12	3	820	3	barmaid
barnyard	14	4	378	3	barnyard
bartend	10	3	875	3	bartend
barter	8	55	2537	3	barter_
bartered	11	31	1301	3	bartered
barters	9	42	2303	3	barters
barware	12	6	1070	3	barware
basal	7	57	2228	3	bas_a_l
basalt	8	35	1958	3	bas_alt
baseboard	14	4	554	3	baseboard
based	8	53	3158	3	bas__ed
baser	7	48	2892	3	bas_er_
bashaw	14	34	930	3	basha_w
bashaws	15	34	771	3	bashaws
bashed	12	62	2570	3	bas_hed
basher	11	51	2381	3	basher_
bashers	12	48	2083	3	bashers
basilar	9	3	730	3	basilar_
basilary	13	4	506	3	basilary
basined	10	3	1000	3	basined
basked	13	52	1860	3	bas_ked
basmati	11	4	823	3	basmati
bast	6	63	6241	3	bast___
bastardies	13	6	514	3	bastard~~ies~~
bastardise	13	8	356	3	bastard~~ise~~
bastardize	22	6	309	3	bastard~~ize~~
baste	7	48	2998	3	bast__e
bastes	8	53	3038	3	bast_es
bastile	9	3	1391	3	bastile
basting	10	42	2720	3	basting
bastion	9	3	1247	3	bastion
basts	7	59	3693	3	bast__s
bated	8	59	3553	3	ba_t_ed
bathed	12	55	1874	3	ba_thed
batted	9	56	2365	3	ba_tted
batter	8	49	2887	3	batter_
battered	11	33	1505	3	battered
batters	9	46	2601	3	batters
battery	12	49	1181	3	battery
battled	10	42	1312	3	battled
bayards	13	37	968	3	ba_yards
bazaar	17	30	640	3	bazaar_
bazaars	18	27	588	3	bazaars
bazar	16	38	1600	3	ba_zar_
bazars	17	46	1311	3	ba_zars
beard	8	60	2496	3	b__eard
bedstand	12	4	433	3	bedstand
bedward	14	9	747	3	bedward
beeyard	13	3	552	3	beeyard
bestead	10	38	911	3	bestead
bested	9	49	2275	3	best_ed
bestiary	13	4	481	3	bestiary
bestir	8	3	1116	3	bestir_
bestirs	9	3	1113	3	bestirs
bestrid	10	3	997	3	bestrid
bestud	9	43	930	3	best_ud
beswarm	14	4	578	3	beswarm
bistate	9	3	1382	3	bistate
bister	8	49	2276	3	bister_
bistered	11	29	1332	3	bistered
bisters	9	39	2261	3	bisters
bistort	9	12	1652	3	bistort
bistre	8	38	1502	3	bist_re
bistred	10	33	1185	3	bistred
bistro	8	33	994	3	bist_ro
blasted	10	42	1347	3	blast_ed
blaster	9	40	1730	3	blaster_
blasters	10	41	1614	3	blasters
board	8	55	2300	3	b__oard
boasted	10	41	1374	3	boast_ed
boaster	9	46	1643	3	boaster_
boasters	10	39	1566	3	boasters
boatyard	14	4	407	3	boatyard
bollard	10	32	1050	3	bollard
bombard	14	3	733	3	bombard
boyard	12	54	1128	3	b_oyard
brassards	12	4	406	3	brassards
brassart	10	4	750	3	brassart
briard	9	43	1129	3	b_riard
busbar	10	3	845	3	busbar_
busbars	11	3	815	3	busbars
busted	9	51	2315	3	bust_ed
buster	8	47	2649	3	buster_
busters	9	47	2413	3	busters
bustled	10	40	1151	3	bustled
buzzard	18	4	427	3	buzzard
cabstand	13	4	441	3	cabstand
canard	9	3	1476	3	ca_nard
cascara	11	3	831	3	cascara
caster	8	52	3257	3	caster_
casters	9	47	2990	3	casters
castled	10	43	1151	3	castled
castor	8	44	1853	3	castor_
castors	9	49	1944	3	castors
coastward	15	4	355	3	coastward
costar	8	55	1861	3	costar_
costards	11	35	1079	3	costards
costars	9	42	1801	3	costars
custards	11	33	839	3	custards
custardy	14	31	490	3	custardy
dastardly	14	27	380	3	dastardly
datary	10	3	1024	3	da_tary
daystar	11	4	344	3	daystar_
daystars	12	4	390	3	daystars
discard	11	3	1021	3	discard
dotard	8	3	905	3	_dotard
easter	6	50	2798	3	easter_
eastern	7	44	1253	3	eastern
easters	7	51	2568	3	easters
eastwards	13	4	425	3	eastwards
fasted	10	53	2095	3	fast_ed
faster	9	46	2577	3	faster_
gabbard	13	3	655	3	gabbard
gasted	8	48	2158	3	gast_ed
gaster	7	50	2735	3	gaster_
gasters	8	56	2429	3	gasters
gastral	8	32	955	3	gastral
haftara	13	13	609	3	haftara
haggard	13	37	718	3	haggard
halyard	14	7	697	3	halyard
hastate	10	3	1391	3	hastate
hasted	10	51	2528	3	hast_ed
hayward	17	3	641	3	hayward
hazard	19	3	840	3	ha_zard
instar	6	3	1001	3	instar_
instars	7	4	1113	3	instars
kantar	10	3	1115	3	kantar_
kantars	11	3	1003	3	kantars
lactary	12	3	784	3	lactary
laggard	10	34	762	3	laggard
laniard	8	6	852	3	laniard
lanyard	11	6	729	3	lanyard
lascar	8	6	857	3	lascar_
lascars	9	7	901	3	lascars
lasted	7	43	2360	3	last_ed
laster	6	48	3063	3	laster_
lasters	7	56	2769	3	lasters
leotard	8	4	619	3	leotard
mallard	10	3	1027	3	mallard
mansard	10	4	931	3	mansard
manward	13	4	909	3	manward
mascara	11	3	802	3	mascara
mastaba	11	4	622	3	mastaba
masted	9	40	2580	3	mast_ed
master	8	48	3134	3	master_
mastered	11	26	1400	3	mastered
masters	9	46	2892	3	masters
mastery	12	42	1432	3	mastery
mastoid	10	7	1123	3	mastoid
mazard	18	3	876	3	ma_zard
mazzard	18	4	446	3	mazzard
mustards	11	29	788	3	mustards
mustardy	14	26	505	3	mustardy
pasta	7	66	2453	3	pasta__
pastas	8	54	2287	3	pasta_s
pasted	9	44	2690	3	past_ed
paster	8	57	3437	3	paster_
pastern	9	44	1506	3	pastern
pasters	9	45	3173	3	pasters
pastor	8	48	1748	3	pastor_
pastored	11	3	996	3	pastored
pastors	9	41	1900	3	pastors
pastry	11	49	1303	3	past_ry
pasture	9	3	1146	3	pasture
pastured	11	3	823	3	pastured
petard	9	50	1380	3	_petard
postcard	13	4	652	3	postcard
raster	6	47	3144	3	raster_
rasters	7	46	2902	3	rasters
restart	7	3	2003	3	restart
retard	7	50	1893	3	_retard
ritard	7	48	1208	3	_ritard
saggard	10	35	895	3	saggard
sard	5	53	4424	3	__s_ard
satara	6	3	1553	3	sa_tara
shard	9	61	2596	3	__shard
staid	6	67	2208	3	__staid
stand	6	59	2328	3	__stand
star	4	80	3776	3	__star_
stare	5	44	4026	3	__stare
stared	7	54	2987	3	__stared
stark	9	54	2562	3	__stark
stars	5	58	3657	3	__stars
start	5	56	4231	3	__start
sward	9	42	2146	3	__sward
tabard	9	3	1333	3	ta_bard
tankard	12	6	726	3	tankard
tantara	7	24	1082	3	tantara
tanyard	11	6	718	3	tanyard
tartar	6	32	1475	3	tartar_
tartare	7	30	1268	3	tartare
tartars	7	33	1340	3	tartars
tasted	7	41	2397	3	tast_ed
taster	6	49	3057	3	taster_
tasters	7	42	2564	3	tasters
tatar	5	61	2206	3	ta_tar_
tatars	6	46	1979	3	ta_tars
unitard	8	3	800	3	unitard
upstand	10	4	534	3	upstand
upstare	9	15	868	3	upstare
upstared	11	15	657	3	upstared
upstart	9	15	975	3	upstart
vanward	14	5	694	3	vanward
vaster	9	45	2102	3	vaster_
vaward	13	49	872	3	va_ward
visard	10	39	1012	3	vis_ard
vistaed	11	3	802	3	vistaed
wastage	11	10	925	3	wastage
wasted	10	44	2302	3	wast_ed
waster	9	52	2894	3	waster_
wasters	10	40	2659	3	wasters
wastery	13	46	1099	3	wastery
wastry	12	38	877	3	wast_ry
wayward	17	3	605	3	wayward
westward	15	4	382	3	westward

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	134027	0.436	409841.7
2	DLD Change Limit	134027	269	6.906	19407.3
3	Display Results	269	269	0.093	2892.5
	(SQL Overall)	178691	269	7.435	24033.8