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

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

307 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
bilayer	12	34	780	(None)
belayer	12	33	950	1	belayer
bilayers	13	29	691	1	bilayers
allayer	10	14	821	2	allayer
belayed	13	36	1008	2	belayed
belayers	13	29	814	2	belayers
bilander	11	3	667	2	bilander
bilgier	10	35	853	2	bilgier
bilker	12	49	1344	2	bil_ker
biller	8	49	2348	2	bil_ler
blader	9	36	1858	2	b_lader
blamer	10	44	1714	2	b_lamer
blazer	17	44	1402	2	b_lazer
brayer	11	53	1531	2	b_rayer
delayer	11	30	1053	2	delayer
dilater	8	35	1564	2	dilater
flayer	12	47	1356	2	_flayer
inlayer	10	3	693	2	inlayer
layer	8	46	2647	2	__layer
mislayer	13	3	750	2	mislayer
player	11	52	1521	2	_player
slayer	9	39	1633	2	_slayer
vilayet	13	4	853	2	vilayet
allayed	11	13	806	3	allayed
allayers	11	15	663	3	allayers
arrayer	10	13	670	3	arrayer
assayer	10	3	557	3	assayer
bailer	8	54	2525	3	bail__er
baker	11	56	2954	3	b__aker
balancer	12	4	660	3	balancer
balases	9	38	1543	3	balases
balder	9	53	1886	3	bal_der
baler	7	56	3527	3	b__aler
balker	12	45	1916	3	bal_ker
balkier	13	41	1198	3	balkier
baller	8	38	2520	3	bal_ler
balmier	11	38	1151	3	balmier
barer	7	45	3580	3	b__arer
baser	7	48	2892	3	b__aser
bayed	11	54	2302	3	b__ayed
beader	9	46	2379	3	b_eader
beaker	12	55	2069	3	b_eaker
bearer	8	53	2391	3	b_earer
beater	8	47	2939	3	b_eater
beaver	11	48	1925	3	b_eaver
behaver	15	20	672	3	behaver
belabor	11	3	629	3	belabor
belaced	12	41	1215	3	belaced
belated	10	35	2001	3	belated
belay	10	50	2152	3	belay__
belays	11	43	1385	3	belay_s
belcher	14	35	1149	3	belcher
belier	8	44	2356	3	bel_ier
belter	8	47	2096	3	bel_ter
betrayer	13	4	564	3	betrayer
bewrayer	16	4	373	3	bewrayer
bialies	9	36	1841	3	bialies
bialy	10	51	1932	3	bialy__
bialys	11	38	791	3	bialy_s
biased	9	40	1222	3	bi_ased
biases	8	46	1843	3	bi_ases
bibber	9	46	1357	3	bi_bber
bicker	14	48	1917	3	bi_cker
bidder	10	41	1486	3	bi_dder
bider	8	57	2837	3	bi__der
bier	6	55	3183	3	bi___er
biface	13	5	810	3	biface_
bifaces	14	4	806	3	bifaces
bigeye	12	3	664	3	bigeye_
bigeyes	13	3	565	3	bigeyes
bigger	10	43	1506	3	bi_gger
biker	11	60	2256	3	bi__ker
bilanders	12	3	596	3	bilanders
bilateral	11	4	497	3	bilateral
bilbies	11	47	1234	3	bilbies
bilboes	11	44	1023	3	bilboes
bilby	12	49	1235	3	bilby__
bile	6	61	4718	3	bil__e_
biles	7	55	4214	3	bil__es
bilevel	12	4	439	3	bilevel
bilge	8	76	1891	3	bil_ge_
bilged	10	55	1318	3	bil_ged
bilges	9	49	1563	3	bil_ges
bilgy	11	47	1371	3	bilgy__
bilinear	10	4	404	3	bilinear
bilked	13	40	1294	3	bil_ked
bilkers	13	47	1186	3	bil_kers
billed	9	42	2490	3	bil_led
billers	9	47	2082	3	bil_lers
billet	8	60	2972	3	bil_let
billeter	10	3	756	3	billeter
billie	8	50	1917	3	billie_
billies	9	39	2350	3	billies
billy	10	55	2536	3	billy__
bilobed	12	3	591	3	bilobed
bilsted	10	3	803	3	bilsted
binate	8	4	1977	3	binate_
binder	9	44	2287	3	bi_nder
biner	7	59	3069	3	bi__ner
binger	9	49	2345	3	bi_nger
biplane	11	3	903	3	biplane_
biplanes	12	3	856	3	biplanes
birder	9	49	1549	3	bi_rder
birler	8	57	1508	3	bi_rler
bister	8	49	2276	3	bi_ster
biter	7	50	3003	3	bi__ter
bitsier	9	37	907	3	bitsier
bitter	8	46	2267	3	bi_tter
bittier	9	42	1166	3	bittier
bizarre	18	4	410	3	bizarre
blabber	10	41	892	3	b_labber
blacker	15	45	1351	3	b_lacker
bladder	11	42	915	3	b_ladder
blade	8	59	2333	3	b_lade_
bladed	10	47	1776	3	b_laded
bladers	10	42	1468	3	b_laders
blades	9	52	2125	3	b_lades
blae	6	61	3464	3	b_la_e_
blame	9	56	2549	3	b_lame_
blamed	11	60	1795	3	b_lamed
blamers	11	53	1421	3	b_lamers
blames	10	51	2186	3	b_lames
blander	10	37	1516	3	b_lander
blanker	13	46	1202	3	b_lanker
blare	7	58	2623	3	b_lare_
blared	9	50	1824	3	b_lared
blares	8	50	2163	3	b_lares
blase	7	55	2423	3	b_lase_
blaster	9	40	1730	3	b_laster
blate	7	59	3378	3	b_late_
blather	12	53	1420	3	b_lather
blatter	9	44	1565	3	b_latter
blawed	12	47	1389	3	b_lawed
blaze	16	55	2083	3	b_laze_
blazed	18	43	1471	3	b_lazed
blazers	18	48	1168	3	b_lazers
blazes	17	48	1735	3	b_lazes
bleaker	13	35	1053	3	bleaker
bleater	9	45	1530	3	bleater
blinder	10	39	1298	3	blinder
blinker	13	41	1021	3	blinker
blister	9	44	1531	3	blister
blither	12	48	1217	3	blither
blitzer	18	44	766	3	blitzer
bloater	9	40	1342	3	bloater
blower	11	53	1657	3	b_lower
bluer	7	49	1849	3	b_l_uer
boater	8	46	2209	3	b_oater
boiler	8	43	1927	3	boil__er
boilover	13	4	402	3	boilover
bolar	7	51	2347	3	bola__r
bolases	9	33	1500	3	bolases
bolder	9	48	2093	3	bol_der
bolster	9	37	1342	3	bolster
bolter	8	39	2075	3	bol_ter
boneyer	12	3	740	3	boneyer
bowyer	14	36	892	3	b_owyer
bracer	10	46	2058	3	b_racer
braver	11	47	1904	3	b_raver
brawer	11	42	1633	3	b_rawer
brayed	12	46	1578	3	b_rayed
brayers	12	45	1190	3	b_rayers
brazer	17	49	1753	3	b_razer
breaker	13	39	1292	3	breaker
bricklayer	21	5	172	3	bricklayer
broader	10	34	1260	3	broader
builder	10	3	757	3	buil_der
bulger	9	49	1735	3	bul_ger
bulgier	10	39	1121	3	bulgier
bulkier	13	41	1151	3	bulkier
bullier	9	41	1643	3	bullier
buyer	10	50	1309	3	b__uyer
byliner	12	3	572	3	byliner
caloyer	12	3	814	3	caloyer
claver	11	38	1697	3	_claver
clawer	11	45	1278	3	_clawer
clayed	12	50	1304	3	_clayed
clayey	14	40	766	3	_clayey
clayier	12	4	832	3	_clayier
decayer	13	33	935	3	decayer
delayed	12	33	1076	3	delayed
delayers	12	26	866	3	delayers
dialer	7	43	1543	3	di_aler
dialler	8	4	881	3	dialler
dialyser	12	4	369	3	dialyser
dialyzer	21	4	311	3	dialyzer
diaper	9	45	1311	3	di_aper
dilate	7	32	2069	3	dilate_
dilated	9	31	1582	3	dilated
dilaters	9	25	1305	3	dilaters
dilates	8	32	2065	3	dilates
dilator	8	27	1278	3	dilator
diluter	8	31	965	3	diluter
displayer	15	4	583	3	displayer
elater	6	47	2420	3	_elater
essayer	10	3	394	3	essayer
filar	8	48	1929	3	fila__r
filaree	10	6	1119	3	filaree
filcher	15	37	779	3	filcher
filer	8	54	3300	3	fil__er
filler	9	46	2362	3	fil_ler
filmer	11	41	1240	3	fil_mer
filmier	12	3	750	3	filmier
filter	9	45	1763	3	fil_ter
flaker	13	49	1617	3	_flaker
flamer	11	49	1912	3	_flamer
flayed	13	44	1405	3	_flayed
flayers	13	39	1203	3	_flayers
flyer	11	49	1625	3	_fl_yer
forayer	13	36	895	3	forayer
gayer	9	45	1919	3	__gayer
gilder	8	44	1553	3	gil_der
giller	7	45	1973	3	gil_ler
glazer	16	42	1226	3	_glazer
grayer	10	60	1454	3	_grayer
hayer	11	46	2024	3	__hayer
hilar	8	54	1814	3	hila__r
hiller	9	44	2163	3	hil_ler
hillier	10	34	1396	3	hillier
iller	5	48	2129	3	_il_ler
imager	9	10	812	3	_imager
inaner	6	22	1354	3	_inaner
inlayers	11	3	563	3	inlayers
irater	6	52	1834	3	_irater
jilter	13	35	1251	3	jil_ter
killer	10	49	1795	3	kil_ler
kilter	10	37	1434	3	kil_ter
lacer	7	58	3375	3	__lacer
lader	6	56	3372	3	__lader
lager	6	51	3286	3	__lager
laker	9	54	3287	3	__laker
lamer	7	52	3370	3	__lamer
laser	5	46	3332	3	__laser
later	5	48	4392	3	__later
laver	8	50	3179	3	__laver
lawyer	12	38	697	3	__lawyer
laxer	12	54	2033	3	__laxer
layed	9	51	2738	3	__layed
layers	9	39	2118	3	__layers
livyer	12	42	629	3	li_vyer
milage	9	34	1412	3	milage_
milages	10	31	1440	3	milages
milder	9	38	1845	3	mil_der
miler	7	57	3306	3	mil__er
milker	12	48	1432	3	mil_ker
milkier	13	34	1116	3	milkier
miller	8	46	2541	3	mil_ler
millier	9	37	1670	3	millier
milter	8	49	2123	3	mil_ter
miltier	9	32	1496	3	miltier
minelayer	14	5	350	3	minelayer
misaver	12	4	981	3	misaver
mislayers	14	4	593	3	mislayers
oiler	5	46	2828	3	oil__er
oilier	6	44	1723	3	oil_ier
oilpaper	12	4	285	3	oilpaper
palaver	12	3	875	3	palaver
payer	10	51	2572	3	__payer
pilar	7	52	2150	3	pila__r
pilaster	10	3	816	3	pilaster
pilfer	11	3	916	3	pil_fer
pillager	11	27	854	3	pillager
pilsner	9	3	534	3	pilsner
placer	10	51	1774	3	_placer
planer	8	41	2265	3	_planer
plater	8	44	2769	3	_plater
played	12	48	1503	3	_played
players	12	43	1376	3	_players
plyer	10	62	1433	3	_pl_yer
prayer	11	48	1529	3	_prayer
relater	7	37	2314	3	relater
relaxer	14	34	1022	3	relaxer
relayed	11	32	1275	3	relayed
sayer	8	49	2655	3	__sayer
silage	7	27	1530	3	silage_
silages	8	25	1444	3	silages
silane	6	27	1805	3	silane_
silanes	7	25	1716	3	silanes
silkier	11	44	1164	3	silkier
siller	6	40	2605	3	sil_ler
sillier	7	40	1758	3	sillier
siltier	7	34	1386	3	siltier
silver	9	38	1581	3	sil_ver
slaker	10	42	1927	3	_slaker
slater	6	44	2918	3	_slater
slaver	9	44	1961	3	_slaver
slayed	10	47	1622	3	_slayed
slayers	10	45	1332	3	_slayers
slyer	8	55	1512	3	_sl_yer
solacer	9	30	1110	3	solacer
splayed	13	35	781	3	splayed
sprayer	12	36	904	3	sprayer
stayer	9	45	1648	3	_stayer
strayer	10	43	1249	3	strayer
swayer	12	52	1097	3	_swayer
tiler	5	61	3102	3	til__er
tiller	6	42	2253	3	til_ler
tilter	6	34	1769	3	til_ter
vilayets	14	4	307	3	vilayets
viler	8	63	2416	3	vil__er
villager	12	26	750	3	villager
violater	11	3	724	3	violater
vitamer	12	3	547	3	vitamer
waylayer	17	4	315	3	waylayer
wilder	10	36	1647	3	wil_der
wilier	9	32	1707	3	wil_ier
willer	9	40	2106	3	wil_ler

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.156	1145455.1
2	DLD Change Limit	134027	307	7.593	17651.4
3	Display Results	307	307	0.093	3301.1
	(SQL Overall)	178691	307	7.842	22786.4