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

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

95 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
blanker	13	46	1202	(None)
banker	12	42	2273	1	b_anker
blacker	15	45	1351	1	blacker
blander	10	37	1516	1	blander
blanked	14	40	1122	1	blanked
blanket	13	43	1309	1	blanket
blinker	13	41	1021	1	blinker
flanker	14	39	1129	1	flanker
lanker	10	41	2300	1	_lanker
backer	14	45	2552	2	b_acker
baker	11	56	2954	2	b_a_ker
balancer	12	4	660	2	balancer
balker	12	45	1916	2	b_alker
bander	9	39	2822	2	b_ander
banger	9	44	2363	2	b_anger
banked	13	50	2144	2	b_anked
bankers	13	39	1909	2	b_ankers
banner	8	44	2150	2	b_anner
banter	8	48	2533	2	b_anter
barker	12	48	2286	2	b_arker
beaker	12	55	2069	2	bea_ker
bilander	11	3	667	2	bilander
blabber	10	41	892	2	blabber
blacked	16	36	1337	2	blacked
blacken	15	43	979	2	blacken
bladder	11	42	915	2	bladder
blader	9	36	1858	2	bla_der
blamer	10	44	1714	2	bla_mer
blancher	15	33	863	2	blancher
blank	11	54	1855	2	blank__
blankest	14	43	906	2	blankest
blankets	14	35	650	2	blankets
blankly	16	3	426	2	blankly
blanks	12	41	1289	2	blank_s
blaster	9	40	1730	2	blaster
blather	12	53	1420	2	blather
blatter	9	44	1565	2	blatter
blazer	17	44	1402	2	bla_zer
bleaker	13	35	1053	2	bleaker
blender	10	46	1384	2	blender
blinder	10	39	1298	2	blinder
blinked	14	40	1001	2	blinked
blinkers	14	38	850	2	blinkers
blocker	15	41	992	2	blocker
blonder	10	40	1194	2	blonder
blunder	10	38	1315	2	blunder
blunger	10	41	1201	2	blunger
blunter	9	45	1203	2	blunter
brander	10	39	1582	2	brander
branner	9	42	1237	2	branner
bunker	12	45	1937	2	b_unker
canker	12	44	2252	2	_canker
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
cranker	13	36	1278	2	cranker
danker	11	43	1966	2	_danker
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
glancer	10	37	1007	2	glancer
hanker	13	46	2209	2	_hanker
lacker	12	53	2562	2	_lacker
laker	9	54	3287	2	_la_ker
lancer	8	43	1997	2	_lancer
lander	7	40	2848	2	_lander
lankier	11	37	1163	2	_lankier
lanner	6	49	2060	2	_lanner
larker	10	45	1924	2	_larker
linker	10	43	2147	2	_linker
lunker	10	47	1834	2	_lunker
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
ranker	10	50	2190	2	_ranker
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
tanker	10	45	2112	2	_tanker
thanker	14	30	959	2	thanker
wanker	13	42	1997	2	_wanker

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	107671	0.356	501941.0
2	DLD Change Limit	107671	95	3.313	32499.5
3	Display Results	95	95	0.033	2878.8
	(SQL Overall)	178691	95	3.702	48268.8