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

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

87 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
parlances	13	4	895	(None)
parlance	12	4	872	1	parlance_
balances	12	7	997	2	ba_lances
palaces	11	42	1646	2	pa_la_ces
parlante	10	3	969	2	parlante_
portances	13	4	983	2	portances
prances	11	36	1877	2	p_r_ances
valances	13	9	876	2	va_lances
variances	14	11	736	2	variances
advances	14	4	561	3	_advances
alliances	11	10	710	3	_alliances
anlaces	9	23	1373	3	_anla_ces
appliances	16	4	397	3	appliances
arranges	9	3	941	3	_arranges
atlantes	8	3	855	3	_atlantes
balance	11	5	1026	3	ba_lance_
balanced	13	5	651	3	ba_lanced
balancer	12	4	660	3	ba_lancer
balancers	13	4	506	3	ba_lancers
barrancas	13	4	509	3	barrancas
barrancos	13	4	420	3	barrancos
carlines	10	35	2166	3	carlin_es
dalliances	13	4	427	3	dalliances
durances	11	5	868	3	dur_ances
garlanded	12	4	469	3	garlanded
garlands	10	3	832	3	garlan_ds
glances	10	41	1314	3	__glances
laitances	11	4	561	3	laitances
lances	8	48	2410	3	___lances
marlines	10	38	1873	3	marlin_es
palace	10	45	1692	3	pa_la_ce_
palaced	12	41	1078	3	pa_la_ced
palates	9	36	2494	3	pa_la_tes
parables	12	16	1356	3	par_ables
parades	10	41	2146	3	par_a_des
paralyses	14	4	828	3	paralyses
paralyzes	23	4	649	3	paralyzes
parangs	10	43	1437	3	par_an_gs
paranoea	10	4	857	3	par_anoea
paranoeas	11	4	752	3	par_anoeas
paravanes	14	4	830	3	paravan_es
parbakes	16	3	834	3	parba_kes
parians	9	35	1973	3	parian__s
parkades	15	3	827	3	parka_des
parklands	16	5	471	3	parklan_ds
parlando	11	4	541	3	parlan_do
parlayed	14	3	582	3	parla_yed
parlays	12	39	1045	3	parla__ys
parles	8	63	3440	3	parl___es
partakes	14	4	992	3	parta_kes
partans	9	44	1828	3	partan__s
parvenues	14	4	464	3	parvenues
patiences	13	6	743	3	patiences
pavanes	12	36	1265	3	pa_van_es
pearlashes	15	4	326	3	pearlashes
penances	12	3	1244	3	p_enances
permeances	16	4	565	3	permeances
petulances	14	4	429	3	petulances
phalanges	15	6	536	3	phalanges
phalanxes	21	5	391	3	phalanxes
piquances	22	4	405	3	piquances
pittances	13	4	570	3	pittances
places	10	43	2370	3	p__la_ces
plaices	11	4	1114	3	p__laices
planches	15	31	1186	3	p__lanches
planes	8	50	2808	3	p__lan_es
portance	12	3	1012	3	portance_
pralines	10	22	1772	3	pralin_es
prance	10	43	1857	3	p_r_ance_
pranced	12	37	1404	3	p_r_anced
prancer	11	36	1338	3	p_r_ancer
prancers	12	32	1033	3	p_r_ancers
princes	11	30	1514	3	p_r_inces
purlines	10	35	1405	3	purlin_es
purslanes	11	4	552	3	purslan_es
pursuances	14	4	345	3	pursuances
purulences	14	4	450	3	purulences
radiances	12	4	769	3	radiances
rances	8	46	2544	3	__r_ances
tarriances	12	4	421	3	tarriances
trances	9	39	1964	3	_tr_ances
valance	12	6	925	3	va_lance_
valanced	14	7	546	3	va_lanced
valences	13	8	851	3	va_lences
valiances	14	8	720	3	valiances
variance	13	9	741	3	variance_
warplanes	14	4	589	3	warplan_es

Search took 8 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	148641	0.436	409841.7
2	DLD Change Limit	148641	87	7.266	20457.1
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	7.748	23062.9