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

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

324 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
crabby	15	34	675	(None)
cabby	14	53	1456	1	c_abby
grabby	14	33	618	1	grabby
blabby	12	3	481	2	blabby
carboy	13	49	1418	2	carboy
chubby	18	4	412	2	chubby
clubby	15	3	468	2	clubby
cobby	14	55	1641	2	c_obby
crab	8	57	2767	2	cra_b_
crabbed	14	38	887	2	crabbed
crabber	13	38	1073	2	crabber
crabbily	17	4	434	2	crabbily
crabs	9	54	2139	2	cra_bs
cracky	17	50	1022	2	cracky
crafty	14	47	891	2	crafty
craggy	13	39	660	2	craggy
crambe	12	3	907	2	crambe
crambo	12	3	804	2	crambo
crampy	15	47	1099	2	crampy
cranky	15	39	1063	2	cranky
cranny	11	42	1027	2	cranny
crappy	15	44	680	2	crappy
crawly	14	46	1076	2	crawly
crazy	19	55	1122	2	cra_zy
crumby	15	40	811	2	crumby
crybaby	19	4	193	2	crybaby
cubby	14	52	1212	2	c_ubby
curably	14	20	1077	2	curably
drably	12	35	1161	2	drably
flabby	16	3	457	2	flabby
gabby	13	55	1295	2	_gabby
grubby	14	32	450	2	grubby
rabbi	9	31	1318	2	_rabbi
ribby	12	41	968	2	_ribby
rubby	12	44	1386	2	_rubby
scabby	15	3	550	2	scabby
scrabbly	17	16	462	2	scrabbly
scrubby	16	4	280	2	scrubby
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
cab	7	83	5540	3	c_a_b_
cabal	9	52	2215	3	c_abal
cabbagy	17	4	401	3	c_abbagy
cabbed	13	54	1626	3	c_abbed
cabbie	12	29	1335	3	c_abbie
caber	9	51	2683	3	c_aber
cabin	9	48	2094	3	c_abin
cable	9	53	2991	3	c_able
cabob	11	46	1681	3	c_abob
cabobs	12	43	1189	3	c_abobs
cabs	8	67	3942	3	c_a_bs
caddy	12	54	1402	3	c_addy
cadgy	12	52	1078	3	c_adgy
cagey	11	59	1782	3	c_agey
cagy	10	63	2199	3	c_a_gy
cakey	14	55	1727	3	c_akey
caky	13	62	2244	3	c_a_ky
campy	14	51	1618	3	c_ampy
candy	11	51	1982	3	c_andy
canny	10	58	1769	3	c_anny
canty	10	52	2680	3	c_anty
capably	16	3	925	3	capably
carabao	11	3	967	3	carabao
carabid	12	3	1133	3	carabid
carabin	11	3	1321	3	carabin
caramba	13	3	689	3	caramba
caraway	15	3	813	3	caraway
carb	8	51	4316	3	c_arb_
carbo	9	49	2384	3	c_arbo
carbon	10	49	1904	3	carbon
carbos	10	51	2226	3	carbos
carboys	14	47	1178	3	carboys
carbs	9	60	3146	3	c_arbs
caribe	10	34	1675	3	caribe
carney	11	53	1570	3	carney
carny	10	58	2292	3	c_arny
carob	9	53	2522	3	carob_
carobs	10	48	1810	3	carobs
carry	10	58	2378	3	c_arry
casky	14	45	1268	3	c_asky
catty	10	45	2041	3	c_atty
cavy	12	59	2000	3	c_a_vy
cay	8	71	5598	3	c_a__y
chabuk	17	3	467	3	chabuk
chaffy	20	45	647	3	chaffy
chalky	18	46	877	3	chalky
chally	14	43	1429	3	chally
chammy	18	48	895	3	chammy
champy	18	50	961	3	champy
chancy	16	40	1086	3	chancy
chanty	14	52	1582	3	chanty
charry	14	50	1211	3	charry
chary	13	50	2313	3	cha_ry
chasmy	16	46	854	3	chasmy
chatty	14	41	936	3	chatty
chay	12	49	2487	3	cha__y
clabber	13	42	1011	3	clabber
clammy	15	35	633	3	clammy
clanky	15	46	907	3	clanky
clary	10	57	1961	3	cla_ry
classy	11	37	904	3	classy
clay	9	59	2741	3	cla__y
clayey	14	40	766	3	clayey
coaly	10	55	2159	3	coa_ly
cobb	10	64	2200	3	c_obb_
cobbs	11	50	1399	3	c_obbs
colby	12	44	1506	3	c_olby
corby	12	50	1853	3	c_orby
cowboy	16	3	706	3	cowboy
craal	7	41	1775	3	cra_al
craals	8	41	1330	3	craals
crabbedly	19	4	194	3	crabb~~edl~~y
crabbers	14	35	875	3	crabbers
crabbier	14	32	680	3	crabbier
crabbing	15	28	793	3	crabbing
crack	13	41	2053	3	cra_ck
crackly	18	39	770	3	crackly
cracks	14	48	1700	3	cracks
cradle	9	33	1316	3	cradle
craft	10	53	2766	3	cra_ft
crafts	11	53	1274	3	crafts
crag	7	56	2530	3	cra__g
crags	8	56	2257	3	cra_gs
crake	11	48	2352	3	cra_ke
crakes	12	49	2181	3	crakes
cram	8	56	3549	3	cra__m
crambes	13	3	996	3	crambes
crambos	13	3	678	3	crambos
cramp	11	51	2069	3	cra_mp
cramps	12	56	1556	3	cramps
crams	9	62	2915	3	cra_ms
cranch	13	36	1353	3	cranch
crane	7	53	3160	3	cra_ne
craned	9	61	2165	3	craned
cranes	8	43	3075	3	cranes
crania	8	24	1843	3	crania
crank	11	48	1961	3	cra_nk
crankly	16	35	812	3	crankly
cranks	12	50	1531	3	cranks
crap	8	57	3184	3	cra__p
crape	9	61	2844	3	cra_pe
craped	11	61	2052	3	craped
crapes	10	47	2769	3	crapes
craps	9	53	2864	3	cra_ps
crases	8	55	3231	3	crases
crash	10	91	2001	3	cra_sh
crasis	8	50	2047	3	crasis
crass	7	63	2804	3	cra_ss
crassly	12	7	665	3	crassly
cratch	13	41	1079	3	cratch
crate	7	65	3740	3	cra_te
crated	9	48	2777	3	crated
crater	8	50	2664	3	crater
crates	8	57	3606	3	crates
craton	8	45	1719	3	craton
cravat	11	3	1444	3	cravat
crave	10	56	2631	3	cra_ve
craved	12	54	1777	3	craved
craven	11	41	1393	3	craven
craver	11	46	1847	3	craver
craves	11	58	2539	3	craves
craw	9	77	2526	3	cra__w
crawl	10	49	1671	3	cra_wl
crawls	11	47	1208	3	crawls
craws	10	57	2312	3	cra_ws
crayon	11	41	1000	3	crayon
craze	16	52	2146	3	cra_ze
crazed	18	47	1445	3	crazed
crazes	17	47	2013	3	crazes
crazily	21	3	692	3	crazily
creaky	15	49	1155	3	creaky
creamy	13	48	1136	3	creamy
creasy	11	46	1230	3	creasy
creepy	13	41	880	3	creepy
crepey	13	51	1093	3	crepey
crepy	12	48	1270	3	cr_epy
cressy	11	43	911	3	cressy
crib	8	63	2358	3	cr_ib_
cribbed	14	40	766	3	cribbed
cribber	13	36	766	3	cribber
cribs	9	45	1675	3	cr_ibs
crikey	15	31	778	3	crikey
crimpy	15	48	939	3	crimpy
crispy	13	47	856	3	crispy
croaky	15	52	848	3	croaky
crony	10	59	1867	3	cr_ony
croupy	13	45	873	3	croupy
crowdy	15	46	717	3	crowdy
cruddy	13	3	419	3	cruddy
crumb	11	43	1359	3	crumb_
crumbly	16	34	752	3	crumbly
crumbs	12	40	923	3	crumbs
crummy	15	36	589	3	crummy
crusty	11	49	1134	3	crusty
cry	8	97	2624	3	cr___y
curable	11	24	1451	3	curable
curacy	13	3	959	3	cura_cy
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
gaby	10	71	2319	3	_ga_by
globby	14	3	468	3	globby
grab	7	54	2761	3	gra_b_
grabbed	13	36	864	3	grabbed
grabber	12	38	976	3	grabber
grabble	12	33	964	3	grabble
graben	9	41	972	3	graben
grabs	8	57	1969	3	gra_bs
grainy	10	39	1421	3	grainy
granny	10	43	1116	3	granny
grapey	12	60	1230	3	grapey
grapy	11	54	1643	3	gra_py
grassy	10	61	909	3	grassy
gravy	12	55	1211	3	gra_vy
gray	8	53	2989	3	gra__y
grayly	13	28	796	3	grayly
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
scrabble	14	19	699	3	scrabble
scraggy	14	30	458	3	scraggy
scrappy	16	23	447	3	scrappy
scrawly	15	19	719	3	scrawly
scrawny	15	21	394	3	scrawny
scribbly	17	14	362	3	scribbly
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.376	475242.0
2	DLD Change Limit	112716	324	5.593	20153.0
3	Display Results	324	324	0.110	2945.5
	(SQL Overall)	178691	324	6.079	29394.8