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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

79 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
duiker	11	41	1059	(None)
daiker	11	51	1303	1	daiker
diker	10	55	2455	1	d_iker
ducker	13	43	1799	1	ducker
duikers	12	36	938	1	duikers
dunker	11	36	1646	1	dunker
biker	11	60	2256	2	_biker
bucker	14	54	2046	2	bucker
bunker	12	45	1937	2	bunker
burker	12	52	2117	2	burker
busker	12	55	1783	2	busker
dacker	13	49	2075	2	dacker
daikers	12	40	1031	2	daikers
danker	11	43	1966	2	danker
darker	11	47	1869	2	darker
decker	13	52	1599	2	decker
deicer	9	41	1441	2	deicer
dicer	8	54	2642	2	d_icer
dicker	13	45	2140	2	dicker
dike	9	59	3576	2	d_ike_
diked	11	50	2468	2	d_iked
dikers	11	44	1879	2	d_ikers
dikes	10	58	3133	2	d_ikes
dikey	13	51	1642	2	d_ikey
dimer	8	56	2560	2	d_imer
diner	6	56	3290	2	d_iner
direr	6	49	2707	2	d_irer
diver	9	48	2780	2	d_iver
docker	13	44	1765	2	docker
drier	6	44	2396	2	dri_er
drinker	12	34	948	2	drinker
driver	10	47	1449	2	driver
drunker	12	32	663	2	drunker
dubber	11	38	1455	2	dubber
ducked	14	47	1801	2	ducked
duckers	14	32	1471	2	duckers
duckier	14	39	1179	2	duckier
dueler	7	42	1368	2	dueler
duffer	13	47	1166	2	duffer
duke	9	56	2810	2	du_ke_
duked	11	52	1846	2	du_ked
dukes	10	50	2347	2	du_kes
duller	7	40	1770	2	duller
dumber	11	44	1417	2	dumber
dumper	11	46	1521	2	dumper
dunked	12	43	1528	2	dunked
dunkers	12	35	1219	2	dunkers
dunner	7	39	1382	2	dunner
duper	8	55	1900	2	du_per
dusked	12	41	1251	2	dusked
duskier	12	40	943	2	duskier
duster	7	49	1972	2	duster
fucker	15	34	1442	2	fucker
funker	13	39	1576	2	funker
guider	8	43	1352	2	guider
hiker	12	51	1939	2	_hiker
hunker	13	39	1767	2	hunker
husker	13	42	1270	2	husker
juicer	15	3	628	2	juicer
junker	17	42	1365	2	junker
liker	9	56	2706	2	_liker
lunker	10	47	1834	2	lunker
lurker	10	36	1329	2	lurker
mucker	14	38	1639	2	mucker
murker	12	37	1524	2	murker
piker	11	56	2284	2	_piker
pucker	14	38	1763	2	pucker
punker	12	37	1882	2	punker
quaker	19	38	1162	2	quaker
quicker	22	4	702	2	quicker
quiver	18	27	874	2	quiver
ruiner	6	40	1364	2	ruiner
siker	9	53	2603	2	_siker
spiker	12	43	1566	2	spiker
sucker	12	41	2066	2	sucker
suiter	6	41	2181	2	suiter
sulker	10	40	1592	2	sulker
tucker	12	43	1695	2	tucker
tusker	10	42	1219	2	tusker

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.343	520965.0
2	DLD Change Limit	82551	79	2.546	32423.8
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	2.905	61511.5