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

Here are the results of your fuzzy-string dictionary search for “carls” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

361 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
carls	7	70	3742	(None)
calls	7	56	3473	1	calls
carbs	9	60	3146	1	carbs
cards	8	51	3793	1	cards
cares	7	73	6918	1	cares
carks	11	55	3421	1	carks
carl	6	51	4478	1	carl_
carle	7	45	3570	1	carle
carles	8	54	3508	1	carles
carns	7	59	3756	1	carns
carols	8	51	2498	1	carols
carps	9	69	3225	1	carps
carrs	7	57	3085	1	carrs
cars	6	73	6476	1	car_s
carts	7	89	4629	1	carts
cauls	7	57	2777	1	cauls
curls	7	49	2710	1	curls
earls	5	61	2751	1	earls
farls	8	57	3111	1	farls
harls	8	56	3450	1	harls
jarls	12	61	2096	1	jarls
marls	7	55	3516	1	marls
aals	4	99	4114	2	_aals
acarus	8	3	1219	2	acarus
acres	7	63	2776	2	acres
acyls	10	42	1152	2	acyls
ails	4	56	5471	2	_ails
alls	4	67	4092	2	_alls
als	3	66	6302	2	_a_ls
arbs	6	68	3473	2	_arbs
arcs	6	78	3478	2	_arcs
ares	4	58	7102	2	_ares
arfs	7	60	2996	2	_arfs
arils	5	87	3220	2	_arils
arks	8	59	3687	2	_arks
arles	5	67	3574	2	_arles
arms	6	61	3749	2	_arms
ars	3	76	7093	2	_ar_s
arts	4	96	5026	2	_arts
aryls	8	70	1581	2	_aryls
awls	7	59	2609	2	_awls
baals	7	61	2270	2	baals
bails	7	59	3352	2	bails
balls	7	62	3641	2	balls
bals	6	63	5404	2	ba_ls
barbs	9	59	2819	2	barbs
bards	8	71	3964	2	bards
bares	7	54	5713	2	bares
barfs	10	48	2600	2	barfs
barks	11	57	3581	2	barks
barms	9	61	2846	2	barms
barns	7	63	3514	2	barns
bars	6	65	6409	2	bar_s
bawls	10	57	1932	2	bawls
birls	7	40	2316	2	birls
burls	7	42	2885	2	burls
byrls	10	57	1123	2	byrls
cabals	10	40	2015	2	cabals
cable	9	53	2991	2	cable
cables	10	45	2755	2	cables
cabs	8	67	3942	2	ca_bs
cacas	9	56	2798	2	cacas
cades	8	54	4073	2	cades
cadis	8	44	2850	2	cadis
cadres	9	40	1793	2	cadres
cads	7	61	4452	2	ca_ds
cafes	10	64	2692	2	cafes
caffs	13	54	1737	2	caffs
cages	8	59	3601	2	cages
caids	8	52	2642	2	caids
cains	7	53	3430	2	cains
cairds	9	64	1151	2	cairds
cairns	8	53	1330	2	cairns
cakes	11	60	3767	2	cakes
calf	9	63	3956	2	ca_lf
calfs	10	49	1938	2	calfs
calk	10	55	2766	2	ca_lk
calks	11	54	2160	2	calks
call	6	68	3867	2	ca_ll
calla	7	48	2707	2	calla
callas	8	45	2675	2	callas
callus	8	53	1707	2	callus
calm	8	50	3236	2	ca_lm
calms	9	52	2235	2	calms
calo	6	49	3644	2	ca_lo
calos	7	44	3190	2	calos
calx	13	57	2279	2	ca_lx
camas	9	63	3352	2	camas
camels	10	52	1708	2	camels
cames	9	70	4731	2	cames
camos	9	59	2761	2	camos
camps	11	63	3026	2	camps
cams	8	70	4728	2	ca_ms
canals	8	44	2167	2	canals
canes	7	53	5037	2	canes
cans	6	50	5085	2	ca_ns
cants	7	70	3694	2	cants
capes	9	54	4192	2	capes
caphs	12	45	1537	2	caphs
capos	9	48	2607	2	capos
capris	10	4	1508	2	capris
caps	8	71	4789	2	ca_ps
car	5	91	6556	2	car__
carat	7	50	4879	2	carat
carats	8	59	2902	2	carats
carb	8	51	4316	2	car_b
carbo	9	49	2384	2	carbo
carbos	10	51	2226	2	carbos
carcels	11	45	1606	2	carcels
card	7	102	4587	2	car_d
care	6	69	6837	2	car_e
cared	8	60	5009	2	cared
carer	7	49	4233	2	carer
carers	8	51	3396	2	carers
caress	8	57	2026	2	caress
caret	7	53	6056	2	caret
carets	8	53	3077	2	carets
carex	14	48	2230	2	carex
carfuls	12	4	913	2	carfuls
cargo	8	53	2207	2	cargo
cargos	9	46	1918	2	cargos
caries	8	51	4762	2	caries
cark	10	55	3927	2	car_k
carless	9	51	1849	2	carless
carlin	8	44	2182	2	carlin
carlins	9	39	2192	2	carlins
carlish	12	3	1277	2	carlish
carn	6	62	4543	2	car_n
carny	10	58	2292	2	carny
carob	9	53	2522	2	carob
carobs	10	48	1810	2	carobs
carol	7	51	2861	2	carol
caroli	8	59	1823	2	caroli
carolus	9	46	1260	2	carolus
carom	9	50	2556	2	carom
caroms	10	56	1957	2	caroms
carp	8	51	3981	2	car_p
carpals	11	34	1463	2	carpals
carpels	11	53	1546	2	carpels
carpi	9	43	1939	2	carpi
carpus	10	55	1430	2	carpus
carr	6	54	3470	2	car_r
carrels	9	51	1730	2	carrels
carry	10	58	2378	2	carry
carse	7	49	3433	2	carse
carses	8	52	3365	2	carses
cart	6	65	7034	2	car_t
carte	7	59	4042	2	carte
cartels	9	46	1812	2	cartels
cartes	8	62	3947	2	cartes
carve	10	62	2775	2	carve
carvels	12	49	1459	2	carvels
carves	11	51	2845	2	carves
casas	7	53	2784	2	casas
cases	7	50	4838	2	cases
casks	11	57	2006	2	casks
casts	7	72	3779	2	casts
casus	7	64	1925	2	casus
cates	7	59	5189	2	cates
cats	6	63	5634	2	ca_ts
caul	6	56	3000	2	caul_
cauld	8	53	1844	2	cauld
caulds	9	55	1238	2	caulds
caules	8	59	2725	2	caules
caulis	8	53	2008	2	caulis
caulk	11	53	1545	2	caulk
caulks	12	56	1186	2	caulks
caves	10	56	3970	2	caves
cavils	11	40	1439	2	cavils
caws	9	60	3611	2	ca_ws
cays	9	54	3767	2	ca_ys
ceils	7	50	1940	2	ceils
cells	7	54	2806	2	cells
cels	6	55	3497	2	c_els
ceorls	8	4	816	2	ceorls
ceres	7	55	4001	2	ceres
ceros	7	47	2607	2	ceros
charas	11	42	2361	2	charas
chards	12	51	1973	2	chards
chares	11	56	3180	2	chares
charks	15	52	1970	2	charks
charms	13	52	1884	2	charms
charrs	11	52	1919	2	charrs
chars	10	59	3664	2	char_s
charts	11	58	2309	2	charts
churls	11	54	1107	2	churls
cires	7	49	3291	2	cires
claros	8	40	1511	2	claros
coals	7	61	2960	2	coals
coils	7	50	3008	2	coils
cols	6	65	5308	2	c_ols
cools	7	56	3263	2	cools
corals	8	53	2514	2	corals
cords	8	60	3062	2	cords
cores	7	63	6185	2	cores
corks	11	60	2827	2	corks
corms	9	56	2622	2	corms
corns	7	60	3476	2	corns
corps	9	59	2704	2	corps
cors	6	66	5644	2	cor_s
cowls	10	69	2221	2	cowls
craals	8	41	1330	2	craals
crabs	9	54	2139	2	crabs
crags	8	56	2257	2	crags
crams	9	62	2915	2	crams
craps	9	53	2864	2	craps
crass	7	63	2804	2	crass
crawls	11	47	1208	2	crawls
craws	10	57	2312	2	craws
cris	6	62	3343	2	c_ris
crus	6	58	2848	2	c_rus
culls	7	54	2581	2	culls
curbs	9	48	2165	2	curbs
curds	8	57	2561	2	curds
cures	7	56	4543	2	cures
curfs	10	51	2214	2	curfs
curl	6	60	3505	2	curl_
curly	10	53	2123	2	curly
curns	7	49	2428	2	curns
currs	7	56	2439	2	currs
curs	6	56	4554	2	cur_s
czars	16	48	1291	2	czar_s
dahls	9	50	1228	2	dahls
dals	5	71	4512	2	da_ls
darbs	8	53	2326	2	darbs
dares	6	61	4670	2	dares
darks	10	67	2787	2	darks
darns	6	69	2789	2	darns
darts	6	76	3573	2	darts
dirls	6	47	2050	2	dirls
earl	4	58	3814	2	earl_
early	8	53	2412	2	early
earns	5	59	2756	2	earns
ears	4	63	5659	2	ear_s
fails	8	56	3148	2	fails
falls	8	57	2765	2	falls
fards	9	66	2984	2	fards
fares	8	58	5287	2	fares
farl	7	63	3855	2	farl_
farle	8	69	2924	2	farle
farles	9	60	2578	2	farles
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
furls	8	53	2205	2	furls
galls	6	47	2932	2	galls
gals	5	79	4650	2	ga_ls
gaols	6	67	1757	2	gaols
garbs	8	63	2141	2	garbs
gars	5	57	5074	2	gar_s
girls	6	45	1839	2	girls
gnarls	7	42	1077	2	gnarls
hails	8	52	3164	2	hails
halls	8	56	3378	2	halls
hards	9	64	3565	2	hards
hares	8	62	5554	2	hares
harks	12	63	3343	2	harks
harl	7	57	4000	2	harl_
harms	10	68	2901	2	harms
harps	10	59	2687	2	harps
harts	8	84	4159	2	harts
hauls	8	61	2373	2	hauls
herls	8	52	2643	2	herls
hurls	8	65	2271	2	hurls
jails	12	54	2294	2	jails
jarl	11	58	2813	2	jarl_
jars	11	73	3835	2	jar_s
kails	9	55	2521	2	kails
karns	9	66	2414	2	karns
karts	9	76	3011	2	karts
lalls	5	53	2413	2	lalls
lards	6	53	3186	2	lards
lares	5	48	5263	2	lares
laris	5	47	3746	2	laris
larks	9	52	2781	2	larks
lars	4	69	5657	2	lar_s
mails	7	60	3778	2	mails
malls	7	62	3343	2	malls
maras	7	54	4329	2	maras
marcs	9	57	2662	2	marcs
mares	7	64	5763	2	mares
marks	11	59	3348	2	marks
marl	6	63	4162	2	marl_
marly	10	69	2561	2	marly
mars	6	62	6187	2	mar_s
marts	7	74	4223	2	marts
mauls	7	65	2495	2	mauls
merls	7	74	2390	2	merls
nails	5	57	3040	2	nails
narcs	7	61	2202	2	narcs
nards	6	59	2846	2	nards
nares	5	55	4415	2	nares
naris	5	57	3529	2	naris
narks	9	60	2603	2	narks
nurls	5	55	1968	2	nurls
oars	4	68	4603	2	oar_s
orals	5	58	2648	2	orals
pails	7	58	3306	2	pails
palls	7	43	3256	2	palls
pals	6	69	5135	2	pa_ls
paras	7	61	4304	2	paras
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
paris	7	51	4594	2	paris
parks	11	61	3446	2	parks
parle	7	58	3616	2	parle
parles	8	63	3440	2	parles
parols	8	47	2261	2	parols
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	par_s
parts	7	77	4337	2	parts
pawls	10	56	1766	2	pawls
pearls	8	47	1539	2	pearls
purls	7	47	2335	2	purls
rails	5	59	3740	2	rails
rares	5	52	4744	2	rares
sails	5	57	3810	2	sails
sals	4	68	5167	2	sa_ls
sards	6	47	3618	2	sards
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
sauls	5	51	2812	2	sauls
scalls	8	42	1820	2	scalls
scares	8	50	3300	2	scares
scarfs	11	47	1468	2	scarfs
scarps	10	47	1860	2	scarps
scars	7	54	3353	2	scar_s
scarts	8	53	2149	2	scarts
snarls	6	40	1687	2	snarls
taels	5	68	2207	2	taels
tails	5	56	3419	2	tails
talls	5	51	3343	2	talls
tares	5	74	5656	2	tares
tarns	5	64	3395	2	tarns
taros	5	56	4082	2	taros
tarps	7	65	2712	2	tarps
tars	4	67	6395	2	tar_s
tarts	5	72	4202	2	tarts
tirls	5	45	1980	2	tirls
vails	8	58	2593	2	vails
varas	8	60	2819	2	varas
vars	7	57	4207	2	var_s
varus	8	59	2118	2	varus
virls	8	56	1860	2	virls
wails	8	66	3148	2	wails
walls	8	55	2938	2	walls
wards	9	77	3440	2	wards
wares	8	82	5058	2	wares
warks	12	79	3240	2	warks
warms	10	77	2685	2	warms
warns	8	72	3100	2	warns
warps	10	71	2642	2	warps
wars	7	86	5980	2	war_s
warts	8	148	4040	2	warts
wauls	8	61	2055	2	wauls
wawls	11	54	1647	2	wawls
yards	9	53	2461	2	yards
yarns	8	56	2179	2	yarns
yawls	11	46	1360	2	yawls
zarfs	17	47	1362	2	zarfs

Search took 3 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	53800	0.360	496363.9
2	DLD Change Limit	53800	361	1.720	31279.1
3	Display Results	361	361	0.093	3881.7
	(SQL Overall)	178691	361	2.173	82232.4