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

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

70 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
portioner	11	5	868	(None)
portioned	12	4	833	1	portioned
portioners	12	5	741	1	portioners
motioner	10	3	759	2	mo_tioner
portion	9	6	1549	2	portion__
portions	10	5	1441	2	portion_s
postponer	13	4	603	2	postponer
actioner	10	4	866	3	_actioner
apportioned	16	5	345	3	apportioned
cautioner	11	4	539	3	cautioner
coroner	9	42	1820	3	cor__oner
cortisone	11	4	704	3	cortisone_
cortisones	12	6	705	3	cortisones
extortioner	18	5	265	3	extortioner
foreigner	13	4	466	3	foreigner
fortifier	15	4	625	3	fortifier
loriner	7	5	1189	3	lor_i_ner
mentioner	11	4	669	3	mentioner
mortifier	14	4	692	3	mortifier
mortiser	10	7	847	3	morti_ser
motioned	11	3	745	3	mo_tioned
motioners	11	4	657	3	mo_tioners
optioned	11	4	638	3	_optioned
optionee	10	4	651	3	_optionee
pardoner	11	18	944	3	par_doner
partier	9	35	2071	3	parti__er
partitioner	13	5	345	3	partitioner
partner	9	28	1139	3	part__ner
pensioner	11	4	666	3	pensioner
peritonea	11	4	730	3	peritonea
perniones	11	4	859	3	perniones
petitioner	12	4	415	3	petitioner
poetiser	10	3	731	3	poeti_ser
poetizer	19	3	681	3	poeti_zer
poisoner	10	4	698	3	po_isoner
pontine	9	24	1905	3	ponti_ne_
pontonier	11	4	638	3	pont_onier
porcine	11	3	1284	3	porci_ne_
porkier	13	37	1234	3	porki__er
pornier	9	34	1313	3	porni__er
porringer	12	4	405	3	porringer
porter	8	42	2441	3	port___er
porthole	13	4	952	3	porthole_
portholes	14	4	1037	3	portholes
porticoed	14	4	542	3	porticoed
porticoes	13	4	825	3	porticoes
portiere	10	3	877	3	porti__ere
portieres	11	3	821	3	portieres
porting	10	30	2178	3	porti_n_g
portioning	13	4	719	3	portioning
portionless	13	4	402	3	portionless
portlier	10	3	837	3	port_lier
portrayer	14	6	400	3	portrayer
positioned	13	9	600	3	positioned
postpone	12	4	869	3	postpone_
postponed	14	4	590	3	postponed
postponers	14	4	527	3	postponers
postpones	13	4	883	3	postpones
potion	8	45	1957	3	po_tion__
potions	9	34	1742	3	po_tion_s
pottier	9	35	1649	3	potti__er
poutier	9	32	1532	3	pouti__er
poutine	9	33	1682	3	pouti_ne_
poutines	10	24	1510	3	pouti_nes
prisoner	10	4	857	3	p_risoner
probationer	15	6	377	3	probationer
purloiner	11	4	326	3	purloiner
purtier	9	32	1409	3	purti__er
sportier	10	20	1005	3	sporti__er
stationer	9	4	603	3	stationer

Search took 9 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.156	1145455.1
2	DLD Change Limit	148641	70	8.283	17945.3
3	Display Results	70	70	0.013	5384.6
	(SQL Overall)	178691	70	8.452	21141.9