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

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

316 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
canful	11	6	1026	(None)
canfuls	12	4	842	1	canfuls
cansful	12	3	683	1	cansful
capful	13	6	817	1	capful
carful	11	6	1097	1	carful
manful	11	6	1021	1	manful
panful	11	7	974	1	panful
annul	5	58	1338	2	_annul
awful	11	7	814	2	_awful
bagful	12	3	721	2	bagful
baneful	12	3	789	2	baneful
cageful	13	5	648	2	cageful
canal	7	54	2804	2	can_al
cancel	10	53	1668	2	cancel
cangue	9	10	1244	2	cangue
cannel	8	42	1640	2	cannel
cannula	9	3	743	2	cannula
cantal	8	41	2203	2	cantal
cantus	8	51	1776	2	cantus
canula	8	3	1296	2	can_ula
capfuls	14	3	652	2	capfuls
careful	12	4	911	2	careful
carfuls	12	4	913	2	carfuls
caul	6	56	3000	2	ca__ul
consul	8	23	1230	2	consul
cupful	13	5	642	2	cupful
earful	9	5	896	2	earful
gainful	11	4	583	2	gainful
handful	14	12	725	2	handful
hangul	10	4	921	2	hangul
hatful	12	10	874	2	hatful
jarful	16	4	668	2	jarful
lapful	11	5	648	2	lapful
lawful	12	3	549	2	lawful
moanful	12	10	500	2	moanful
painful	12	4	640	2	painful
panfuls	12	3	717	2	panfuls
sinful	9	3	880	2	sinful
tankful	14	4	516	2	tankful
tinful	9	3	804	2	tinful
vatful	12	10	708	2	vatful
waeful	12	3	812	2	waeful
afoul	8	5	1019	3	_afoul
aidful	10	5	707	3	aidful
aimful	11	6	670	3	aimful
ampul	9	11	1085	3	_ampul
anal	4	80	3752	3	_an_al
angel	6	50	1956	3	_angel
anil	4	64	3743	3	_an_il
ankus	9	14	1068	3	_ankus
annal	5	65	2076	3	_annal
annual	6	47	1070	3	_annual
annuli	6	45	905	3	_annuli
annuls	6	47	1173	3	_annuls
anus	4	71	3111	3	_an_us
anvil	8	27	1260	3	_anvil
armful	11	6	716	3	armful
artful	9	6	827	3	artful
babul	9	63	1771	3	ba_bul
bagfuls	13	3	475	3	bagfuls
bagsful	13	4	489	3	bagsful
baleful	12	3	800	3	baleful
banal	7	59	2599	3	ban_al
bashful	15	5	655	3	bashful
basinful	13	4	323	3	basinful
boatful	12	3	628	3	boatful
boxful	18	14	527	3	boxful
cabal	9	52	2215	3	ca_bal
cactus	10	49	1223	3	cactus
caecal	10	37	1373	3	caecal
caecum	12	3	818	3	caecum
cafe	9	52	3032	3	ca_f_e
cafes	10	64	2692	3	ca_fes
caff	12	56	3167	3	ca_f_f
caffs	13	54	1737	3	ca_ffs
cagefuls	14	8	434	3	cagefuls
caique	17	31	880	3	caique
calculi	11	4	656	3	calculi
calf	9	63	3956	3	calf__
calfs	10	49	1938	3	calf_s
call	6	68	3867	3	ca__ll
callus	8	53	1707	3	callus
calque	17	28	984	3	calque
camail	10	3	1483	3	camail
camel	9	68	2280	3	ca_mel
campus	12	52	1392	3	campus
can	5	77	6014	3	can___
canals	8	44	2166	3	canals
canape	10	9	1351	3	canape
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
cancan	10	3	1410	3	cancan
cancels	11	41	1331	3	cancels
cancer	10	42	2092	3	cancer
cancha	13	44	1161	3	cancha
candela	10	8	974	3	candela
candid	10	45	1785	3	candid
candle	9	43	2148	3	candle
candor	9	45	1642	3	candor
candour	10	42	1024	3	candour
candy	11	51	1982	3	can_dy
cane	6	66	5312	3	can__e
caned	8	58	3809	3	can_ed
canella	9	3	1079	3	canella
caner	7	53	3477	3	can_er
caners	8	46	2920	3	caners
canes	7	53	5037	3	can_es
canfield	14	4	433	3	canfield
cangues	10	6	1182	3	cangues
canid	8	55	2634	3	can_id
canids	9	51	1813	3	canids
canine	8	38	2670	3	canine
caning	9	41	2862	3	caning
canker	12	44	2252	3	canker
canna	7	59	1933	3	can_na
cannas	8	45	1840	3	cannas
canned	9	50	2206	3	canned
cannels	9	34	1336	3	cannels
canner	8	46	2598	3	canner
cannie	8	38	1936	3	cannie
cannily	12	3	926	3	cannily
cannoli	9	3	726	3	cannoli
cannon	8	45	1444	3	cannon
cannot	8	36	1677	3	cannot
cannulae	10	4	649	3	cannulae
cannular	10	4	628	3	cannular
cannulas	10	3	758	3	cannulas
canny	10	58	1769	3	can_ny
canoe	7	56	2725	3	can_oe
canoed	9	46	1896	3	canoed
canoer	8	51	2107	3	canoer
canoes	8	47	2588	3	canoes
canola	8	3	1362	3	canola
canon	7	47	2530	3	can_on
canons	8	55	2206	3	canons
canopy	13	3	772	3	canopy
cans	6	50	5085	3	can__s
canso	7	50	1940	3	can_so
cansos	8	49	1538	3	cansos
canst	7	49	3221	3	can_st
cant	6	63	6203	3	can__t
cantala	9	41	1467	3	cantala
cantals	9	39	1957	3	cantals
canted	9	48	2578	3	canted
canter	8	52	3011	3	canter
canthal	12	4	1005	3	canthal
canthi	11	3	1097	3	canthi
canthus	12	4	871	3	canthus
cantic	10	39	2054	3	cantic
cantle	8	45	2215	3	cantle
canto	7	49	3101	3	can_to
canton	8	57	2299	3	canton
cantor	8	56	2152	3	cantor
cantos	8	48	2697	3	cantos
cants	7	70	3694	3	can_ts
canty	10	52	2680	3	can_ty
canulae	9	3	1118	3	can_ulae
canular	9	3	1032	3	can_ular
canulas	9	3	1285	3	can_ulas
canvas	11	38	1333	3	canvas
canyon	11	45	1203	3	canyon
capsule	11	3	734	3	capsule
caput	9	8	2398	3	ca_put
caracul	11	3	882	3	caracul
carcel	10	50	1867	3	carcel
carl	6	51	4478	3	ca__rl
carnal	8	39	1920	3	carnal
carol	7	51	2861	3	ca_rol
carpal	10	37	1625	3	carpal
carpel	10	54	1847	3	carpel
carpus	10	55	1430	3	carpus
carrel	8	47	1863	3	carrel
cartel	8	50	2253	3	cartel
carvel	11	48	1757	3	carvel
casque	17	29	927	3	casque
casual	8	11	1286	3	casual
casus	7	64	1925	3	ca_sus
catfall	12	3	739	3	catfall
catgut	9	3	1080	3	catgut
catsup	10	3	643	3	catsup
caucus	10	3	961	3	caucus
caudal	9	16	1148	3	caudal
cauld	8	53	1844	3	ca__uld
caulk	11	53	1545	3	ca__ulk
cauls	7	57	2777	3	ca__uls
causal	8	14	1320	3	causal
cavil	10	38	1649	3	ca_vil
censual	9	3	766	3	censual
census	8	43	1030	3	census
cental	8	44	2096	3	cental
centu	7	61	1941	3	centu_
centum	10	40	1236	3	centum
chanceful	19	4	276	3	chanceful
chancel	14	40	1177	3	chancel
changeful	18	4	259	3	changeful
channel	12	39	1048	3	channel
cineol	8	10	820	3	cineol
cingula	10	32	717	3	cingula
cinque	17	3	685	3	cinque
concur	10	4	1110	3	concur
confab	13	4	706	3	confab
confer	11	40	1868	3	confer
confit	11	33	1640	3	confit
conflux	19	4	300	3	conflux
confuse	12	3	885	3	confuse
confute	12	3	926	3	confute
conium	10	4	1531	3	conium
consol	8	26	1411	3	consol
consuls	9	24	1231	3	consuls
consult	9	25	1363	3	consult
conus	7	67	2653	3	con_us
cranial	9	21	1468	3	cranial
cranium	11	9	1110	3	cranium
cundum	11	3	651	3	cundum
cuneal	8	6	1151	3	cuneal
cupfuls	14	4	434	3	cupfuls
cupsful	14	5	343	3	cupsful
dareful	11	5	705	3	dareful
earfuls	10	3	686	3	earfuls
easeful	10	3	729	3	easeful
eyeful	12	3	590	3	eyeful
factful	15	3	637	3	factful
fanciful	16	4	394	3	fanciful
fanfic	14	3	631	3	fanfic
fanfold	14	8	537	3	fanfold
fanum	10	3	1344	3	fan_um
farfal	12	34	1018	3	farfal
farfel	12	43	1043	3	farfel
fateful	13	9	751	3	fateful
fearful	13	4	559	3	fearful
fitful	12	5	633	3	fitful
gangue	8	13	1057	3	gangue
hamaul	11	42	1087	3	hamaul
handfuls	15	11	575	3	handfuls
handsful	15	4	408	3	handsful
hangup	12	7	729	3	hangup
hansel	9	52	1437	3	hansel
harmful	15	3	576	3	harmful
hateful	13	10	768	3	hateful
hatfuls	13	8	602	3	hatfuls
hatsful	13	10	619	3	hatsful
haul	7	55	3045	3	ha__ul
headful	14	4	556	3	headful
ireful	9	4	871	3	ireful
jarfuls	17	5	477	3	jarfuls
jarsful	17	4	460	3	jarsful
joyful	19	4	384	3	joyful
jugful	17	3	460	3	jugful
kanzu	18	4	759	3	kanzu_
kanzus	19	4	460	3	kanzus
langue	7	10	1217	3	langue
langur	7	10	930	3	langur
lapfuls	12	3	450	3	lapfuls
lungful	11	4	401	3	lungful
manfully	16	4	565	3	manfully
mangel	9	40	1753	3	mangel
manque	17	25	951	3	manque
mantel	8	43	1797	3	mantel
mantua	8	44	1202	3	mantua
manual	8	3	1346	3	manual
manus	7	59	2493	3	man_us
maul	6	48	3072	3	ma__ul
mindful	13	4	461	3	mindful
mugful	12	3	540	3	mugful
nonfuel	10	4	573	3	nonfuel
pageful	13	4	635	3	pageful
pailful	12	3	610	3	pailful
palmful	14	4	505	3	palmful
panel	7	60	2362	3	pan_el
panfry	14	45	641	3	panfry
playful	15	4	465	3	playful
potful	11	3	808	3	potful
rackful	16	4	587	3	rackful
ranula	6	3	1181	3	ran_ula
rueful	9	4	820	3	rueful
sackful	16	4	535	3	sackful
sandal	7	33	1728	3	sandal
sannup	8	3	656	3	sannup
santol	6	45	1524	3	santol
santur	6	3	1127	3	santur
saul	4	58	3652	3	sa__ul
scandal	10	3	867	3	scandal
scornful	13	4	333	3	scornful
skinful	14	4	419	3	skinful
snafu	8	4	1214	3	snafu_
snafus	9	3	674	3	snafus
sobful	11	3	633	3	sobful
songful	11	4	517	3	songful
swayful	16	4	300	3	swayful
synfuel	13	4	243	3	synfuel
tactful	12	3	616	3	tactful
tankfuls	15	4	380	3	tankfuls
tearful	10	4	603	3	tearful
teenful	10	4	556	3	teenful
thankful	18	4	325	3	thankful
tinfuls	10	3	659	3	tinfuls
topful	11	3	654	3	topful
trainful	11	4	518	3	trainful
trayful	13	4	458	3	trayful
tubful	11	3	668	3	tubful
tuneful	10	4	612	3	tuneful
unfurl	9	3	795	3	_unfurl
unmanful	13	4	343	3	unmanful
useful	9	4	701	3	useful
vandal	10	37	1383	3	vandal
vatfuls	13	8	485	3	vatfuls
vauntful	14	4	247	3	vauntful
wailful	13	4	495	3	wailful
wakeful	17	3	561	3	wakeful
wameful	15	3	567	3	wameful
wangun	10	3	710	3	wangun
waul	7	69	2731	3	wa__ul
wilful	12	3	596	3	wilful
woeful	12	3	636	3	woeful
woful	11	5	817	3	_woful
yanqui	18	4	338	3	yanqui

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	316	5.686	19823.4
3	Display Results	316	316	0.096	3291.7
	(SQL Overall)	178691	316	6.158	29017.7