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

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

332 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
canaries	10	3	1894	(None)
angaries	9	3	1439	2	_angaries
binaries	10	3	1418	2	binaries
calories	10	29	1956	2	calories
calvaries	14	4	980	2	calvaries
canakins	14	20	1046	2	canakins
canalise	10	8	1621	2	canalise
canalises	11	5	1549	2	canalises
canalizes	20	11	1378	2	canalizes
canapes	11	12	1308	2	cana_pes
canards	10	3	1120	2	canar_ds
candies	10	41	2561	2	can_dies
canities	10	15	1926	2	canities
canneries	11	3	1308	2	canneries
canonries	11	4	841	2	canonries
canopies	12	3	1185	2	canopies
cantrips	12	31	893	2	cantrips
caries	8	51	4762	2	c__aries
carries	9	43	2801	2	ca_rries
catenaries	12	4	866	2	catenaries
cavalries	14	4	636	2	cavalries
chantries	14	3	1029	2	chantries
claries	9	34	2220	2	c_laries
covaries	13	4	1325	2	covaries
dataries	9	3	1403	2	dataries
gantries	9	14	1379	2	gantries
granaries	10	15	988	2	granaries
laniaries	9	4	1122	2	laniaries
panfries	13	14	920	2	panfries
pantries	10	18	1739	2	pantries
salaries	8	3	1959	2	salaries
vagaries	12	3	1029	2	vagaries
acarids	10	53	1224	3	_acarids
acarines	10	3	1434	3	_acarines
actuaries	11	4	757	3	actuaries
aeries	6	47	3778	3	_a_eries
agarics	10	31	994	3	_agarics
ambaries	12	33	1238	3	ambaries
ambries	11	16	1455	3	_ambries
anankes	11	3	876	3	_anankes
anarchies	14	4	818	3	_anarchies
anarchs	12	3	709	3	_anarchs
anergies	9	3	1045	3	_anergies
angarias	9	3	1055	3	_angarias
angrier	8	3	902	3	_angrier
angriest	9	3	1025	3	_angriest
anomies	9	33	1699	3	_anomies
antres	6	50	2100	3	_antr_es
anurias	7	3	1225	3	_anurias
aperies	9	4	2320	3	_aperies
apiaries	10	3	1273	3	apiaries
ataxies	14	24	1001	3	_ataxies
avarices	13	3	718	3	_avarices
aviaries	11	3	978	3	aviaries
bakeries	14	3	1219	3	bakeries
banalizes	20	12	1009	3	banalizes
bandies	10	41	2486	3	ban_dies
banshies	13	11	1066	3	banshies
banties	9	43	2476	3	ban_ties
bawdries	14	13	684	3	bawdries
beaneries	11	3	1090	3	beaneries
cabaret	11	25	1904	3	cabar_et
cabarets	12	26	846	3	cabarets
cabbies	13	31	1516	3	ca_bbies
caddies	11	37	1838	3	ca_ddies
cadres	9	40	1793	3	ca_dr_es
calamaries	14	4	688	3	calamaries
calamines	13	3	1222	3	calamines
calamites	13	4	1071	3	calamites
calashes	13	3	1054	3	calashes
calorics	12	28	1046	3	calorics
calorie	9	27	1690	3	calorie_
calorizes	20	23	1230	3	calorizes
calvarias	14	4	766	3	calvarias
camails	11	3	1175	3	cama_ils
camases	11	42	1634	3	cama_ses
camasses	12	38	897	3	camasses
cambrics	16	4	525	3	cambrics
cammies	13	40	1648	3	ca_mmies
canailles	11	4	827	3	canailles
canakin	13	18	1083	3	canaki_n
canaled	10	36	1556	3	cana_led
canaling	11	20	1641	3	canaling
canalised	12	8	1091	3	canalised
canalize	19	9	1449	3	canalize
canalized	21	6	1169	3	canalized
canalled	11	3	958	3	canalled
canaller	10	3	895	3	canaller
canallers	11	3	721	3	canallers
canals	8	44	2167	3	cana__ls
canape	10	9	1351	3	cana_pe_
canard	9	3	1476	3	canar__d
canary	11	3	1469	3	canar__y
canastas	10	3	769	3	canastas
cancroids	14	4	453	3	cancroids
candids	11	38	1269	3	can_dids
candied	11	38	1602	3	can_died
candles	10	44	2234	3	can_dles
caners	8	46	2920	3	caner__s
canes	7	53	5037	3	can___es
canewares	14	4	736	3	canewar_es
cangues	10	6	1182	3	can_gues
canids	9	51	1813	3	can__ids
canikins	14	21	916	3	canikins
canines	9	37	2403	3	can_ines
cannabins	13	6	578	3	cannabins
cannabis	12	6	603	3	cannabi_s
cannabises	14	4	443	3	cannabises
cannie	8	38	1936	3	can_nie_
cannier	9	40	1416	3	can_nier
canniest	10	3	1336	3	can_niest
cannonries	12	4	409	3	cannonries
canoes	8	47	2588	3	can__oes
canonise	10	5	1109	3	canonise
canonises	11	4	1080	3	canonises
canonizes	20	4	959	3	canonizes
canopied	13	3	634	3	canopied
canorous	10	3	1019	3	canorous
cantabiles	14	4	576	3	cantabiles
cantatrices	15	5	344	3	cantatrices
cantharides	17	5	403	3	cantharides
cantharis	14	4	718	3	canthari_s
cantles	9	47	2141	3	can_tles
cantraips	13	25	527	3	cantraips
cantraps	12	31	911	3	cantraps
cantrip	11	29	1004	3	cantri_p
canvases	13	34	952	3	canvases
canvasses	14	28	604	3	canvasses
canzones	19	3	915	3	canzones
caprices	14	3	989	3	ca_prices
capris	10	4	1508	3	ca_pri_s
carabids	13	3	819	3	carabids
carabines	13	3	1147	3	carabines
carabins	12	3	1236	3	carabins
carafes	12	50	1570	3	cara_fes
carates	9	56	3061	3	cara_tes
cares	7	73	6918	3	c__ar_es
carfares	13	3	1032	3	carfar_es
caribes	11	37	1564	3	c__aribes
carices	11	42	2095	3	c__arices
caried	9	45	2869	3	c__aried
carles	8	54	3508	3	c__arles
carnages	11	3	1221	3	carna_ges
carnies	9	41	2396	3	ca_rnies
carnifies	14	3	989	3	carnifies
carried	10	37	1715	3	ca_rried
carrier	9	36	1958	3	ca_rrier
carriers	10	36	1420	3	ca_rriers
carses	8	52	3365	3	c__arses
cartes	8	62	3947	3	c__artes
carves	11	51	2845	3	c__arves
casefies	13	3	921	3	casefies
casernes	10	38	1075	3	casernes
cataloes	10	3	1165	3	cataloes
catamites	13	4	936	3	catamites
catarrhs	13	4	434	3	catarrhs
catbrier	12	3	617	3	catbrier
catbriers	13	4	414	3	catbriers
catharses	14	4	641	3	catharses
catteries	11	8	1552	3	catteries
catties	9	40	2305	3	ca_tties
causeries	11	5	1064	3	causeries
cauteries	11	6	1539	3	cauteries
cavalier	13	4	818	3	cavalier
cavaliers	14	5	562	3	cavaliers
cavallies	14	4	639	3	cavallies
caviares	13	3	799	3	caviar_es
cavies	11	45	2500	3	c__avies
cavities	13	14	1261	3	cavities
celeries	10	3	1631	3	celeries
cenacles	12	3	802	3	cenacles
centares	10	29	1389	3	centar_es
centauries	12	4	553	3	centauries
centres	9	38	1712	3	centr_es
centuries	11	3	1133	3	centuries
chanceries	17	4	765	3	chanceries
chancres	15	42	936	3	chancr_es
chanties	13	26	1580	3	chan_ties
chares	11	56	3180	3	c_har_es
charges	13	46	1598	3	c_harges
charier	12	43	1790	3	c_harier
chariest	13	3	1551	3	c_hariest
charlies	13	34	1423	3	c_harlies
cheapies	15	3	903	3	cheapies
cherries	13	18	1298	3	cherries
chivaries	17	5	743	3	chivaries
cinerins	10	4	1410	3	cinerins
claroes	9	31	1373	3	c_laroes
conchies	15	32	1485	3	conchies
congeries	12	3	1640	3	congeries
conies	8	43	3859	3	con__ies
contraries	12	7	1193	3	contraries
contrives	14	3	1170	3	contrives
coronaries	12	4	1023	3	coronaries
corries	9	40	2680	3	c_orries
coteries	10	4	2270	3	coteries
countries	11	3	1361	3	countries
covaried	14	4	800	3	covaried
cowries	12	42	1801	3	c_owries
crannies	10	3	1301	3	cran_nies
crazies	18	34	1385	3	c_razies
cries	7	54	3840	3	c___ries
cumarins	12	3	864	3	cumarins
curacies	12	3	1176	3	curacies
curares	9	49	1685	3	curar_es
curarines	11	7	1055	3	curarines
curaris	9	41	1477	3	curari_s
curarizes	20	7	817	3	curarizes
curies	8	49	3402	3	c__uries
curries	9	37	2316	3	c_urries
cyanamides	18	4	295	3	cyanamides
cyanamids	17	4	316	3	cyanamids
cyanates	13	23	843	3	cyana_tes
dairies	8	42	1773	3	da_iries
dandies	9	41	2144	3	dan_dies
daubries	11	3	674	3	daubries
deaneries	10	3	1083	3	deaneries
dearies	8	35	2627	3	_dearies
decenaries	13	4	812	3	decenaries
denarius	9	4	881	3	denarius
diaries	8	33	2195	3	_diaries
drearies	9	23	1341	3	drearies
eateries	8	3	2431	3	eateries
entries	7	15	2316	3	_entries
faeries	10	41	1899	3	fa_eries
fairies	10	35	1604	3	fa_iries
fakeries	15	5	983	3	fakeries
fanatics	13	6	718	3	fanatics
fancies	12	40	1878	3	fan_cies
fanfares	14	3	677	3	fanfar_es
fannies	10	34	1564	3	fan_nies
fantasies	12	9	885	3	fantasies
fineries	11	24	1674	3	fineries
flaneries	12	4	956	3	flaneries
friaries	11	3	1008	3	friaries
galaxies	16	3	717	3	galaxies
ganaches	14	3	743	3	ganaches
gauntries	10	4	604	3	gauntries
gentries	9	13	1526	3	gentries
gramaries	12	12	831	3	gramaries
hankies	14	36	1776	3	han_kies
harries	10	35	2549	3	ha_rries
henries	10	27	1828	3	hen_ries
hymnaries	17	5	431	3	hymnaries
jaggaries	18	13	574	3	jaggaries
janisaries	17	4	478	3	janisaries
janizaries	26	4	350	3	janizaries
japeries	17	3	1146	3	japeries
kauries	11	36	1319	3	ka_uries
lanais	6	3	1679	3	lana_i_s
laundries	10	4	556	3	laundries
lunacies	10	3	801	3	lunacies
maladies	11	3	1193	3	maladies
malarias	10	3	1377	3	malarias
malarkies	15	4	512	3	malarkies
manacles	12	3	952	3	manacles
manages	10	34	1896	3	mana_ges
manakins	14	20	976	3	manakins
manatees	10	3	1042	3	manatees
mandarins	12	4	1039	3	mandarins
mandrils	11	3	849	3	mandrils
mangabies	14	4	637	3	mangabies
manures	9	3	1335	3	manur_es
marries	9	38	2528	3	ma_rries
nancies	9	35	1684	3	nan_cies
nannies	7	30	1520	3	nan_nies
naperies	10	3	1390	3	naperies
nares	5	55	4415	3	__nar_es
naris	5	57	3529	3	__nari_s
navies	9	52	1862	3	__navies
notaries	8	3	1493	3	notaries
octonaries	12	4	600	3	octonaries
ovaries	10	3	1265	3	_ovaries
panaches	15	3	1029	3	panaches
pandies	10	42	2450	3	pan_dies
panfried	14	13	493	3	panfried
pansies	9	45	2198	3	pan_sies
panties	9	42	3093	3	pan_ties
papacies	14	3	948	3	papacies
paries	8	47	4251	3	__paries
parries	9	39	2584	3	pa_rries
pastries	10	15	1742	3	pastries
penuries	10	3	1166	3	penuries
pineries	10	24	1908	3	pineries
planarias	11	4	740	3	planarias
plenaries	11	4	1038	3	plenaries
quandaries	20	6	441	3	quandaries
quinaries	18	5	787	3	quinaries
randies	8	42	2566	3	ran_dies
ratanies	8	3	1292	3	ratanies
rosaries	8	3	1278	3	rosaries
rotaries	8	3	1569	3	rotaries
safaried	12	3	625	3	safaried
safaris	10	11	1066	3	safari_s
salaried	9	3	1103	3	salaried
sangarees	10	4	654	3	sangarees
sangrias	9	3	837	3	sangrias
sanies	6	30	3195	3	san__ies
sanitaries	10	4	991	3	sanitaries
sanities	8	12	1977	3	sanities
sauries	7	28	2162	3	sa_uries
savarins	11	3	989	3	savarins
savories	11	3	1127	3	savories
scalares	10	32	1098	3	scalar_es
scanties	10	32	1542	3	scan_ties
scenarios	11	4	481	3	scenarios
sceneries	11	4	939	3	sceneries
senarius	8	3	1010	3	senarius
sentries	8	13	1805	3	sentries
snares	6	53	2903	3	_snar_es
stannaries	10	4	578	3	stannaries
sudaries	9	3	1275	3	sudaries
sundries	9	3	1202	3	sundries
tamarins	10	3	1084	3	tamarins
tamaris	9	4	1360	3	tamari_s
tanneries	9	3	1042	3	tanneries
tansies	7	45	2124	3	tan_sies
tarries	7	33	2426	3	ta_rries
tawdries	12	13	608	3	tawdries
ternaries	9	3	1164	3	ternaries
uakaris	11	4	663	3	uakari_s
urinaries	9	4	920	3	urinaries
vanities	11	14	1449	3	vanities
varies	9	43	3087	3	__varies
veneries	11	28	1503	3	veneries
vineries	11	27	1604	3	vineries
vivaries	14	3	926	3	vivaries
votaries	11	3	1201	3	votaries
wastries	11	12	1288	3	wastries
wearies	10	30	2022	3	_wearies
wineries	11	23	1653	3	wineries
zanies	15	32	1967	3	zan__ies

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	146162	0.420	425454.8
2	DLD Change Limit	146162	332	6.783	21548.3
3	Display Results	332	332	0.123	2699.2
	(SQL Overall)	178691	332	7.326	24391.3