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

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

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

450 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
biles	7	55	4214	(None)
bales	7	62	5008	1	bales
bibles	10	46	1764	1	bibles
bices	9	50	2996	1	bices
bides	8	55	3677	1	bides
bikes	11	75	2947	1	bikes
bile	6	61	4718	1	bile_
bilges	9	49	1563	1	bilges
bilks	11	51	1789	1	bilks
bills	7	56	3286	1	bills
bines	7	69	4679	1	bines
birles	8	49	2064	1	birles
bises	7	54	3562	1	bises
bites	7	56	4117	1	bites
bizes	16	59	2366	1	bizes
boles	7	54	4860	1	boles
files	8	54	4127	1	files
miles	7	46	4507	1	miles
piles	7	47	4261	1	piles
riles	5	53	4364	1	riles
tiles	5	55	4210	1	tiles
wiles	8	54	3787	1	wiles
abeles	8	47	1939	2	abeles
abides	9	47	1989	2	abides
ables	7	59	3554	2	ables
aides	6	53	3660	2	aides
ailed	6	62	4028	2	ailed
ails	4	56	5471	2	ail_s
aisles	6	47	2114	2	aisles
ales	4	70	6710	2	_ales
arles	5	67	3574	2	arles
axles	12	52	1947	2	axles
babes	9	58	3411	2	babes
bailed	9	47	2665	2	bailed
bailee	8	45	2601	2	bailee
bailees	9	39	1438	2	bailees
bailer	8	54	2525	2	bailer
bailers	9	42	2135	2	bailers
bailey	11	50	1567	2	bailey
baileys	12	38	893	2	baileys
bailies	9	41	2020	2	bailies
bails	7	59	3352	2	bail_s
baizes	17	43	1505	2	baizes
bakes	11	70	3537	2	bakes
balas	7	69	3721	2	balas
balds	8	55	2464	2	balds
bale	6	63	5384	2	bale_
baled	8	54	3644	2	baled
baler	7	56	3527	2	baler
balers	8	56	2693	2	balers
balks	11	49	2629	2	balks
balls	7	62	3641	2	balls
balms	9	57	2392	2	balms
bals	6	63	5404	2	bal_s
banes	7	49	4558	2	banes
bares	7	54	5713	2	bares
bases	7	56	4435	2	bases
bates	7	58	4634	2	bates
bees	6	54	5338	2	b_ees
beiges	9	10	1441	2	beiges
belies	8	46	3105	2	belies
belles	8	53	2599	2	belles
bells	7	64	3216	2	bells
bels	6	61	4249	2	bel_s
belts	7	59	3116	2	belts
benes	7	55	3623	2	benes
bes	5	65	5743	2	b__es
beses	7	58	3072	2	beses
bialies	9	36	1841	2	bialies
bialis	8	36	1716	2	bialis
bialys	11	38	791	2	bialys
bias	6	47	3816	2	bi_as
biases	8	46	1843	2	biases
bibbs	8	49	1158	2	bibbs
bible	9	51	1942	2	bible_
bibless	11	43	917	2	bibless
bibs	8	48	3099	2	bi_bs
bice	8	62	3556	2	bice_
bicep	11	54	1354	2	bicep
biceps	12	44	771	2	biceps
bide	7	60	4150	2	bide_
bided	9	54	2496	2	bided
bider	8	57	2837	2	bider
biders	9	48	2280	2	biders
bidet	8	49	3562	2	bidet
bidets	9	52	1553	2	bidets
bidis	8	67	2114	2	bidis
bids	7	58	3845	2	bi_ds
bield	8	46	1465	2	bield
bields	9	41	1000	2	bields
bier	6	55	3183	2	bi_er
biers	7	62	2522	2	biers
biffs	13	48	1441	2	biffs
biflex	18	3	495	2	biflex
bigos	8	50	2001	2	bigos
bigs	7	62	3502	2	bi_gs
bike	10	65	3260	2	bike_
biked	12	53	2003	2	biked
biker	11	60	2256	2	biker
bikers	12	45	1755	2	bikers
bikies	12	45	1516	2	bikies
bilbies	11	47	1234	2	bilbies
bilbo	9	55	1361	2	bilbo
bilboes	11	44	1024	2	bilboes
bilbos	10	50	1120	2	bilbos
bilby	12	49	1235	2	bilby
bilge	8	76	1891	2	bilge
bilged	10	55	1318	2	bilged
bilgy	11	47	1371	2	bilgy
bilk	10	58	2442	2	bil_k
bilked	13	40	1294	2	bilked
bilker	12	49	1344	2	bilker
bilkers	13	47	1186	2	bilkers
bill	6	72	3994	2	bil_l
billed	9	42	2490	2	billed
biller	8	49	2348	2	biller
billers	9	47	2083	2	billers
billet	8	60	2972	2	billet
billets	9	45	1615	2	billets
billies	9	39	2350	2	billies
billy	10	55	2536	2	billy
bimas	9	55	2174	2	bimas
bindles	10	40	1645	2	bindles
binds	8	66	2747	2	binds
bine	6	66	5086	2	bine_
biner	7	59	3069	2	biner
biners	8	50	2363	2	biners
binges	9	39	2312	2	binges
bins	6	65	4825	2	bi_ns
bints	7	61	3018	2	bints
biogs	8	50	1611	2	biogs
biomes	10	38	1525	2	biomes
bios	6	63	3532	2	bi_os
biped	10	47	1883	2	biped
bipeds	11	45	805	2	bipeds
birds	8	54	2133	2	birds
birks	11	49	2030	2	birks
birle	7	50	2363	2	birle_
birled	9	44	1699	2	birled
birler	8	57	1508	2	birler
birlers	9	38	1300	2	birlers
birls	7	40	2316	2	birls
biros	7	53	2513	2	biros
birrs	7	49	1710	2	birrs
birse	7	45	1740	2	birse
birses	8	47	1773	2	birses
bis	5	68	6066	2	bi__s
bise	6	64	3710	2	bise_
bisks	11	54	1680	2	bisks
bite	6	65	4700	2	bite_
biter	7	50	3003	2	biter
biters	8	39	2524	2	biters
bits	6	61	4816	2	bi_ts
bitts	7	50	2259	2	bitts
bize	15	59	2629	2	bize_
bizzes	16	39	1084	2	bizzes
bleb	8	54	2522	2	b_leb
blebs	9	64	1615	2	b_lebs
bled	7	57	2931	2	b_led
bless	7	59	1781	2	b_less
blest	7	64	3172	2	b_lest
blet	6	62	4767	2	b_let
blets	7	53	2494	2	b_lets
blew	9	47	2243	2	b_lew
blips	9	56	1578	2	blips
bliss	7	56	1691	2	bliss
blites	8	47	2121	2	blites
blues	7	51	2704	2	blues
bodes	8	49	3510	2	bodes
bogles	9	50	2083	2	bogles
boiled	9	50	2095	2	boiled
boiler	8	43	1927	2	boiler
boilers	9	34	1706	2	boilers
boils	7	54	2719	2	boil_s
boites	8	43	2270	2	boites
bolas	7	47	3376	2	bolas
bolds	8	58	2528	2	bolds
bole	6	64	4869	2	bole_
bolls	7	55	3131	2	bolls
bolos	7	55	3137	2	bolos
bolts	7	62	3211	2	bolts
bolus	7	91	2554	2	bolus
bones	7	64	4653	2	bones
bores	7	64	4825	2	bores
boules	8	49	2597	2	boules
boxes	14	56	2507	2	boxes
braes	7	57	3505	2	braes
brees	7	56	3255	2	brees
bribes	10	59	1853	2	bribes
brides	9	44	2351	2	brides
bridles	10	41	1447	2	bridles
bries	7	49	4215	2	bries
brills	8	49	1629	2	brills
brines	8	50	2885	2	brines
brises	8	49	2761	2	brises
bugles	9	48	2244	2	bugles
builds	9	37	849	2	builds
bulbs	9	60	1693	2	bulbs
bulges	9	59	1932	2	bulges
bulks	11	59	2061	2	bulks
bulls	7	56	2957	2	bulls
buses	7	59	3601	2	buses
butes	7	145	3587	2	butes
butles	8	44	2391	2	butles
byes	9	52	3053	2	b_yes
byres	10	44	2138	2	byres
bytes	10	52	1749	2	bytes
chiles	11	54	2530	2	chiles
cines	7	52	3968	2	cines
cires	7	49	3291	2	cires
cites	7	44	3559	2	cites
coles	7	60	5506	2	coles
dales	6	64	3974	2	dales
deles	6	51	3925	2	deles
dices	8	64	3424	2	dices
dies	5	56	5352	2	di_es
dikes	10	58	3133	2	dikes
dills	6	55	3097	2	dills
dimes	8	58	3304	2	dimes
dines	6	64	4915	2	dines
dites	6	63	3915	2	dites
dives	9	58	3240	2	dives
doles	6	78	4375	2	doles
ediles	7	40	1698	2	ediles
exiles	13	48	1640	2	exiles
fices	10	60	3116	2	fices
fifes	11	48	2239	2	fifes
file	7	54	4664	2	file_
filed	9	53	3190	2	filed
filer	8	54	3300	2	filer
filers	9	46	2372	2	filers
filet	8	55	4016	2	filet
filets	9	47	1895	2	filets
filles	9	42	2452	2	filles
fills	8	46	3237	2	fills
films	10	56	1796	2	films
filos	8	61	2538	2	filos
fils	7	58	3869	2	fil_s
fines	8	66	4426	2	fines
fires	8	57	4075	2	fires
fives	11	60	2736	2	fives
fixes	15	47	2359	2	fixes
flies	8	56	3071	2	flies
gales	6	54	4248	2	gales
gibes	8	44	2252	2	gibes
gies	5	56	4142	2	gi_es
gilds	7	54	1752	2	gilds
gills	6	47	2819	2	gills
gilts	6	49	2426	2	gilts
gites	6	56	3018	2	gites
gives	9	53	2487	2	gives
guiles	7	39	1928	2	guiles
gules	6	48	3104	2	gules
hales	8	54	4984	2	hales
hides	9	51	2942	2	hides
hies	7	48	4283	2	hi_es
hikes	12	54	2698	2	hikes
hills	8	54	3135	2	hills
hilts	8	69	2441	2	hilts
hilus	8	48	1764	2	hilus
hires	8	61	3434	2	hires
hives	11	69	2551	2	hives
holes	8	47	4865	2	holes
ibices	10	39	816	2	ibices
ibises	8	36	1054	2	ibises
ices	6	61	2964	2	_ices
ides	5	77	3423	2	_ides
idles	6	67	2012	2	idles
ilea	4	59	3146	2	_ilea
ileus	5	46	1689	2	_ileus
ilex	11	58	2203	2	_ilex
ilks	8	72	1857	2	_ilks
ills	4	70	3042	2	_ills
ires	4	56	3928	2	_ires
isles	5	42	2056	2	isles
jibes	14	55	2032	2	jibes
jills	12	51	2282	2	jills
jilts	12	47	1741	2	jilts
jives	15	48	2081	2	jives
joles	12	52	3083	2	joles
jubiles	16	28	937	2	jubiles
kales	9	57	3098	2	kales
kibes	11	55	2111	2	kibes
kikes	8	51	2255	2	kikes
kills	9	45	2617	2	kills
kilns	9	51	1298	2	kilns
kilos	9	50	2147	2	kilos
kilts	9	51	2218	2	kilts
kines	9	50	3913	2	kines
kites	9	54	3254	2	kites
les	3	56	6307	2	__les
lies	4	64	5419	2	li_es
likes	9	62	3190	2	likes
lilies	6	30	2141	2	lilies
lilos	5	58	2187	2	lilos
lilts	5	58	2280	2	lilts
limes	7	56	3650	2	limes
lines	5	70	5457	2	lines
lisles	6	34	1628	2	lisles
lives	8	61	3319	2	lives
mailes	8	43	2911	2	mailes
males	7	50	4979	2	males
mikes	11	51	2989	2	mikes
milds	8	64	2205	2	milds
mile	6	63	5257	2	mile_
miler	7	57	3306	2	miler
milers	8	46	2516	2	milers
milks	11	50	2058	2	milks
milles	8	45	2656	2	milles
mills	7	54	3505	2	mills
milos	7	54	2801	2	milos
mils	6	60	4533	2	mil_s
milts	7	54	3071	2	milts
mimes	9	57	3202	2	mimes
mines	7	56	5195	2	mines
mires	7	56	4088	2	mires
mises	7	47	4056	2	mises
mites	7	51	4180	2	mites
mixes	14	72	2440	2	mixes
mobiles	11	28	1312	2	mobiles
moles	7	47	4792	2	moles
mules	7	50	3429	2	mules
nides	6	52	2913	2	nides
nills	5	49	2667	2	nills
nils	4	61	3245	2	nil_s
nines	5	59	3734	2	nines
nites	5	57	3634	2	nites
nixes	12	45	1962	2	nixes
oboles	8	38	1583	2	oboles
ogles	6	52	2318	2	ogles
oiled	6	44	2947	2	oiled
oiler	5	46	2828	2	oiler
oilers	6	47	2119	2	oilers
oils	4	63	3797	2	oil_s
oles	4	64	5347	2	_oles
orles	5	53	2621	2	orles
pales	7	57	5380	2	pales
peles	7	57	3808	2	peles
pies	6	69	4960	2	pi_es
pikes	11	50	3103	2	pikes
pile	6	56	4969	2	pile_
pilea	7	51	2395	2	pilea
piled	8	52	3299	2	piled
pilei	7	40	2178	2	pilei
pileus	8	45	1494	2	pileus
pilis	7	58	2520	2	pilis
pills	7	41	3097	2	pills
pilus	7	59	2106	2	pilus
pines	7	60	4886	2	pines
pipes	9	60	3014	2	pipes
pixes	14	43	2317	2	pixes
plies	7	45	2651	2	plies
poles	7	53	5100	2	poles
pules	7	45	3881	2	pules
rales	5	49	4749	2	rales
ribes	7	55	3017	2	ribes
rices	7	55	3615	2	rices
rides	6	61	4081	2	rides
riels	5	51	2133	2	riels
rifles	9	42	1770	2	rifles
rile	4	56	5053	2	rile_
riled	6	58	3325	2	riled
riley	8	44	2058	2	riley
rilles	6	47	2550	2	rilles
rills	5	50	3271	2	rills
rimes	7	56	3454	2	rimes
ripes	7	54	3577	2	ripes
rises	5	52	4404	2	rises
rites	5	44	4255	2	rites
rives	8	53	3600	2	rives
roles	5	67	4798	2	roles
rules	5	52	3425	2	rules
sales	5	60	5559	2	sales
sices	7	56	3727	2	sices
sides	6	58	3836	2	sides
sidles	7	47	2115	2	sidles
sikes	9	62	3608	2	sikes
silds	6	55	2052	2	silds
silex	12	34	1741	2	silex
silks	9	46	2068	2	silks
sills	5	51	3599	2	sills
silos	5	60	2943	2	silos
silts	5	53	3082	2	silts
sines	5	59	5482	2	sines
sipes	7	60	3695	2	sipes
sires	5	59	4537	2	sires
sises	5	52	3383	2	sises
sites	5	60	4543	2	sites
sixes	12	45	2636	2	sixes
sizes	14	67	2776	2	sizes
smiles	8	45	2229	2	smiles
soles	5	55	4792	2	soles
spiles	8	42	2791	2	spiles
stiles	6	43	2877	2	stiles
tales	5	54	5137	2	tales
teles	5	45	3600	2	teles
tides	6	48	3015	2	tides
ties	4	52	4831	2	ti_es
tikes	9	56	2890	2	tikes
tildes	7	45	1396	2	tildes
tile	4	54	5144	2	tile_
tiled	6	48	3294	2	tiled
tiler	5	61	3102	2	tiler
tilers	6	35	2350	2	tilers
tills	5	46	3171	2	tills
tils	4	57	3961	2	til_s
tilts	5	53	2561	2	tilts
times	7	56	3082	2	times
tines	5	48	4842	2	tines
tires	5	54	3749	2	tires
titles	6	37	1992	2	titles
toiles	6	39	2351	2	toiles
toles	5	51	4713	2	toles
tules	5	45	3279	2	tules
vales	8	54	3426	2	vales
vibes	10	47	1995	2	vibes
vices	10	57	2553	2	vices
vies	7	52	3862	2	vi_es
vile	7	61	3980	2	vile_
viler	8	63	2416	2	viler
vilest	9	4	1684	2	vilest
vills	8	64	2932	2	vills
vines	8	51	3764	2	vines
vires	8	45	2968	2	vires
vises	8	44	2777	2	vises
voiles	9	46	1644	2	voiles
voles	8	62	3404	2	voles
wales	8	61	4283	2	wales
whiles	12	44	1801	2	whiles
wides	9	48	3282	2	wides
wifes	11	45	2256	2	wifes
wilds	9	48	1820	2	wilds
wile	7	59	4437	2	wile_
wiled	9	52	3155	2	wiled
wills	8	45	2896	2	wills
wilts	8	50	2350	2	wilts
wines	8	55	4686	2	wines
wipes	10	48	2708	2	wipes
wires	8	60	3491	2	wires
wises	8	56	3319	2	wises
wites	8	55	3696	2	wites
wives	11	53	2892	2	wives
wizes	17	47	2334	2	wizes
wyles	11	46	1532	2	wyles
yikes	12	51	1775	2	yikes
yills	8	39	2155	2	yills
yipes	10	60	1784	2	yipes
yules	8	45	2158	2	yules
zills	14	40	2078	2	zills
zines	14	52	3265	2	zines

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	450	1.466	36698.5
3	Display Results	450	450	0.126	3571.4
	(SQL Overall)	178691	450	1.888	94645.7