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

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

322 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
grabby	14	33	618	(None)
crabby	15	34	675	1	crabby
gabby	13	55	1295	1	g_abby
grubby	14	32	450	1	grubby
blabby	12	3	481	2	blabby
cabby	14	53	1456	2	_cabby
drably	12	35	1161	2	drably
flabby	16	3	457	2	flabby
gaby	10	71	2319	2	g_a_by
globby	14	3	468	2	globby
grab	7	54	2761	2	gra_b_
grabbed	13	36	864	2	grabbed
grabber	12	38	976	2	grabber
grabble	12	33	964	2	grabble
graben	9	41	972	2	graben
grabs	8	57	1969	2	gra_bs
grainy	10	39	1421	2	grainy
granny	10	43	1116	2	granny
grapey	12	60	1230	2	grapey
grapy	11	54	1643	2	gra_py
grassy	10	61	909	2	grassy
gravy	12	55	1211	2	gra_vy
gray	8	53	2989	2	gra__y
grayly	13	28	796	2	grayly
rabbi	9	31	1318	2	_rabbi
ribby	12	41	968	2	_ribby
rubby	12	44	1386	2	_rubby
scabby	15	3	550	2	scabby
shabby	16	3	580	2	shabby
swabby	16	3	435	2	swabby
tabby	12	52	1389	2	_tabby
yabby	15	38	975	2	_yabby
abba	8	105	2265	3	__abba
abbe	8	76	2719	3	__abbe
abbey	12	57	1493	3	__abbey
ably	9	97	2513	3	__ably
aby	8	102	3806	3	__a_by
arabic	10	3	1273	3	arabic
arable	8	18	2100	3	arable
baby	11	67	2368	3	_ba_by
blebby	12	3	374	3	blebby
bobby	11	48	1466	3	_bobby
brabble	10	34	997	3	brabble
braggy	13	33	717	3	braggy
brainy	11	48	1564	3	brainy
braky	14	50	1581	3	bra_ky
brambly	16	29	625	3	brambly
brandy	12	47	1206	3	brandy
branny	11	51	1183	3	branny
brashy	14	52	1059	3	brashy
brassy	11	50	923	3	brassy
bratty	11	5	968	3	bratty
brawly	14	43	1235	3	brawly
brawny	14	47	1060	3	brawny
braxy	17	54	1089	3	bra_xy
bray	9	52	3290	3	bra__y
brumby	15	38	595	3	brumby
bubby	11	50	1393	3	_bubby
carboy	13	49	1418	3	carboy
chubby	18	4	412	3	chubby
clubby	15	3	468	3	clubby
cobby	14	55	1641	3	_cobby
crab	8	57	2767	3	cra_b_
crabbed	14	38	887	3	crabbed
crabber	13	38	1073	3	crabber
crabbily	17	4	434	3	crabbily
crabs	9	54	2139	3	cra_bs
cracky	17	50	1022	3	cracky
crafty	14	47	891	3	crafty
craggy	13	39	660	3	craggy
crambe	12	3	907	3	crambe
crambo	12	3	804	3	crambo
crampy	15	47	1099	3	crampy
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
crappy	15	44	680	3	crappy
crawly	14	46	1076	3	crawly
crazy	19	55	1122	3	cra_zy
crumby	15	40	811	3	crumby
crybaby	19	4	193	3	crybaby
cubby	14	52	1212	3	_cubby
curably	14	20	1077	3	curably
dauby	11	52	1122	3	_dauby
dobby	13	60	1363	3	_dobby
drab	7	62	2645	3	dra_b_
drabbed	13	42	872	3	drabbed
drabber	12	43	859	3	drabber
drabbet	12	31	957	3	drabbet
drabble	12	23	888	3	drabble
drabs	8	51	1967	3	dra_bs
draffy	16	48	663	3	draffy
drafty	13	63	893	3	drafty
draggy	12	34	682	3	draggy
drapey	12	50	1058	3	drapey
drawly	13	49	1072	3	drawly
dray	8	54	2809	3	dra__y
dribbly	15	27	495	3	dribbly
durably	13	22	905	3	durably
fray	10	54	2890	3	fra__y
gab	6	71	5599	3	g_a_b_
gabbed	12	52	1689	3	g_abbed
gabber	11	49	1660	3	g_abber
gabble	11	38	1572	3	g_abble
gabbro	11	11	495	3	g_abbro
gable	8	53	2552	3	g_able
gabs	7	67	4042	3	g_a_bs
gaily	9	50	2097	3	g_aily
gally	9	50	2617	3	g_ally
gamay	11	64	1910	3	g_amay
gamb	9	63	3184	3	g_amb_
gamba	10	60	1851	3	g_amba
gambe	10	62	1921	3	g_ambe
gambs	10	57	2112	3	g_ambs
gamey	11	53	2055	3	g_amey
gammy	13	55	1489	3	g_ammy
gamy	10	54	2753	3	g_a_my
gappy	13	62	1203	3	g_appy
gapy	10	63	2091	3	g_a_py
garb	7	53	3267	3	g_arb_
garbagy	14	4	424	3	garbagy
garbed	10	48	1566	3	garbed
garble	9	41	1845	3	garble
garbs	8	63	2141	3	g_arbs
garvey	13	12	787	3	garvey
gassy	9	55	1402	3	g_assy
gaudy	10	66	1146	3	g_audy
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
gharry	13	54	627	3	gharry
gladly	11	49	793	3	gladly
glady	10	54	1394	3	gla_dy
glairy	10	44	827	3	glairy
glary	9	60	1854	3	gla_ry
glassy	10	52	775	3	glassy
glazy	18	74	1098	3	gla_zy
glibly	12	3	629	3	glibly
gnarly	10	46	1038	3	gnarly
gnatty	10	33	648	3	gnatty
goby	10	60	2108	3	g__oby
goodby	13	40	628	3	goodby
graal	6	43	1650	3	gra_al
graals	7	41	1291	3	graals
grabbers	13	33	788	3	grabbers
grabbier	13	31	665	3	grabbier
grabbing	14	26	731	3	grabbing
grabbled	14	32	737	3	grabbled
grabbler	13	37	769	3	grabbler
grabbles	13	33	989	3	grabbles
grabens	10	36	700	3	grabens
grace	8	51	2454	3	gra_ce
graced	10	52	1790	3	graced
graces	9	45	2349	3	graces
grad	6	68	2986	3	gra__d
grade	7	51	2609	3	gra_de
graded	9	49	1955	3	graded
grader	8	49	1969	3	grader
grades	8	49	2631	3	grades
gradin	8	35	1748	3	gradin
grads	7	56	2575	3	gra_ds
gradus	8	44	1121	3	gradus
graft	9	53	2720	3	gra_ft
grafts	10	50	1325	3	grafts
graham	12	3	785	3	graham
grail	6	46	2287	3	gra_il
grails	7	75	1878	3	grails
grain	6	51	2625	3	gra_in
grains	7	42	2309	3	grains
gram	7	70	3458	3	gra__m
grama	8	56	2028	3	gra_ma
gramary	13	5	590	3	gramary
gramas	9	43	1720	3	gramas
gramma	11	49	980	3	gramma
gramme	11	42	1033	3	gramme
gramp	10	62	1832	3	gra_mp
grampa	11	50	1017	3	grampa
gramps	11	41	1427	3	gramps
grams	8	53	2731	3	gra_ms
gran	5	63	3501	3	gra__n
grana	6	57	2209	3	gra_na
granary	11	5	779	3	granary
grand	7	51	2269	3	gra_nd
grandbaby	18	5	173	3	grandbaby
grandly	12	3	874	3	grandly
grands	8	42	1824	3	grands
grange	8	37	1620	3	grange
grans	6	48	3254	3	gra_ns
grant	6	48	4002	3	gra_nt
grants	7	37	2247	3	grants
granum	9	3	1091	3	granum
grape	8	48	2466	3	gra_pe
grapery	13	45	795	3	grapery
grapes	9	51	2312	3	grapes
graph	11	53	1561	3	gra_ph
graphs	12	45	1015	3	graphs
grappa	11	39	644	3	grappa
grasp	8	48	1448	3	gra_sp
grasps	9	48	925	3	grasps
grass	6	61	2520	3	gra_ss
grat	5	56	5128	3	gra__t
grate	6	49	3288	3	gra_te
grated	8	45	2392	3	grated
grater	7	46	2543	3	grater
grates	7	54	2988	3	grates
gratify	14	3	611	3	gratify
gratin	7	45	2058	3	gratin
gratis	7	48	1924	3	gratis
grave	9	46	2487	3	gra_ve
graved	11	48	1881	3	graved
gravel	10	53	1382	3	gravel
gravely	14	46	906	3	gravely
graven	10	45	1352	3	graven
graver	10	50	1859	3	graver
graves	10	46	2400	3	graves
gravid	11	37	1097	3	gravid
gravity	14	3	718	3	gravity
grayed	11	54	1564	3	grayed
grayer	10	60	1454	3	grayer
grays	9	56	2133	3	gra_ys
graze	15	58	2005	3	gra_ze
grazed	17	41	1591	3	grazed
grazer	16	48	1576	3	grazer
grazes	16	45	1964	3	grazes
greasy	10	41	946	3	greasy
greatly	11	3	761	3	greatly
grebe	8	51	1494	3	gr_ebe
grebes	9	38	1361	3	grebes
greedy	11	51	884	3	greedy
greeny	10	48	1145	3	greeny
gremmy	14	5	447	3	gremmy
grey	8	56	2404	3	gr__ey
greyly	13	31	654	3	greyly
gribble	12	29	727	3	gribble
grimly	12	45	993	3	grimly
grimy	11	43	1260	3	gr_imy
gripey	12	41	1120	3	gripey
grippy	14	44	776	3	grippy
gripy	11	51	1525	3	gr_ipy
grisly	10	43	1058	3	grisly
gritty	10	33	840	3	gritty
grody	10	34	1206	3	gr_ody
groggy	12	3	480	3	groggy
groovy	13	37	540	3	groovy
groszy	19	39	570	3	groszy
grotty	10	38	983	3	grotty
grouty	10	47	1098	3	grouty
growly	13	49	917	3	growly
grub	7	72	2008	3	gr_ub_
grubbed	13	40	643	3	grubbed
grubber	12	41	791	3	grubber
grubbily	16	4	297	3	grubbily
grubs	8	63	1260	3	gr_ubs
gruffy	16	39	601	3	gruffy
grumbly	15	35	540	3	grumbly
grumpy	14	49	815	3	grumpy
grungy	11	34	597	3	grungy
guanay	10	3	791	3	guanay
gyrally	14	3	558	3	gyrally
hobby	15	59	1373	3	_hobby
hubby	15	50	1140	3	_hubby
knobby	17	3	271	3	knobby
knubby	17	4	278	3	knubby
lamby	12	51	1484	3	_lamby
lobby	12	51	1392	3	_lobby
marbly	13	41	1193	3	marbly
nearby	11	35	605	3	nearby
nobby	12	55	1346	3	_nobby
nubby	12	50	1103	3	_nubby
orally	9	31	1359	3	orally
orangy	10	51	1123	3	orangy
orby	9	75	1960	3	or__by
pray	9	63	3153	3	pra__y
prebuy	13	5	742	3	prebuy
rabat	7	28	3222	3	_rabat
rabbet	10	38	1865	3	_rabbet
rabbin	10	31	1230	3	_rabbin
rabbis	10	26	1316	3	_rabbis
rabbit	10	29	1456	3	_rabbit
rabbity	14	26	630	3	_rabbity
rabble	10	38	1824	3	_rabble
rabic	9	38	1740	3	_rabic
rabid	8	45	2078	3	_rabid
racy	9	58	2568	3	_ra_cy
raggy	10	61	1657	3	_raggy
rainy	8	59	2108	3	_rainy
rally	8	47	2590	3	_rally
rammy	12	43	1249	3	_rammy
randy	9	50	2208	3	_randy
rangy	9	53	2038	3	_rangy
raspy	10	65	1170	3	_raspy
ratty	8	48	1959	3	_ratty
rawly	11	51	1583	3	_rawly
ray	6	63	6199	3	_ra__y
rebbe	9	3	1316	3	_rebbe
rebuy	10	47	1468	3	_rebuy
rubbly	13	37	1061	3	_rubbly
ruby	9	78	1994	3	_r_uby
rugby	11	44	813	3	_rugby
scrabbly	17	16	462	3	scrabbly
scrubby	16	4	280	3	scrubby
shrubby	17	4	236	3	shrubby
slobby	13	3	480	3	slobby
snobby	13	3	440	3	snobby
snubby	13	4	453	3	snubby
squabby	23	4	328	3	squabby
stably	11	33	1412	3	stably
stubby	13	4	504	3	stubby
suably	11	28	1453	3	suably
trampy	13	49	925	3	trampy
tranny	9	42	1086	3	tranny
trashy	12	50	905	3	trashy
tray	7	76	3259	3	tra__y
trebly	11	3	897	3	trebly
trilby	11	4	497	3	trilby
tubby	12	45	1140	3	_tubby
usably	11	28	898	3	usably
viably	14	19	983	3	viably
wabbly	16	34	836	3	_wabbly
webby	15	3	715	3	_webby
wrathy	15	37	785	3	wrathy

Search took 7 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.140	1276364.3
2	DLD Change Limit	112716	322	6.050	18630.7
3	Display Results	322	322	0.110	2927.3
	(SQL Overall)	178691	322	6.300	28363.7