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

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

65 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
pittance	12	4	611	(None)
pittances	13	4	570	1	pittances
distance	11	3	1185	2	distance
emittance	13	4	386	2	emittance
piquance	21	4	421	2	piquance
portance	12	3	1012	2	portance
quittance	20	4	354	2	quittance
acutance	12	4	630	3	acutance
admittance	15	5	239	3	admittance
distanced	13	4	857	3	distanced
distances	12	3	1165	3	distances
dittanies	10	4	573	3	dittanies
dittany	11	3	565	3	dittan_y
emittances	14	4	382	3	emittances
entrance	10	3	1133	3	entrance
fiance	11	3	1074	3	fi__ance
finance	12	3	857	3	fi_nance
fittable	13	3	709	3	fittable
hittable	13	3	685	3	hittable
immittance	16	5	263	3	immittance
instance	10	4	988	3	instance
iterance	10	4	952	3	_iterance
laitance	10	4	597	3	laitance
militance	13	4	611	3	militance
outdance	11	23	873	3	outdance
outrance	10	22	1278	3	outrance
parlance	12	4	872	3	parlance
patience	12	4	752	3	patience
penance	11	3	1344	3	p_enance
pentane	9	4	1574	3	pentan_e
pettable	12	17	1071	3	pettable
petulance	13	5	451	3	petulance
phytane	15	4	544	3	phytan_e
picante	11	3	1052	3	pi_cante
pinnace	11	35	1031	3	pinna_ce
pintano	9	9	899	3	pintan_o
pintanos	10	10	755	3	pintanos
piquances	22	4	405	3	piquances
piquancy	24	4	297	3	piquancy
pistache	15	4	589	3	pistache
pitiable	12	3	829	3	pitiable
pitman	10	24	1212	3	pitman__
pitmans	11	18	874	3	pitman_s
pitta	7	50	1869	3	pitta___
pittas	8	60	1452	3	pitta__s
pitting	10	36	1887	3	pittin_g
pittings	11	34	912	3	pittings
platane	9	31	1230	3	platan_e
poignance	14	4	359	3	poignance
portances	13	4	983	3	portances
potence	11	7	1136	3	p_otence
pottage	10	33	1060	3	potta_ge
prance	10	43	1857	3	p__rance
pretence	12	23	1212	3	pretence
pristane	10	3	1034	3	pristan_e
puissance	13	4	378	3	puissance
quittances	21	4	320	3	quittances
remittance	14	4	445	3	remittance
riddance	12	4	397	3	riddance
sithence	13	4	479	3	sithence
stance	8	43	1691	3	__stance
trance	8	47	1876	3	__trance
vibrance	15	4	585	3	vibrance
vittae	9	39	1100	3	vitta__e
vittate	10	40	973	3	vitta_te

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	65	6.423	22756.0
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	6.859	26052.0