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

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

438 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
bile	6	61	4719	(None)
bale	6	63	5384	1	bale
bible	9	51	1942	1	bible
bice	8	62	3557	1	bice
bide	7	60	4151	1	bide
bike	10	65	3261	1	bike
biles	7	55	4214	1	biles
bilge	8	76	1891	1	bilge
bilk	10	58	2443	1	bilk
bill	6	72	3995	1	bill
bine	6	66	5087	1	bine
birle	7	50	2363	1	birle
bise	6	64	3711	1	bise
bite	6	65	4701	1	bite
bize	15	59	2630	1	bize
bole	6	64	4869	1	bole
file	7	54	4665	1	file
mile	6	63	5258	1	mile
pile	6	56	4970	1	pile
rile	4	56	5054	1	rile
tile	4	54	5145	1	tile
vile	7	61	3981	1	vile
wile	7	59	4438	1	wile
abele	7	63	2325	2	abele
abide	8	62	2372	2	abide
able	6	63	4053	2	able
agile	6	51	2226	2	agile
aide	5	60	4501	2	aide
ail	3	71	7105	2	ail_
ailed	6	62	4028	2	ailed
ails	4	56	5472	2	ails
aisle	5	52	2319	2	aisle
ale	3	65	7234	2	_ale
anile	5	46	3446	2	anile
axile	12	60	2051	2	axile
axle	11	64	2460	2	axle
babe	8	68	3582	2	babe
bade	7	51	4089	2	bade
bail	6	50	4280	2	bail_
bailed	9	47	2665	2	bailed
bailee	8	45	2601	2	bailee
bailer	8	54	2525	2	bailer
bailey	11	50	1567	2	bailey
bailie	8	38	1836	2	bailie
bails	7	59	3352	2	bails
baize	16	47	1739	2	baize
bake	10	56	3751	2	bake
bal	5	66	6272	2	bal_
bald	7	64	3290	2	bald
baled	8	54	3644	2	baled
baler	7	56	3528	2	baler
bales	7	62	5008	2	bales
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
be	4	79	4894	2	b__e
bee	5	62	6240	2	b_ee
beige	8	15	1538	2	beige
bel	5	71	4846	2	bel_
belie	7	56	3038	2	belie
bell	6	62	3718	2	bell
belle	7	58	2783	2	belle
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bene	6	64	3949	2	bene
bi	4	80	4648	2	bi__
biali	7	34	1907	2	biali
bialy	10	51	1932	2	bialy
bias	6	47	3817	2	bias
bib	7	70	4595	2	bi_b
bibb	7	58	1922	2	bibb
bibles	10	46	1764	2	bibles
bibs	8	48	3100	2	bibs
bicep	11	54	1354	2	bicep
bices	9	50	2996	2	bices
bid	6	77	5182	2	bi_d
bided	9	54	2497	2	bided
bider	8	57	2838	2	bider
bides	8	55	3678	2	bides
bidet	8	49	3563	2	bidet
bidi	7	82	2660	2	bidi
bids	7	58	3846	2	bids
bield	8	46	1465	2	bield
bier	6	55	3184	2	bier
biff	12	50	2690	2	biff
biflex	18	3	495	2	biflex
big	6	73	4573	2	bi_g
bigly	11	48	1475	2	bigly
bigs	7	62	3503	2	bigs
biked	12	53	2003	2	biked
biker	11	60	2256	2	biker
bikes	11	75	2947	2	bikes
bikie	11	39	1588	2	bikie
bilbo	9	55	1361	2	bilbo
bilby	12	49	1235	2	bilby
bilged	10	55	1318	2	bilged
bilges	9	49	1563	2	bilges
bilgy	11	47	1371	2	bilgy
bilked	13	40	1294	2	bilked
bilker	12	49	1344	2	bilker
bilks	11	51	1789	2	bilks
billed	9	42	2490	2	billed
biller	8	49	2348	2	biller
billet	8	60	2972	2	billet
billie	8	50	1917	2	billie
bills	7	56	3286	2	bills
billy	10	55	2536	2	billy
bima	8	67	2384	2	bima
bin	5	66	5865	2	bi_n
bind	7	62	3452	2	bind
bindle	9	45	1626	2	bindle
biner	7	59	3069	2	biner
bines	7	69	4679	2	bines
binge	8	51	2551	2	binge
bins	6	65	4826	2	bins
bint	6	73	5505	2	bint
bio	5	78	4609	2	bi_o
biog	7	61	2233	2	biog
biome	9	49	1699	2	biome
bios	6	63	3533	2	bios
biped	10	47	1883	2	biped
bird	7	61	2833	2	bird
birk	10	63	2687	2	birk
birl	6	58	3048	2	birl
birled	9	44	1699	2	birled
birler	8	57	1508	2	birler
birles	8	49	2064	2	birles
birls	7	40	2316	2	birls
biro	6	61	3122	2	biro
birr	6	60	2237	2	birr
birse	7	45	1740	2	birse
bis	5	68	6067	2	bi_s
bises	7	54	3562	2	bises
bisk	10	65	2336	2	bisk
bit	5	70	7091	2	bi_t
biter	7	50	3003	2	biter
bites	7	56	4117	2	bites
bits	6	61	4817	2	bits
bitt	6	55	4582	2	bitt
biz	14	79	3937	2	bi_z
bizes	16	59	2366	2	bizes
blae	6	61	3464	2	blae
bleb	8	54	2522	2	b_leb
bled	7	57	2931	2	b_led
blet	6	62	4767	2	b_let
blew	9	47	2243	2	b_lew
blin	6	72	2817	2	blin
blip	8	83	2277	2	blip
blite	7	62	2535	2	blite
blue	6	53	2846	2	blue
bode	7	58	3876	2	bode
bogle	8	58	2168	2	bogle
boil	6	63	3518	2	boil_
boiled	9	50	2095	2	boiled
boiler	8	43	1927	2	boiler
boils	7	54	2719	2	boils
boite	7	44	2632	2	boite
bola	6	60	3556	2	bola
bold	7	54	3281	2	bold
boles	7	54	4860	2	boles
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
boule	7	48	2804	2	boule
brae	6	56	3911	2	brae
bree	6	72	4126	2	bree
bribe	9	48	2078	2	bribe
bride	8	64	2554	2	bride
bridle	9	41	1546	2	bridle
brie	6	58	3790	2	brie
brill	7	48	1995	2	brill
brine	7	51	3227	2	brine
bugle	8	47	2194	2	bugle
build	8	44	1335	2	build
built	7	43	2592	2	built
bulb	8	56	2669	2	bulb
bulge	8	64	1987	2	bulge
bulk	10	54	2615	2	bulk
bull	6	56	3487	2	bull
bute	6	67	3967	2	bute
butle	7	50	2310	2	butle
bye	8	61	3459	2	b_ye
byre	9	50	2385	2	byre
byte	9	65	2181	2	byte
chile	10	56	2689	2	chile
cine	6	62	4295	2	cine
cire	6	58	3638	2	cire
cite	6	56	4035	2	cite
cole	6	69	5611	2	cole
dale	5	56	4398	2	dale
dele	5	68	4308	2	dele
dice	7	58	4190	2	dice
die	4	67	5966	2	di_e
diel	5	90	3461	2	diel
dike	9	59	3577	2	dike
dill	5	52	3998	2	dill
dime	7	62	3765	2	dime
dine	5	55	5534	2	dine
dire	5	66	4415	2	dire
dite	5	55	4756	2	dite
dive	8	56	3478	2	dive
dole	5	65	5000	2	dole
edile	6	48	1949	2	edile
eide	5	58	3225	2	eide
exile	12	61	1765	2	exile
fice	9	57	3712	2	fice
fie	6	71	5245	2	fi_e
fife	10	60	2771	2	fife
fil	6	54	4715	2	fil_
fila	7	47	2914	2	fila
filed	9	53	3190	2	filed
filer	8	54	3300	2	filer
files	8	54	4127	2	files
filet	8	55	4016	2	filet
fill	7	55	4020	2	fill
fille	8	43	2740	2	fille
film	9	48	2818	2	film
filo	7	60	3429	2	filo
fils	7	58	3870	2	fils
fine	7	51	4796	2	fine
fire	7	62	4560	2	fire
five	10	76	2975	2	five
gale	5	63	4732	2	gale
gibe	7	59	2779	2	gibe
gie	4	71	4955	2	gi_e
gild	6	55	2652	2	gild
gill	5	63	3619	2	gill
gilt	5	63	4855	2	gilt
gite	5	54	3862	2	gite
give	8	58	2936	2	give
guile	6	45	2113	2	guile
habile	11	5	1521	2	habile
hale	7	60	5283	2	hale
hide	8	51	3465	2	hide
hie	6	76	5271	2	hi_e
hike	11	68	3040	2	hike
hila	7	62	2836	2	hila
hili	7	56	2664	2	hili
hill	7	64	3950	2	hill
hilt	7	58	5072	2	hilt
hire	7	55	3897	2	hire
hive	10	60	2968	2	hive
hole	7	75	5339	2	hole
ice	5	67	3725	2	_ice
idle	5	54	2377	2	idle
ilea	4	59	3146	2	_ilea
ilex	11	58	2203	2	_ilex
ilk	7	83	2531	2	_ilk
ill	3	74	3710	2	_ill
ire	3	69	4318	2	_ire
isle	4	51	2170	2	isle
jibe	13	63	2340	2	jibe
jill	11	64	3027	2	jill
jilt	11	58	3943	2	jilt
jive	14	61	2360	2	jive
jole	11	72	3382	2	jole
jubile	15	29	1026	2	jubile
kale	8	65	3376	2	kale
kibe	10	65	2346	2	kibe
kike	7	65	2480	2	kike
kill	8	55	3319	2	kill
kiln	8	56	2099	2	kiln
kilo	8	60	2868	2	kilo
kilt	8	61	4443	2	kilt
kine	8	56	4344	2	kine
kite	8	53	3825	2	kite
labile	8	3	1522	2	labile
lice	6	60	4507	2	lice
lie	3	82	6453	2	li_e
life	7	54	3374	2	life
like	8	60	4085	2	like
lilo	4	67	3157	2	lilo
lilt	4	63	4995	2	lilt
lily	7	67	3019	2	lily
lime	6	62	4494	2	lime
line	4	69	6558	2	line
lipe	6	68	3974	2	lipe
lire	4	78	4530	2	lire
lisle	5	39	1672	2	lisle
lite	4	70	5455	2	lite
live	7	65	4100	2	live
maile	7	52	3222	2	maile
male	6	60	5230	2	male
mice	8	74	4224	2	mice
mike	10	55	3530	2	mike
mil	5	57	5212	2	mil_
mild	7	53	3086	2	mild
miler	7	57	3306	2	miler
miles	7	46	4507	2	miles
milk	10	50	2848	2	milk
mill	6	65	4149	2	mill
mille	7	50	2913	2	mille
milo	6	55	3611	2	milo
mils	6	60	4534	2	mils
milt	6	54	5582	2	milt
mime	8	57	3641	2	mime
mine	6	72	5618	2	mine
mire	6	67	4824	2	mire
mise	6	60	4359	2	mise
mite	6	62	4942	2	mite
mobile	10	36	1354	2	mobile
mole	6	62	5183	2	mole
mule	6	52	3697	2	mule
nice	6	55	3472	2	nice
nide	5	55	3580	2	nide
nil	3	61	4420	2	nil_
nill	4	56	3431	2	nill
nils	4	61	3246	2	nils
nine	4	58	4218	2	nine
nite	4	59	4359	2	nite
nixe	11	57	2203	2	nixe
nubile	8	32	1271	2	nubile
obole	7	59	1714	2	obole
ogle	5	63	2505	2	ogle
oil	3	74	5206	2	oil_
oiled	6	44	2947	2	oiled
oiler	5	46	2828	2	oiler
oils	4	63	3798	2	oils
oily	7	79	3226	2	oily
ole	3	71	5521	2	_ole
orle	4	56	3046	2	orle
pale	6	60	5501	2	pale
pele	6	55	3955	2	pele
pice	8	46	4110	2	pice
pie	5	54	5741	2	pi_e
pike	10	63	3522	2	pike
pilea	7	51	2395	2	pilea
piled	8	52	3299	2	piled
pilei	7	40	2178	2	pilei
piles	7	47	4261	2	piles
pili	6	61	3036	2	pili
pill	6	53	3947	2	pill
pily	9	61	3274	2	pily
pine	6	77	5572	2	pine
pipe	8	64	3444	2	pipe
plie	6	51	2739	2	plie
pole	6	59	5130	2	pole
pule	6	50	4095	2	pule
rale	4	50	5056	2	rale
rice	6	49	4292	2	rice
ride	5	59	4514	2	ride
riel	4	64	3239	2	riel
rife	7	46	3233	2	rife
rifle	8	55	1833	2	rifle
riled	6	58	3325	2	riled
riles	5	53	4364	2	riles
riley	8	44	2058	2	riley
rill	4	51	4091	2	rill
rille	5	57	2873	2	rille
rime	6	51	3889	2	rime
ripe	6	60	3893	2	ripe
rise	4	59	4524	2	rise
rite	4	58	4946	2	rite
rive	7	55	3773	2	rive
role	4	58	5182	2	role
rule	4	99	3842	2	rule
sale	4	49	5970	2	sale
sice	6	55	4560	2	sice
side	5	54	4450	2	side
sidle	6	51	2404	2	sidle
sike	8	71	3879	2	sike
sild	5	50	3059	2	sild
silex	12	34	1741	2	silex
silk	8	55	2933	2	silk
sill	4	55	4516	2	sill
silo	4	60	3792	2	silo
silt	4	65	5820	2	silt
sine	4	65	6063	2	sine
sipe	6	73	4105	2	sipe
sire	4	61	5042	2	sire
site	4	70	5242	2	site
size	13	56	3097	2	size
smile	7	48	2392	2	smile
sole	4	60	5367	2	sole
spile	7	52	3008	2	spile
stile	5	49	3157	2	stile
tale	4	61	5416	2	tale
tele	4	50	4087	2	tele
tide	5	52	3739	2	tide
tie	3	65	5754	2	ti_e
tike	8	55	3449	2	tike
til	3	63	5027	2	til_
tilde	6	50	1735	2	tilde
tiled	6	48	3294	2	tiled
tiler	5	61	3102	2	tiler
tiles	5	55	4210	2	tiles
till	4	59	4121	2	till
tils	4	57	3962	2	tils
tilt	4	62	5243	2	tilt
time	6	62	3502	2	time
tine	4	58	5514	2	tine
tire	4	61	4336	2	tire
title	5	47	2107	2	title
toile	5	46	2649	2	toile
tole	4	60	5290	2	tole
tule	4	57	3587	2	tule
utile	5	47	1893	2	utile
vale	7	49	3734	2	vale
vibe	9	51	2451	2	vibe
vice	9	57	3286	2	vice
vide	8	54	3277	2	vide
vie	6	54	4764	2	vi_e
viler	8	63	2416	2	viler
vill	7	52	3508	2	vill
vine	7	56	4369	2	vine
vise	7	56	3268	2	vise
vive	10	54	2663	2	vive
voile	8	47	1972	2	voile
vole	7	52	3698	2	vole
wale	7	45	4644	2	wale
while	11	54	1869	2	while
wide	8	52	3542	2	wide
wife	10	52	2803	2	wife
wild	8	51	2652	2	wild
wiled	9	52	3155	2	wiled
wiles	8	54	3787	2	wiles
will	7	57	3752	2	will
wilt	7	62	4630	2	wilt
wily	10	64	2882	2	wily
wine	7	49	5343	2	wine
wipe	9	48	3029	2	wipe
wire	7	58	3982	2	wire
wise	7	57	3735	2	wise
wite	7	54	4328	2	wite
wive	10	59	3176	2	wive
wyle	10	55	1938	2	wyle
yill	7	56	2898	2	yill
yipe	9	67	2219	2	yipe
yule	7	57	2514	2	yule
zill	13	57	2762	2	zill
zine	13	70	3616	2	zine

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	29872	0.280	638182.1
2	DLD Change Limit	29872	438	0.860	34734.9
3	Display Results	438	438	0.110	3981.8
	(SQL Overall)	178691	438	1.250	142952.8