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

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

225 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
lanker	10	41	2300	(None)
banker	12	42	2273	1	banker
blanker	13	46	1202	1	blanker
canker	12	44	2252	1	canker
danker	11	43	1966	1	danker
flanker	14	39	1129	1	flanker
hanker	13	46	2209	1	hanker
lacker	12	53	2562	1	lacker
laker	9	54	3287	1	la_ker
lancer	8	43	1997	1	lancer
lander	7	40	2848	1	lander
lankier	11	37	1163	1	lankier
lanner	6	49	2060	1	lanner
larker	10	45	1924	1	larker
linker	10	43	2147	1	linker
lunker	10	47	1834	1	lunker
ranker	10	50	2190	1	ranker
tanker	10	45	2112	1	tanker
wanker	13	42	1997	1	wanker
anger	6	62	2587	2	_anger
asker	9	64	1878	2	_asker
backer	14	45	2552	2	backer
baker	11	56	2954	2	ba_ker
balker	12	45	1916	2	balker
bander	9	39	2822	2	bander
banger	9	44	2363	2	banger
banked	13	50	2144	2	banked
bankers	13	39	1909	2	bankers
banner	8	44	2150	2	banner
banter	8	48	2533	2	banter
barker	12	48	2286	2	barker
blacker	15	45	1351	2	blacker
blander	10	37	1516	2	blander
blanked	14	40	1122	2	blanked
blanket	13	43	1309	2	blanket
blinker	13	41	1021	2	blinker
bunker	12	45	1937	2	bunker
calker	12	49	1708	2	calker
cancer	10	42	2092	2	cancer
caner	7	53	3477	2	can_er
cankers	13	44	1875	2	cankers
canner	8	46	2598	2	canner
canoer	8	51	2107	2	canoer
canter	8	52	3011	2	canter
clacker	15	38	1377	2	clacker
clanger	10	41	1349	2	clanger
clanked	14	38	1225	2	clanked
clankier	14	32	708	2	clankier
clinker	13	38	1166	2	clinker
clunker	13	41	945	2	clunker
conker	12	47	2155	2	conker
cranker	13	36	1278	2	cranker
dacker	13	49	2075	2	dacker
daiker	11	51	1303	2	daiker
dancer	9	48	1761	2	dancer
dander	8	112	2299	2	dander
danger	8	37	2282	2	danger
darker	11	47	1869	2	darker
dunker	11	36	1646	2	dunker
faker	12	48	2459	2	fa_ker
fanner	9	42	1818	2	fanner
flaker	13	49	1617	2	fla_ker
flanger	11	34	1262	2	flanger
flanked	15	37	1064	2	flanked
flanken	14	22	676	2	flanken
flankers	15	34	930	2	flankers
flunker	14	38	936	2	flunker
franker	14	35	1018	2	franker
funker	13	39	1576	2	funker
gander	8	43	2276	2	gander
ganger	8	37	2146	2	ganger
gawker	14	55	935	2	gawker
glancer	10	37	1007	2	glancer
hacker	15	48	2269	2	hacker
hander	10	45	2643	2	hander
hanger	10	40	2325	2	hanger
hanked	14	42	2060	2	hanked
hankers	14	42	1813	2	hankers
hawker	16	48	1266	2	hawker
honker	13	41	1746	2	honker
hunker	13	39	1767	2	hunker
inker	9	44	2109	2	_inker
jacker	19	44	1758	2	jacker
jinker	17	40	1354	2	jinker
junker	17	42	1365	2	junker
laager	7	43	1278	2	laager
lacer	7	58	3375	2	la_cer
lacier	8	40	2009	2	lacier
lacked	13	53	2465	2	lacked
lackers	13	41	2054	2	lackers
lackey	15	48	1335	2	lackey
ladder	8	46	1762	2	ladder
lader	6	56	3372	2	la_der
ladler	7	43	1493	2	ladler
lager	6	51	3286	2	la_ger
lagger	8	59	1983	2	lagger
lake	8	57	4160	2	la_ke_
laked	10	57	3112	2	la_ked
lakers	10	52	2515	2	la_kers
lakes	9	57	3765	2	la_kes
lakier	10	47	1627	2	lakier
lamber	10	44	1849	2	lamber
lamer	7	52	3370	2	la_mer
lance	7	51	2672	2	lance_
lanced	9	37	1772	2	lanced
lancers	9	36	1664	2	lancers
lances	8	48	2410	2	lances
lancet	8	42	2357	2	lancet
landed	8	46	1924	2	landed
landers	8	40	2621	2	landers
landler	8	41	1320	2	landler
lane	4	51	5333	2	lan_e_
lanes	5	49	4679	2	lan_es
langur	7	10	930	2	langur
lank	8	47	3445	2	lank__
lankest	11	27	1411	2	lankest
lankly	13	43	962	2	lankly
lanky	12	55	1748	2	lank_y
lanners	7	36	1833	2	lanners
lantern	7	3	1001	2	lantern
lapper	10	43	1995	2	lapper
lapser	8	41	1314	2	lapser
larder	7	37	2097	2	larder
larger	7	44	1751	2	larger
larked	11	45	1947	2	larked
larkers	11	30	1451	2	larkers
larkier	11	37	1152	2	larkier
laser	5	46	3332	2	la_ser
lasher	9	48	2453	2	lasher
laster	6	48	3063	2	laster
later	5	48	4392	2	la_ter
lather	9	51	2435	2	lather
latke	9	48	1709	2	latke_
latkes	10	47	1587	2	latkes
latter	6	50	2789	2	latter
lauder	7	38	1501	2	lauder
launder	8	30	914	2	launder
laveer	9	41	1042	2	laveer
laver	8	50	3179	2	la_ver
lawyer	12	38	697	2	lawyer
laxer	12	54	2033	2	la_xer
layer	8	46	2647	2	la_yer
lazier	15	42	1461	2	lazier
leaker	10	46	2007	2	leaker
leaner	6	40	2219	2	lean_er
lender	7	39	2127	2	lender
licker	12	52	2204	2	licker
liker	9	56	2706	2	l_iker
liner	5	59	3892	2	lin_er
linger	7	52	2600	2	linger
linier	6	44	2379	2	linier
linked	11	45	1821	2	linked
linkers	11	43	1771	2	linkers
linter	6	46	2534	2	linter
loaner	6	44	1650	2	loan_er
locker	12	40	1942	2	locker
loner	5	54	3104	2	lon_er
longer	7	58	2320	2	longer
looker	10	48	1695	2	looker
lunger	7	57	2042	2	lunger
lunier	6	46	1760	2	lunier
lunkers	11	34	1460	2	lunkers
lurker	10	36	1329	2	lurker
maker	11	41	2781	2	ma_ker
manger	9	43	2500	2	manger
manner	8	40	2051	2	manner
marker	12	44	2039	2	marker
masker	12	44	1610	2	masker
packer	14	42	2340	2	packer
pander	9	37	2552	2	pander
panier	8	44	2550	2	panier
panner	8	42	2476	2	panner
panzer	17	42	1323	2	panzer
parker	12	41	2137	2	parker
pinker	12	53	2244	2	pinker
planer	8	41	2265	2	plan_er
planked	14	35	1228	2	planked
plankter	14	3	536	2	plankter
planner	9	35	1162	2	planner
planter	9	40	1780	2	planter
plinker	13	40	1096	2	plinker
plunker	13	39	1065	2	plunker
punker	12	37	1882	2	punker
racker	12	48	2455	2	racker
raker	9	45	2979	2	ra_ker
ranger	7	39	2552	2	ranger
ranked	11	46	2074	2	ranked
rankers	11	32	1746	2	rankers
ranter	6	38	2682	2	ranter
sacker	12	51	2484	2	sacker
saker	9	51	3202	2	sa_ker
sander	7	48	2853	2	sander
saner	5	43	3432	2	san_er
sanger	7	45	2456	2	sanger
sinker	10	36	2090	2	sinker
skanker	10	26	848	2	skanker
slacker	13	39	1529	2	slacker
slaker	10	42	1927	2	sla_ker
slander	8	40	1544	2	slander
spanker	13	36	1235	2	spanker
swanker	14	36	948	2	swanker
tacker	12	42	2450	2	tacker
taker	9	52	2900	2	ta_ker
talker	10	39	1622	2	talker
tanked	11	39	1929	2	tanked
tankers	11	34	1691	2	tankers
tanner	6	37	2228	2	tanner
thanker	14	30	959	2	thanker
tinker	10	36	1992	2	tinker
vanner	9	42	1584	2	vanner
wacker	15	49	2012	2	wacker
waker	12	55	2659	2	wa_ker
walker	13	39	1399	2	walker
wander	10	44	2371	2	wander
wanier	9	39	2068	2	wanier
wanked	14	45	1715	2	wanked
wankers	14	45	1471	2	wankers
wanner	9	40	1962	2	wanner
wanter	9	44	2305	2	wanter
winker	13	42	2029	2	winker
yakker	12	40	553	2	yakker
yanked	14	43	1224	2	yanked
yonker	13	41	1085	2	yonker
zander	16	34	1711	2	zander
zanier	15	43	1471	2	zanier

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	225	2.563	32208.7
3	Display Results	225	225	0.076	2960.5
	(SQL Overall)	178691	225	2.749	65002.2