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

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

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.

55 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
phalange	14	6	519	(None)
phalanger	15	5	411	1	phalanger
phalanges	15	6	536	1	phalanges
phalangal	15	5	247	2	phalangal
phalangeal	16	5	221	2	phalangeal
phalangers	16	7	376	2	phalangers
phalanx	19	4	520	2	phalan_x
phalanxes	21	5	391	2	phalanxes
alane	5	61	3561	3	__alan_e
alang	6	60	2351	3	__alang_
balance	11	5	1026	3	_balance
chalazae	22	4	442	3	chalazae
challenge	15	4	362	3	challenge
chalone	12	3	1210	3	chalon_e
change	12	41	1675	3	ch__ange
flange	10	34	1197	3	__flange
galanga	9	3	601	3	_galanga
haling	10	42	2978	3	_haling_
harangue	12	4	410	3	_harangue
haulage	11	3	691	3	_haula_ge
haylage	14	3	644	3	_hayla_ge
malanga	10	3	666	3	_malanga
melange	10	3	836	3	_melange
palace	10	45	1691	3	p_ala_ce
palate	8	42	2678	3	p_ala_te
paling	9	35	3013	3	p_aling_
palings	10	39	1582	3	p_alings
parang	9	37	1551	3	p_arang_
parangs	10	43	1437	3	p_arangs
parlance	12	4	872	3	parlance
parlante	10	3	969	3	parlante
pavane	11	41	1344	3	p_avan_e
pawnage	13	3	587	3	p_awnage
pealing	10	41	2320	3	pealing_
pelage	9	5	1536	3	p_ela_ge
phage	11	51	1367	3	ph__a_ge
phalarope	16	5	380	3	phalarope
pharynges	18	4	288	3	pharynges
phasing	13	32	1167	3	phasing_
philabeg	16	4	231	3	philabeg
philander	15	4	406	3	philander
phylae	14	45	873	3	phyla__e
phytane	15	4	544	3	phytan_e
pillage	10	34	1260	3	pilla_ge
plage	8	45	2040	3	p__la_ge
plane	7	49	2914	3	p__lan_e
platane	9	31	1230	3	platan_e
plunge	9	38	1105	3	p__lunge
praline	9	30	1974	3	pralin_e
prolonge	11	38	840	3	prolonge
scalage	10	31	1053	3	scala_ge
thanage	11	11	794	3	thana_ge
valance	12	6	925	3	_valance
whaling	14	39	1077	3	whaling_
whalings	15	25	676	3	whalings

Search took 7 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	146162	0.420	425454.8
2	DLD Change Limit	146162	55	6.296	23215.1
3	Display Results	55	55	0.016	3437.5
	(SQL Overall)	178691	55	6.732	26543.5