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

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

395 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
glairy	10	44	827	(None)
glair	6	53	1355	1	glair_
glaire	7	44	1130	1	glaire
glairs	7	52	1133	1	glairs
glary	9	60	1854	1	gla_ry
airy	7	57	3415	2	__airy
alary	8	61	2344	2	ala_ry
clary	10	57	1961	2	cla_ry
dairy	9	70	1630	2	_dairy
fairy	11	53	1828	2	_fairy
flair	8	61	1412	2	flair_
flairs	9	57	1191	2	flairs
gaily	9	50	2097	2	g_aily
gharry	13	54	627	2	gharry
gladly	11	49	793	2	gladly
glady	10	54	1394	2	gla_dy
glaired	9	38	775	2	glaired
glaires	8	40	1014	2	glaires
glaive	10	35	793	2	glaive
glare	6	52	2296	2	gla_re
glassy	10	52	775	2	glassy
glaziery	21	41	369	2	glaziery
glazily	20	3	538	2	glazily
glazy	18	74	1098	2	gla_zy
glory	9	64	1329	2	gl_ory
gluily	10	30	829	2	gluily
grainy	10	39	1421	2	grainy
hairy	11	53	1683	2	_hairy
lair	4	59	3415	2	_lair_
laird	6	54	1779	2	_laird
lairs	5	54	2587	2	_lairs
laity	8	53	1890	2	_laity
aery	7	72	3168	3	__aery
aglare	7	3	1243	3	agla_re
air	3	80	5839	3	__air_
airn	4	64	3383	3	__airn
airs	4	64	4742	3	__airs
airt	4	57	5778	3	__airt
alar	4	63	4007	3	ala_r_
alarm	7	66	2142	3	ala_rm
apiary	11	39	1038	3	apiary
ariary	9	41	1420	3	ariary
aviary	12	33	841	3	aviary
awry	10	76	1968	3	__awry
bairn	7	75	1553	3	_bairn
biliary	12	3	821	3	biliary
blabby	12	3	481	3	blabby
blain	7	54	2179	3	blai_n
blains	8	45	1637	3	blains
blare	7	58	2623	3	bla_re
blasty	11	56	1105	3	blasty
bleary	11	51	1255	3	bleary
blimy	12	52	1282	3	bl_imy
blurry	11	43	767	3	blurry
brainy	11	48	1564	3	brainy
briary	11	49	1200	3	briary
caird	8	57	1723	3	_caird
cairn	7	57	1751	3	_cairn
cairny	11	55	782	3	_cairny
calory	11	3	1284	3	calory
carry	10	58	2378	3	_carry
chair	10	55	1963	3	chair_
chairs	11	49	1618	3	chairs
charry	14	50	1211	3	charry
chary	13	50	2313	3	cha_ry
ciliary	12	4	792	3	ciliary
claim	9	56	1691	3	clai_m
claims	10	52	1157	3	claims
clammy	15	35	633	3	clammy
clanky	15	46	907	3	clanky
clarify	15	3	609	3	clarify
clarity	12	3	1091	3	clarity
claro	7	50	1869	3	cla_ro
classy	11	37	904	3	classy
clay	9	59	2741	3	cla__y
clayey	14	40	766	3	clayey
daily	9	59	2233	3	_daily
daisy	9	59	1531	3	_daisy
deair	6	58	1719	3	deair_
deairs	7	40	1378	3	deairs
deary	9	58	2684	3	dea_ry
diary	9	50	1697	3	dia_ry
eclair	8	3	681	3	eclair_
eclairs	9	3	596	3	eclairs
elain	5	53	2470	3	elai_n
elains	6	49	1985	3	elains
expiry	18	3	465	3	expiry
faery	11	60	1548	3	_faery
fair	7	63	3252	3	_fair_
fairly	12	56	1001	3	_fairly
fairs	8	58	2544	3	_fairs
flabby	16	3	457	3	flabby
flaggy	14	41	592	3	flaggy
flail	8	53	1618	3	flai_l
flails	9	43	1300	3	flails
flakey	16	44	1051	3	flakey
flakily	17	3	629	3	flakily
flaky	15	57	1558	3	fla_ky
flamy	13	52	1747	3	fla_my
flappy	16	5	448	3	flappy
flare	8	48	2363	3	fla_re
flashy	15	49	817	3	flashy
flatly	12	31	1021	3	flatly
flavory	16	4	474	3	flavory
flawy	14	59	1338	3	fla_wy
flaxy	18	90	1229	3	fla_xy
flay	10	63	3280	3	fla__y
fleury	12	41	735	3	fleury
flir	7	64	2220	3	fl_ir_
flirs	8	55	1893	3	fl_irs
flirt	8	74	2475	3	fl_irt
flirty	12	49	914	3	fl_irty
floury	12	44	957	3	floury
flurry	12	39	711	3	flurry
friary	12	40	1009	3	friary
gabby	13	55	1295	3	g_abby
gaby	10	71	2319	3	g_a_by
gaiety	10	11	937	3	g_aiety
gain	5	60	4216	3	g_ai_n
gainly	10	4	932	3	g_ainly
gains	6	57	2951	3	g_ains
gait	5	61	5019	3	g_ai_t
gaits	6	57	2601	3	g_aits
galaxy	17	47	631	3	galaxy
galere	7	37	1668	3	galere
galiot	7	23	2259	3	galiot
gallery	11	46	874	3	gallery
galley	10	42	1545	3	galley
gally	9	50	2617	3	g_ally
galore	7	35	1487	3	galore
gamay	11	64	1911	3	g_amay
gamey	11	53	2055	3	g_amey
gamily	12	37	1218	3	gamily
gammy	13	55	1489	3	g_ammy
gamy	10	54	2753	3	g_a_my
gantry	10	38	1011	3	gantry
gappy	13	62	1203	3	g_appy
gapy	10	63	2091	3	g_a_py
gar	4	72	5990	3	g_a_r_
garb	7	53	3267	3	g_a_rb
gars	5	57	5074	3	g_a_rs
gasify	13	3	633	3	gasify
gassy	9	55	1402	3	g_assy
gaudy	10	66	1146	3	g_audy
gaur	5	67	2335	3	g_aur_
gaurs	6	63	1799	3	g_aurs
gauzy	18	48	921	3	g_auzy
gawky	16	56	999	3	g_awky
gawsy	12	45	909	3	g_awsy
gay	7	68	5649	3	g_a__y
gayly	12	45	1309	3	g_ayly
gear	5	59	3497	3	gea_r_
gears	6	46	2869	3	gea_rs
gentry	10	34	1044	3	gentry
gharri	10	38	616	3	gharri
gird	6	54	2499	3	g__ird
girl	5	62	2655	3	g__irl
girly	9	44	1529	3	g__irly
girn	5	60	2686	3	g__irn
giro	5	58	2863	3	g__iro
girt	5	66	4642	3	g__irt
glace	8	74	2016	3	gla_ce
glaces	9	42	1803	3	glaces
glacial	10	3	814	3	glacial
glacier	10	39	1130	3	glacier
glaciers	11	27	790	3	glaciers
glacis	9	40	1213	3	glacis
glad	6	56	2401	3	gla__d
glade	7	51	2196	3	gla_de
glades	8	48	2034	3	glades
gladier	9	38	1099	3	gladier
glads	7	56	2061	3	gla_ds
glaiket	12	3	836	3	glaiket
glaikit	12	4	463	3	glaikit
glairier	9	4	484	3	glairier
glairing	10	4	728	3	glairing
glaived	12	37	597	3	glaived
glaives	11	34	783	3	glaives
glam	7	65	2934	3	gla__m
glamor	9	5	819	3	glamor
glamors	10	6	812	3	glamors
glams	8	58	2293	3	gla_ms
glance	9	43	1231	3	glance
gland	7	52	1771	3	gla_nd
glands	8	53	1440	3	glands
glans	6	51	2583	3	gla_ns
glared	8	47	1520	3	glared
glares	7	55	1887	3	glares
glarier	8	41	1221	3	glarier
glaring	9	37	1488	3	glaring
glass	6	55	1813	3	gla_ss
glassily	12	3	546	3	glassily
glaze	15	54	1816	3	gla_ze
glazed	17	47	1177	3	glazed
glazer	16	42	1226	3	glazer
glazers	17	44	1004	3	glazers
glazes	16	53	1564	3	glazes
glazier	17	40	935	3	glazier
glaziers	18	40	656	3	glaziers
glazing	18	36	1100	3	glazing
gleamy	12	39	811	3	gleamy
gleety	10	47	919	3	gleety
glegly	11	3	487	3	glegly
gley	8	57	2465	3	gl__ey
glia	5	64	2315	3	gl_i_a
glial	6	67	1543	3	gl_ial
glias	6	46	1849	3	gl_ias
glib	7	94	2144	3	gl_i_b
glibly	12	3	629	3	glibly
glide	7	45	2159	3	gl_ide
gliff	12	49	1566	3	gl_iff
glim	7	60	2635	3	gl_i_m
glime	8	56	2019	3	gl_ime
glims	8	74	1767	3	gl_ims
glint	6	68	3018	3	gl_int
glinty	10	69	1069	3	glinty
glitz	15	49	1637	3	gl_itz
glitzy	19	40	478	3	glitzy
globby	14	3	468	3	globby
gloomy	12	52	876	3	gloomy
gloppy	14	5	472	3	gloppy
gloria	7	19	1055	3	gloria
glorify	14	4	458	3	glorify
glossy	10	54	900	3	glossy
gluer	6	51	1677	3	gluer_
gluers	7	50	1115	3	gluers
gluey	9	57	1526	3	gl_uey
gluier	7	3	1026	3	gluier
gluing	8	38	1205	3	gluing
glumly	12	35	662	3	glumly
glumpy	14	52	719	3	glumpy
gnar	5	60	2138	3	gna_r_
gnarl	6	51	1557	3	gna_rl
gnarly	10	46	1038	3	gnarly
gnarr	6	48	1069	3	gna_rr
gnarrs	7	40	766	3	gnarrs
gnars	6	67	1885	3	gna_rs
gnatty	10	33	648	3	gnatty
goliard	9	3	607	3	goliard
gorily	10	6	1250	3	gorily
gory	8	61	2966	3	g__ory
grabby	14	33	618	3	grabby
grail	6	46	2287	3	grai_l
grails	7	75	1878	3	grails
grain	6	51	2625	3	grai_n
grains	7	42	2309	3	grains
gramary	13	5	591	3	gramary
granary	11	5	779	3	granary
granny	10	43	1116	3	granny
grapery	13	45	795	3	grapery
grapey	12	60	1230	3	grapey
grapy	11	54	1643	3	gra_py
grassy	10	61	909	3	grassy
gratify	14	3	611	3	gratify
gravity	14	3	718	3	gravity
gravy	12	55	1211	3	gra_vy
gray	8	53	2989	3	gra__y
grayly	13	28	796	3	grayly
grimy	11	43	1260	3	g_rimy
gripy	11	51	1525	3	g_ripy
guaiac	9	4	615	3	guaiac
guanay	10	3	791	3	guanay
guar	5	69	2329	3	gua_r_
guard	7	44	1554	3	gua_rd
guars	6	50	2105	3	gua_rs
guiro	6	37	1209	3	g_uiro
gular	6	3	1483	3	gula_r_
gurry	9	45	1541	3	g_urry
hair	7	63	3014	3	_hair_
hairs	8	62	2517	3	_hairs
harry	11	53	2295	3	_harry
hoary	11	45	1676	3	hoa_ry
kaury	12	42	976	3	_kaury
knarry	13	3	461	3	knarry
laari	5	44	1571	3	_laari
labra	7	54	1546	3	_labra
lacey	10	58	2091	3	_lacey
lacily	11	6	1276	3	_lacily
lacy	9	58	2963	3	_la_cy
lady	8	65	2715	3	_la_dy
laic	6	59	3156	3	_lai_c
laich	10	59	2071	3	_laich
laics	7	64	1925	3	_laics
laid	5	64	3914	3	_lai_d
laigh	9	55	1592	3	_laigh
lain	4	61	4628	3	_lai_n
lairdly	11	3	491	3	_lairdly
lairds	7	47	1161	3	_lairds
laired	7	52	1681	3	_laired
laith	8	57	2210	3	_laith
laky	11	67	2582	3	_la_ky
lamby	12	51	1484	3	_lamby
laniary	10	6	801	3	_laniary
lanky	12	55	1748	3	_lanky
lar	3	79	6753	3	_la_r_
lard	5	67	4200	3	_la_rd
lardy	9	61	1927	3	_lardy
lari	4	58	3915	3	_la_ri
laris	5	47	3746	3	_laris
lark	8	57	3386	3	_la_rk
larky	12	52	1887	3	_larky
lars	4	69	5657	3	_la_rs
lathy	11	52	1506	3	_lathy
laura	5	41	1620	3	_laura
lawny	11	59	1201	3	_lawny
laxity	16	3	727	3	_laxity
laxly	15	6	1010	3	_laxly
lay	6	88	6535	3	_la__y
lazily	18	5	971	3	_lazily
lazy	16	64	2307	3	_la_zy
leary	8	59	2738	3	_leary
leery	8	59	1913	3	_leery
liar	4	72	2968	3	_liar_
liard	6	54	1859	3	_liard
liars	5	47	2316	3	_liars
lily	7	67	3018	3	_l_ily
limy	9	57	2771	3	_l_imy
liny	7	81	4132	3	_l_iny
lira	4	69	2868	3	_l_ira
lire	4	78	4529	3	_l_ire
liri	4	51	2825	3	_l_iri
lorry	8	63	1567	3	_lorry
lory	7	59	3171	3	_l_ory
loury	8	57	1675	3	_loury
mair	6	61	3378	3	_mair_
mairs	7	62	2830	3	_mairs
marry	10	48	2169	3	_marry
miliary	12	4	946	3	miliary
miry	9	63	2675	3	__miry
naira	5	3	1474	3	_naira
nairu	5	4	1381	3	_nairu
nary	7	69	3122	3	_na_ry
ovary	11	4	911	3	ova_ry
pair	6	60	3151	3	_pair_
pairs	7	53	2583	3	_pairs
paltry	11	49	1040	3	paltry
parry	10	53	2375	3	_parry
plagiary	14	4	364	3	plagiary
plaguy	12	38	641	3	plaguy
plaice	10	3	1155	3	plaice
plaid	8	51	1830	3	plai_d
plaids	9	43	1244	3	plaids
plain	7	48	2330	3	plai_n
plainly	12	3	647	3	plainly
plains	8	50	1959	3	plains
plaint	8	53	2320	3	plaint
plait	7	56	3157	3	plai_t
plaits	8	38	1647	3	plaits
plashy	14	44	887	3	plashy
platy	10	50	2166	3	pla_ty
play	9	59	2898	3	pla__y
ploidy	12	3	748	3	ploidy
quarry	18	3	747	3	quarry
rainy	8	59	2108	3	_rainy
salary	9	5	1521	3	salary
salify	12	3	1137	3	salify
saury	8	43	1722	3	_saury
scarry	11	63	1118	3	scarry
scary	10	52	2259	3	sca_ry
shaird	10	28	870	3	shaird
shairn	9	26	906	3	shairn
slaggy	11	43	879	3	slaggy
slain	5	49	2357	3	slai_n
slangy	10	54	1139	3	slangy
slanty	9	51	1484	3	slanty
slatey	9	54	1706	3	slatey
slaty	8	65	2315	3	sla_ty
slavery	13	40	789	3	slavery
slavey	12	40	1180	3	slavey
slay	7	64	3638	3	sla__y
slily	8	58	2003	3	sl_ily
slimy	10	54	1742	3	sl_imy
sluicy	11	6	648	3	sluicy
slurry	9	37	860	3	slurry
sparry	11	51	1130	3	sparry
spiry	10	50	1735	3	_spiry
stair	5	47	1994	3	stair_
stairs	6	54	1633	3	stairs
starry	9	49	1167	3	starry
tarry	8	54	2251	3	_tarry
teary	8	51	2405	3	tea_ry
thairm	11	5	696	3	thairm
uglify	13	3	391	3	ugl_ify
uglily	10	3	619	3	ugl_ily
unary	8	3	1599	3	una_ry
vair	7	56	2414	3	_vair_
vairs	8	50	1913	3	_vairs
vary	10	52	2606	3	_va_ry
wair	7	58	3005	3	_wair_
wairs	8	64	2406	3	_wairs
wary	10	67	4001	3	_wa_ry
weary	11	56	2061	3	wea_ry
wiry	10	64	2283	3	__wiry
yaird	9	61	1191	3	_yaird
zaire	14	3	1199	3	_zaire

Search took 6 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	112716	0.420	425454.8
2	DLD Change Limit	112716	395	5.236	21527.1
3	Display Results	395	395	0.123	3211.4
	(SQL Overall)	178691	395	5.779	30920.7