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

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

310 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
carers	8	51	3396	(None)
cabers	10	50	2392	1	cabers
cagers	9	56	2419	1	cagers
caners	8	46	2920	1	caners
capers	10	54	2814	1	capers
carders	10	48	2035	1	carders
careers	9	52	1878	1	careers
carer	7	49	4233	1	carer_
cares	7	73	6918	1	care_s
caress	8	57	2026	1	caress
carets	8	53	3077	1	carets
carpers	11	45	2125	1	carpers
carrs	7	57	3085	1	car_rs
carters	9	53	2725	1	carters
carvers	12	48	1754	1	carvers
caters	8	53	3650	1	caters
cavers	11	50	2684	1	cavers
corers	8	52	3107	1	corers
curers	8	49	2319	1	curers
darers	7	59	2187	1	darers
farers	9	59	2405	1	farers
parers	8	55	3074	1	parers
scarers	9	46	1851	1	scarers
acres	7	63	2776	2	acre_s
agers	6	50	2785	2	_agers
airers	6	49	2231	2	airers
apers	7	66	2913	2	_apers
areas	5	59	3577	2	_areas
ares	4	58	7102	2	_are_s
armers	8	55	2027	2	_armers
avers	8	51	2731	2	_avers
bakers	12	53	2345	2	bakers
balers	8	56	2693	2	balers
barbers	11	43	1750	2	barbers
barer	7	45	3580	2	barer_
bares	7	54	5713	2	bare_s
barkers	13	43	1851	2	barkers
barres	8	44	2754	2	barres
barters	9	42	2303	2	barters
bearers	9	46	1959	2	bearers
borers	8	51	2268	2	borers
caber	9	51	2683	2	caber_
cablers	11	44	1671	2	cablers
cades	8	54	4073	2	cade_s
cadets	9	63	1651	2	cadets
cadgers	11	47	1200	2	cadgers
cadres	9	40	1793	2	cadre_s
cafes	10	64	2692	2	cafe_s
cager	8	52	2922	2	cager_
cages	8	59	3601	2	cage_s
cahiers	12	35	1067	2	cahiers
cakes	11	60	3767	2	cake_s
calkers	13	44	1469	2	calkers
callers	9	42	2196	2	callers
cambers	13	40	1744	2	cambers
camels	10	52	1708	2	camels
cameos	10	58	1800	2	cameos
camera	10	3	1369	2	camera
cameras	11	3	1336	2	cameras
cames	9	70	4731	2	came_s
campers	13	42	2029	2	campers
cancers	11	40	1858	2	cancers
caner	7	53	3477	2	caner_
canes	7	53	5037	2	cane_s
cankers	13	44	1875	2	cankers
canners	9	38	2266	2	canners
canoers	9	43	1837	2	canoers
canters	9	48	2773	2	canters
caper	9	48	3162	2	caper_
caperers	12	26	1172	2	caperers
capes	9	54	4192	2	cape_s
cappers	13	44	1940	2	cappers
carats	8	59	2902	2	carats
carbos	10	51	2226	2	carbos
carbs	9	60	3146	2	car_bs
carcels	11	45	1606	2	carcels
carder	9	45	2418	2	carder_
cards	8	51	3793	2	car_ds
care	6	69	6837	2	care__
cared	8	60	5009	2	care_d
careen	8	41	1949	2	careen
careens	9	45	1470	2	careens
career	8	58	2224	2	career
caret	7	53	6056	2	care_t
carex	14	48	2230	2	care_x
cargos	9	46	1918	2	cargos
caries	8	51	4762	2	caries
carks	11	55	3421	2	car_ks
carles	8	54	3508	2	carles
carless	9	51	1849	2	carless
carls	7	70	3742	2	car_ls
carnets	9	39	1840	2	carnets
carneys	12	43	1054	2	carneys
carns	7	59	3756	2	car_ns
carobs	10	48	1810	2	carobs
carolers	10	33	1417	2	carolers
carols	8	51	2498	2	carols
caroms	10	56	1957	2	caroms
carpels	11	53	1546	2	carpels
carper	10	49	2363	2	carper_
carpets	11	39	1533	2	carpets
carps	9	69	3225	2	car_ps
carpus	10	55	1430	2	carpus
carr	6	54	3470	2	car_r_
carrel	8	47	1863	2	carrel
carrels	9	51	1730	2	carrels
carriers	10	36	1420	2	carriers
carry	10	58	2378	2	car_ry
cars	6	73	6476	2	ca__rs
carses	8	52	3365	2	carses
cartels	9	46	1812	2	cartels
carter	8	49	3227	2	carter_
cartes	8	62	3947	2	cartes
carts	7	89	4629	2	car_ts
carvels	12	49	1459	2	carvels
carver	11	44	2015	2	carver_
carves	11	51	2845	2	carves
casern	8	47	1331	2	casern
caserns	9	47	1122	2	caserns
cases	7	50	4838	2	case_s
casters	9	47	2990	2	casters
cater	7	48	4072	2	cater_
caterers	10	28	1440	2	caterers
cates	7	59	5189	2	cate_s
causers	9	40	1479	2	causers
caver	10	56	2906	2	caver_
cavern	11	53	1245	2	cavern
caverns	12	45	1025	2	caverns
caves	10	56	3970	2	cave_s
ceders	9	38	1767	2	ceders
ceres	7	55	4001	2	cere_s
cereus	8	52	1552	2	cereus
chafers	15	45	1274	2	chafers
chares	11	56	3180	2	chare_s
chargers	14	40	1132	2	chargers
charmers	15	42	1133	2	charmers
charrs	11	52	1919	2	char_rs
charters	13	41	1558	2	charters
chasers	12	37	1492	2	chasers
chawers	15	44	1205	2	chawers
cheers	11	45	1891	2	cheers
ciders	9	46	2009	2	ciders
cires	7	49	3291	2	cire_s
citers	8	50	2298	2	citers
clarets	9	41	1110	2	clarets
clavers	12	43	1490	2	clavers
clawers	12	39	1097	2	clawers
clearers	10	34	930	2	clearers
coalers	9	44	1935	2	coalers
coaters	9	35	2579	2	coaters
coaxers	16	43	1108	2	coaxers
coders	9	54	2698	2	coders
comers	10	53	2808	2	comers
cooers	8	43	2456	2	cooers
copers	10	46	2984	2	copers
corders	10	45	2088	2	corders
corer	7	55	3887	2	corer_
cores	7	63	6185	2	core_s
corkers	13	41	1885	2	corkers
corners	9	47	2331	2	corners
covers	11	46	2796	2	covers
cowers	11	46	2553	2	cowers
craters	9	50	2189	2	craters
cravers	12	44	1656	2	cravers
creds	8	54	1877	2	c_reds
cress	7	50	2283	2	c_ress
crews	10	59	1750	2	c_rews
criers	8	39	1858	2	criers
cubers	10	53	1835	2	cubers
curbers	11	55	1438	2	curbers
curer	7	50	3075	2	curer_
cures	7	56	4543	2	cure_s
curets	8	49	2234	2	curets
curlers	9	42	1807	2	curlers
currs	7	56	2439	2	cur_rs
cursers	9	43	1716	2	cursers
cyders	12	39	883	2	cyders
darer	6	52	3079	2	darer_
dares	6	61	4670	2	dare_s
darners	8	38	1577	2	darners
darters	8	40	1760	2	darters
daters	7	48	2737	2	daters
eagers	7	45	2368	2	eagers
earners	7	40	1645	2	earners
eaters	6	55	3595	2	eaters
facers	11	55	1944	2	facers
faders	10	51	1746	2	faders
fakers	13	42	1953	2	fakers
farcers	12	47	1344	2	farcers
farer	8	67	3314	2	farer_
fares	8	58	5287	2	fare_s
farmers	12	43	1526	2	farmers
fearers	10	48	1527	2	fearers
firers	9	49	2268	2	firers
gagers	8	40	2133	2	gagers
gamers	9	44	2083	2	gamers
gapers	9	45	2047	2	gapers
garners	8	38	1598	2	garners
garters	8	42	1823	2	garters
gaters	7	47	2864	2	gaters
gazers	16	45	1630	2	gazers
halers	9	49	2691	2	halers
harems	11	55	1382	2	harems
hares	8	62	5554	2	hare_s
harmers	12	41	1659	2	harmers
harpers	12	49	1620	2	harpers
haters	9	49	3040	2	haters
havers	12	47	2148	2	havers
hayers	12	44	1594	2	hayers
hazers	18	46	1595	2	hazers
hearers	10	43	1978	2	hearers
hirers	9	45	1806	2	hirers
jagers	14	44	1572	2	jagers
japers	15	46	1617	2	japers
lacers	8	52	2525	2	lacers
laders	7	49	2776	2	laders
lagers	7	48	2614	2	lagers
lakers	10	52	2515	2	lakers
larders	8	35	1694	2	larders
larees	6	53	2311	2	larees
lares	5	48	5263	2	lare_s
larkers	11	30	1451	2	larkers
lasers	6	49	2570	2	lasers
lavers	9	45	2636	2	lavers
layers	9	39	2118	2	layers
lurers	6	42	1749	2	lurers
macers	10	53	2127	2	macers
makers	12	39	2173	2	makers
mares	7	64	5763	2	mare_s
markers	13	35	1610	2	markers
marrers	9	34	1431	2	marrers
masers	8	46	2345	2	masers
maters	8	50	3239	2	maters
mazers	17	39	1709	2	mazers
namers	8	45	1733	2	namers
nares	5	55	4415	2	nare_s
oaters	6	50	2979	2	oaters
pacers	10	51	2454	2	pacers
pagers	9	44	2325	2	pagers
papers	10	51	2532	2	papers
pareos	8	70	2377	2	pareos
parer	7	58	3990	2	parer_
pares	7	71	6448	2	pare_s
pareus	8	54	2074	2	pareus
parkers	13	38	1687	2	parkers
parrs	7	59	2867	2	par_rs
parsers	9	41	1815	2	parsers
paters	8	49	3583	2	paters
pavers	11	50	2182	2	pavers
pawers	11	48	1878	2	pawers
payers	11	46	2182	2	payers
racers	8	47	2543	2	racers
rakers	10	41	2357	2	rakers
rapers	8	43	2718	2	rapers
rarer	5	47	3170	2	rarer_
rares	5	52	4744	2	rare_s
rasers	6	45	2678	2	rasers
raters	6	39	3658	2	raters
ravers	9	46	2818	2	ravers
razers	15	49	1961	2	razers
rearers	7	43	2356	2	rearers
roarers	7	38	1274	2	roarers
sabers	8	52	2473	2	sabers
sakers	10	41	2543	2	sakers
sarees	6	53	2994	2	sarees
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sayers	9	42	2159	2	sayers
scalers	9	38	1726	2	scalers
scarer	8	45	2461	2	scarer_
scares	8	50	3300	2	scare_s
scarfers	13	40	846	2	scarfers
scarpers	12	47	1251	2	scarpers
scorers	9	41	1532	2	scorers
sharers	10	47	2062	2	sharers
snarers	7	42	1666	2	snarers
soarers	7	41	1809	2	soarers
sparers	9	45	1961	2	sparers
starers	7	45	2231	2	starers
tabers	8	46	2157	2	tabers
takers	10	39	2374	2	takers
talers	6	46	2814	2	talers
tamers	8	42	2403	2	tamers
tapers	8	40	2581	2	tapers
tares	5	74	5656	2	tare_s
tarres	6	47	2304	2	tarres
taters	6	49	3220	2	taters
tawers	9	41	1860	2	tawers
taxers	13	40	1528	2	taxers
tearers	7	52	1823	2	tearers
variers	10	37	1266	2	variers
waders	10	91	2064	2	waders
wafers	12	43	1614	2	wafers
wagers	10	51	2220	2	wagers
wakers	13	48	2249	2	wakers
walers	9	48	2446	2	walers
warders	11	34	1681	2	warders
wares	8	82	5058	2	ware_s
warmers	12	45	1429	2	warmers
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
waters	9	50	3063	2	waters
wavers	12	50	2247	2	wavers
waxers	16	40	1430	2	waxers
wearers	10	46	1590	2	wearers
wirers	9	46	1789	2	wirers
yagers	10	51	1453	2	yagers
yarders	11	32	1159	2	yarders
yarer	8	43	2157	2	yarer_
yarners	10	43	1220	2	yarners

Search took 4 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	82551	0.343	520965.0
2	DLD Change Limit	82551	310	3.093	26689.6
3	Display Results	310	310	0.093	3333.3
	(SQL Overall)	178691	310	3.529	50635.0