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

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

158 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
calker	12	49	1708	(None)
balker	12	45	1916	1	balker
calked	13	46	1740	1	calked
calkers	13	44	1469	1	calkers
caller	8	51	2548	1	caller
calmer	10	52	1693	1	calmer
canker	12	44	2252	1	canker
caulker	13	45	689	1	caulker
talker	10	39	1622	1	talker
walker	13	39	1399	1	walker
alder	6	54	2191	2	_alder
alter	5	48	2850	2	_alter
asker	9	64	1878	2	_asker
backer	14	45	2552	2	backer
baker	11	56	2954	2	ba_ker
balder	9	53	1886	2	balder
baler	7	56	3527	2	bal_er
balked	13	52	1941	2	balked
balkers	13	49	1572	2	balkers
balkier	13	41	1198	2	balkier
baller	8	38	2520	2	baller
banker	12	42	2273	2	banker
barker	12	48	2286	2	barker
bilker	12	49	1344	2	bilker
caber	9	51	2683	2	ca_ber
cabler	10	45	1917	2	cabler
cackler	15	38	1257	2	cackler
cadger	10	50	1391	2	cadger
cager	8	52	2922	2	ca_ger
cagier	9	37	1593	2	cagier
cahier	11	36	1577	2	cahier
cake	10	54	3996	2	ca_ke_
caked	12	61	2862	2	ca_ked
cakes	11	60	3767	2	ca_kes
cakey	14	55	1727	2	ca_key
cakier	12	31	1524	2	cakier
calcar	10	3	1275	2	calcar
calces	10	44	2005	2	calces
caldera	10	3	796	2	caldera
caliber	11	3	973	2	caliber
caliper	11	4	1096	2	caliper
calk	10	55	2766	2	calk__
calkin	12	35	1549	2	calkin
calks	11	54	2160	2	calk_s
called	9	41	2673	2	called
callee	8	43	2729	2	callee
callers	9	42	2196	2	callers
callet	8	45	3676	2	callet
calmed	11	48	1638	2	calmed
caloyer	12	3	814	2	caloyer
calve	10	59	1992	2	calve_
calved	12	52	1545	2	calved
calves	11	51	1928	2	calves
calxes	15	41	1303	2	calxes
camber	12	44	1848	2	camber
camper	12	47	2221	2	camper
cancer	10	42	2092	2	cancer
caner	7	53	3477	2	ca_ner
cankers	13	44	1875	2	cankers
canner	8	46	2598	2	canner
canoer	8	51	2107	2	canoer
canter	8	52	3011	2	canter
caper	9	48	3162	2	ca_per
capper	12	44	2198	2	capper
carder	9	45	2418	2	carder
career	8	58	2224	2	career
carer	7	49	4233	2	ca_rer
carked	13	40	2482	2	carked
carper	10	49	2363	2	carper
carter	8	49	3227	2	carter
carver	11	44	2015	2	carver
casked	13	48	1551	2	casked
casket	12	48	2099	2	casket
caster	8	52	3257	2	caster
cater	7	48	4072	2	ca_ter
caulked	14	48	667	2	caulked
caulkers	14	37	565	2	caulkers
causer	8	41	1778	2	causer
caver	10	56	2906	2	ca_ver
chalked	17	44	986	2	chalked
chalkier	17	3	675	2	chalkier
choker	15	43	1437	2	choker
clacker	15	38	1377	2	clacker
claver	11	38	1697	2	claver
clawer	11	45	1278	2	clawer
coaler	8	41	2171	2	coal_er
coalier	9	34	1618	2	coalier
cocker	14	43	2039	2	cocker
colder	9	51	2185	2	colder
colter	8	46	2509	2	colter
conker	12	47	2155	2	conker
cooker	12	47	2245	2	cooker
corker	12	47	2085	2	corker
cracker	15	31	1417	2	cracker
cranker	13	36	1279	2	cranker
culler	8	43	2225	2	culler
culver	11	30	1063	2	culver
dacker	13	49	2075	2	dacker
daiker	11	51	1303	2	daiker
danker	11	43	1966	2	danker
darker	11	47	1869	2	darker
faker	12	48	2459	2	fa_ker
faller	9	46	2123	2	faller
falser	9	39	1241	2	falser
falter	9	45	1905	2	falter
flaker	13	49	1617	2	flaker
gawker	14	55	935	2	gawker
hacker	15	48	2269	2	hacker
haler	8	50	3352	2	hal_er
halter	9	44	2088	2	halter
hanker	13	46	2209	2	hanker
hawker	16	48	1266	2	hawker
jacker	19	44	1758	2	jacker
lacker	12	53	2562	2	lacker
laker	9	54	3287	2	la_ker
lanker	10	41	2300	2	lanker
larker	10	45	1924	2	larker
maker	11	41	2781	2	ma_ker
marker	12	44	2039	2	marker
masker	12	44	1610	2	masker
milker	12	48	1432	2	milker
packer	14	42	2340	2	packer
paler	7	54	3693	2	pal_er
palier	8	50	2356	2	palier
palmer	10	58	1654	2	palmer
palter	8	44	2326	2	palter
parker	12	41	2137	2	parker
racker	12	48	2455	2	racker
raker	9	45	2979	2	ra_ker
ranker	10	50	2190	2	ranker
sacker	12	51	2484	2	sacker
saker	9	51	3202	2	sa_ker
salter	6	43	2508	2	salter
salver	9	46	1775	2	salver
scaler	8	43	2160	2	scal_er
scalier	9	43	1691	2	scalier
scalper	11	39	1292	2	scalper
sculker	13	31	832	2	sculker
slaker	10	42	1927	2	slaker
stalker	11	39	1225	2	stalker
sulker	10	40	1592	2	sulker
tacker	12	42	2450	2	tacker
taker	9	52	2900	2	ta_ker
taler	5	60	3486	2	tal_er
talked	11	40	1540	2	talked
talkers	11	35	1321	2	talkers
talkier	11	40	1184	2	talkier
taller	6	37	2196	2	taller
tanker	10	45	2112	2	tanker
valkyr	16	3	240	2	valkyr
valuer	9	39	1144	2	valuer
wacker	15	49	2012	2	wacker
waker	12	55	2659	2	wa_ker
waler	8	42	2926	2	wal_er
walked	14	53	1378	2	walked
walkers	14	34	1147	2	walkers
wanker	13	42	1997	2	wanker
yakker	12	40	553	2	yakker

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.330	541487.9
2	DLD Change Limit	82551	158	2.606	31677.3
3	Display Results	158	158	0.046	3434.8
	(SQL Overall)	178691	158	2.982	59923.2