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

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

308 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
caramel	11	3	1025	(None)
caramels	12	3	880	1	caramels
caravel	12	3	820	1	caravel
arame	7	50	2662	2	_arame_
arames	8	46	2257	2	_arames
calomel	11	3	807	2	calomel
camel	9	68	2280	2	c__amel
caracal	11	3	1251	2	caracal
caracol	11	3	1042	2	caracol
caracul	11	3	882	2	caracul
carafe	11	54	1616	2	carafe_
carafes	12	50	1570	2	carafes
caramba	13	3	689	2	caramba
carate	8	47	3400	2	carate_
carates	9	56	3061	2	carates
caravels	13	3	743	2	caravels
carbamyl	17	4	310	2	carbamyl
carcel	10	50	1867	2	car_cel
carmen	10	40	1934	2	car_men
caromed	12	37	1362	2	caromed
carpel	10	54	1847	2	car_pel
carrel	8	47	1863	2	car_rel
cartel	8	50	2253	2	car_tel
carvel	11	48	1757	2	car_vel
ceramal	11	3	884	2	ceramal
cormel	10	38	1560	2	cor_mel
tramel	8	41	1371	2	_tramel
arable	8	18	2100	3	_arable
aramid	9	33	1561	3	_aramid
ariel	5	52	2897	3	_ar_iel
armed	8	63	2443	3	_ar_med
armer	7	69	2444	3	_ar_mer
armet	7	67	3945	3	_ar_met
artel	5	61	2274	3	_ar_tel
barbel	10	43	1707	3	bar_bel
barmen	10	54	1853	3	bar_men
barrel	8	45	1787	3	bar_rel
cabal	9	52	2215	3	caba__l
cabaret	11	25	1904	3	cabaret
cabmen	12	36	1065	3	ca_bmen
cadaver	13	3	578	3	cadaver
calamar	11	4	929	3	calamar
calami	10	3	1342	3	calam_i
calamus	11	3	924	3	calamus
calmed	11	48	1638	3	ca_lmed
calmer	10	52	1693	3	ca_lmer
calomels	12	3	613	3	calomels
calumet	11	3	1329	3	calumet
camail	10	3	1483	3	cama_il
camases	11	42	1634	3	camases
came	8	76	4875	3	c__ame_
camels	10	52	1708	3	c__amels
cameo	9	59	2499	3	c__ameo
cameramen	15	4	413	3	cameramen
cames	9	70	4731	3	c__ames
canal	7	54	2804	3	cana__l
canaled	10	36	1555	3	canaled
canape	10	9	1351	3	canape_
canapes	11	12	1308	3	canapes
cancel	10	53	1668	3	ca_ncel
cannel	8	42	1640	3	ca_nnel
capable	13	3	1336	3	capable
carabao	11	3	967	3	carabao
carabid	12	3	1133	3	carabid
carabin	11	3	1321	3	carabin
caracals	12	3	1074	3	caracals
carack	14	21	1317	3	cara_ck
caracks	15	22	1156	3	caracks
caracole	12	3	1035	3	caracole
caracols	12	3	1041	3	caracols
caraculs	12	3	803	3	caraculs
carageen	11	5	563	3	carageen
carambola	15	4	285	3	carambola
caramelise	14	6	468	3	caramel~~ise~~
caramelize	23	6	411	3	caramel~~ize~~
carapax	18	3	579	3	carapax
carat	7	50	4879	3	cara__t
carats	8	59	2902	3	cara_ts
caravan	12	3	922	3	caravan
caravelle	14	4	469	3	caravelle
caraway	15	3	813	3	caraway
carbamic	16	4	591	3	carbamic
carbamoyl	18	5	189	3	carbamoyl
carbamyls	18	4	303	3	carbamyls
carbaryl	15	4	442	3	carbaryl
carcanet	12	3	1634	3	carcanet
carcase	11	3	1273	3	carcase_
carcases	12	3	1308	3	carcases
carcels	11	45	1606	3	car_cels
cardamom	15	4	388	3	cardamom
cardamon	13	4	555	3	cardamon
cardamum	15	4	310	3	cardamum
carded	10	54	2490	3	car_ded
carder	9	45	2418	3	car_der
care	6	69	6837	3	car__e_
cared	8	60	5009	3	car__ed
careen	8	41	1949	3	car_een
career	8	58	2224	3	car_eer
careful	12	4	911	3	careful
carer	7	49	4233	3	car__er
cares	7	73	6918	3	car__es
caret	7	53	6056	3	car__et
carex	14	48	2230	3	car__ex
carfare	12	3	1007	3	carfare_
carfares	13	3	1032	3	carfares
carful	11	6	1097	3	car_ful
cargoes	10	44	1522	3	cargoes
caribe	10	34	1675	3	caribe_
caribes	11	37	1564	3	caribes
carices	11	42	2095	3	carices
caried	9	45	2869	3	car_ied
caries	8	51	4762	3	car_ies
carinal	9	43	1823	3	carinal
cariole	9	8	1834	3	cariole
carked	13	40	2482	3	car_ked
carl	6	51	4478	3	car___l
carle	7	45	3570	3	car_le_
carles	8	54	3508	3	car_les
carmaker	16	3	730	3	carmaker
carman	10	39	2074	3	car_man
carnage	10	3	1174	3	carnage_
carnages	11	3	1221	3	carnages
carnal	8	39	1920	3	car_nal
carnet	8	47	3287	3	car_net
carney	11	53	1570	3	car_ney
carnie	8	44	2109	3	carnie_
carnies	9	41	2396	3	carnies
carol	7	51	2861	3	car__ol
caroled	10	37	1768	3	caroled
caroler	9	38	1675	3	caroler
carom	9	50	2556	3	carom__
caroms	10	56	1957	3	carom_s
carousel	10	5	731	3	carousel
carpal	10	37	1625	3	car_pal
carpale	11	34	1435	3	carpale_
carped	11	59	2376	3	car_ped
carpels	11	53	1546	3	car_pels
carper	10	49	2363	3	car_per
carpet	10	45	3009	3	car_pet
carpool	11	3	922	3	carpool
carrell	9	46	1047	3	carrell
carrels	9	51	1730	3	car_rels
carried	10	37	1715	3	carried
carrier	9	36	1958	3	carrier
carries	9	43	2801	3	carries
carromed	13	3	856	3	carromed
carse	7	49	3433	3	car_se_
carses	8	52	3365	3	car_ses
cartable	12	13	1409	3	cartable
cartage	10	3	1259	3	cartage_
cartages	11	3	1331	3	cartages
carte	7	59	4042	3	car_te_
carted	9	86	3144	3	car_ted
cartels	9	46	1812	3	car_tels
carter	8	49	3227	3	car_ter
cartes	8	62	3947	3	car_tes
carve	10	62	2775	3	car_ve_
carved	12	43	2085	3	car_ved
carvels	12	49	1459	3	car_vels
carven	11	47	1666	3	car_ven
carver	11	44	2014	3	car_ver
carves	11	51	2845	3	car_ves
cascabel	14	17	450	3	cascabel
cavemen	14	3	714	3	cavemen
ceramals	12	4	651	3	ceramals
ceramic	13	3	982	3	ceramic
cerate	8	48	2946	3	cerate_
cerated	10	39	2247	3	cerated
cerates	9	54	2825	3	cerates
cermet	10	3	2115	3	cer_met
cerumen	11	4	776	3	cerumen
chapel	13	49	1137	3	c_hapel
charade	13	12	991	3	charade_
charades	14	13	1085	3	charades
charases	13	13	1276	3	charases
charmed	15	47	1425	3	char_med
charmer	14	49	1366	3	char_mer
charnel	12	40	1005	3	char_nel
chrome	13	32	1481	3	chrome_
chromed	15	35	1092	3	chromed
chromes	14	29	1493	3	chromes
chromyl	17	27	523	3	chromyl
citadel	10	4	438	3	citadel
columel	11	3	627	3	columel
coracle	11	20	1172	3	coracle
coral	7	60	3345	3	cora__l
corbel	10	37	1597	3	cor_bel
cormels	11	38	1337	3	cor_mels
cornel	8	40	2005	3	cor_nel
cornmeal	12	4	585	3	cornmeal
coronel	9	45	1522	3	coronel
craal	7	41	1775	3	c_ra_al
craaled	10	33	942	3	craaled
cradle	9	33	1316	3	c_radle
crake	11	48	2352	3	c_rake_
crakes	12	49	2181	3	c_rakes
cram	8	56	3549	3	c_ram__
crambe	12	3	907	3	c_rambe
crambes	13	3	996	3	c_rambes
crambo	12	3	804	3	c_rambo
crammed	14	37	1012	3	crammed
crammer	13	40	1096	3	crammer
cramp	11	51	2069	3	c_ram_p
cramped	14	47	1218	3	c_ramped
cramps	12	56	1556	3	c_ramps
crampy	15	47	1099	3	c_rampy
crams	9	62	2915	3	c_ram_s
crane	7	53	3160	3	c_rane_
craned	9	61	2165	3	c_raned
cranes	8	43	3075	3	c_ranes
crape	9	61	2844	3	c_rape_
craped	11	61	2052	3	c_raped
crapes	10	47	2769	3	c_rapes
crases	8	55	3231	3	c_rases
crate	7	65	3740	3	c_rate_
crated	9	48	2777	3	c_rated
crater	8	50	2664	3	c_rater
crates	8	57	3606	3	c_rates
crave	10	56	2631	3	c_rave_
craved	12	54	1777	3	c_raved
craven	11	41	1393	3	c_raven
craver	11	46	1846	3	c_raver
craves	11	58	2539	3	c_raves
crawl	10	49	1671	3	c_ra_wl
craze	16	52	2146	3	c_raze_
crazed	18	47	1445	3	c_razed
crazes	17	47	2013	3	c_razes
creamed	12	39	1371	3	creamed
creamer	11	37	1408	3	creamer
creel	7	51	2148	3	c_r_eel
creme	9	43	1932	3	c_reme_
cremes	10	45	1799	3	c_remes
crenel	8	42	1306	3	c_renel
crewel	11	43	1047	3	c_rewel
crime	9	48	2269	3	c_rime_
crimes	10	55	2158	3	c_rimes
cruel	7	48	1590	3	c_r_uel
curable	11	24	1451	3	curable
curare	8	49	1695	3	curare_
curares	9	49	1685	3	curares
curate	8	52	2624	3	curate_
curated	10	47	1758	3	curated
curates	9	53	2383	3	curates
darnel	7	43	1218	3	dar_nel
duramen	10	9	690	3	duramen
enamel	8	12	1011	3	_enamel
falafel	13	8	390	3	falafel
fardel	10	47	1259	3	far_del
farfel	12	43	1043	3	far_fel
farmed	12	51	1765	3	far_med
farmer	11	50	1737	3	far_mer
foramen	12	3	1053	3	foramen
frame	10	58	2180	3	_frame_
framed	12	51	1652	3	_framed
framer	11	48	1744	3	_framer
frames	11	51	1986	3	_frames
garage	8	3	1451	3	garage_
garaged	10	3	925	3	garaged
garages	9	3	1411	3	garages
gravel	10	53	1382	3	_gravel
harmed	12	52	1883	3	har_med
harmer	11	47	1955	3	har_mer
karakul	10	4	255	3	karakul
karate	10	53	2092	3	karate_
karates	11	56	1747	3	karates
macrame	13	3	871	3	macrame_
macrames	14	3	895	3	macrames
madame	11	3	985	3	madame_
madames	12	3	1006	3	madames
marcel	10	37	1485	3	mar_cel
marvel	11	37	1200	3	mar_vel
oarsmen	9	3	809	3	oarsmen
parable	11	18	1977	3	parable
parade	9	47	2064	3	parade_
paraded	11	40	1426	3	paraded
parader	10	39	1486	3	parader
parades	10	41	2146	3	parades
parae	7	63	3570	3	para_e_
parallel	10	4	746	3	parallel
parament	12	4	1539	3	parament
paramo	10	26	1464	3	param_o
paramos	11	32	1351	3	paramos
parapet	11	3	1764	3	parapet
parasol	9	3	955	3	parasol
parcel	10	39	1547	3	par_cel
parrel	8	45	1598	3	par_rel
ramal	7	46	2224	3	__ramal
ramee	7	46	3385	3	__ramee
ramen	7	56	2519	3	__ramen
ramet	7	57	4314	3	__ramet
ratel	5	42	2488	3	__ratel
ravel	8	46	2151	3	__ravel
sagamen	10	12	750	3	sagamen
sarape	8	48	1757	3	sarape_
sarapes	9	46	1774	3	sarapes
tarama	8	4	1273	3	taram_a
taramas	9	6	1270	3	taramas
tramell	9	39	870	3	_tramell
tramels	9	38	1249	3	_tramels
trammel	11	35	766	3	trammel
travel	9	41	1298	3	_travel
unravel	10	3	806	3	unravel
wadmel	12	3	552	3	wa_dmel
wakame	15	3	543	3	wakame_
wakames	16	3	528	3	wakames
warmed	12	45	1689	3	war_med
warmer	11	38	1673	3	war_mer
yardmen	13	3	542	3	yardmen

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	134027	0.140	1276364.3
2	DLD Change Limit	134027	308	6.953	19276.1
3	Display Results	308	308	0.110	2800.0
	(SQL Overall)	178691	308	7.203	24807.9