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

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

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.

81 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
pelletising	14	5	339	(None)
palletising	14	5	357	1	palletising
pelletizing	23	4	508	1	pelletizing
palletizing	23	4	491	2	palletizing
pelleting	12	3	795	2	pellet__ing
bulletining	14	5	250	3	bulletining
elegising	11	4	542	3	_e_legising
hellenizing	24	5	407	3	hellenizing
palleting	12	3	873	3	pallet__ing
pelletise	11	4	666	3	pelletis__e
pelletised	13	4	401	3	pelletis_ed
pelletises	12	4	634	3	pelletis_es
poetising	12	3	871	3	p__oetising
pulverising	17	5	290	3	pulverising
televising	14	4	411	3	te_levising
appetising	15	4	451	4	_appetising
billeting	12	3	663	4	billet__ing
bulleting	12	3	664	4	bullet__ing
colleting	12	3	1105	4	collet__ing
deleting	10	33	1442	4	de_let__ing
depleting	13	7	819	4	deplet__ing
elegizing	20	4	561	4	_e_legizing
eulogising	12	4	397	4	_eulogising
fellating	13	3	924	4	fellat__ing
filleting	13	3	584	4	fillet__ing
galleting	11	3	762	4	gallet__ing
geometrising	16	5	255	4	geometrising
helmeting	15	4	550	4	helmet__ing
magnetising	15	5	373	4	magnetising
melodising	14	4	476	4	me_lodising
mercerising	16	5	383	4	mercerising
mesmerising	16	4	393	4	mesmerising
monetising	13	4	621	4	_monetising
palletise	11	12	763	4	palletis__e
palletised	13	4	451	4	palletis_ed
palletises	12	4	722	4	palletis_es
pectizing	23	4	801	4	pe__ctizing
peising	10	34	1676	4	p___e_ising
pelletize	20	5	638	4	pellet__ize
pelletized	22	4	498	4	pelleti_zed
pelletizer	21	4	418	4	pelleti_zer
pelletizers	22	5	286	4	pelletizers
pelletizes	21	4	605	4	pelleti_zes
pellets	9	40	1478	4	pellet_s___
peltering	12	20	1167	4	pe_l_tering
pelting	10	29	1727	4	pe_l_t__ing
penalising	13	4	762	4	pe_nalising
peptizing	23	4	711	4	pe__ptizing
perceiving	18	4	466	4	perce_iving
pleasing	11	26	1159	4	p__le_asing
plenishing	16	4	469	4	p__lenishing
poetizing	21	4	868	4	p__oetizing
polarising	13	4	766	4	p_olarising
polemizing	24	4	691	4	p_olemizing
pollenating	14	4	455	4	pollenating
pollening	12	3	692	4	polle__ning
pollinizing	23	4	507	4	pollinizing
polluting	12	3	570	4	pollut__ing
polymerising	20	8	323	4	polymerising
poulticing	15	4	340	4	poul_ticing
practising	15	8	636	4	p_ractising
preblessing	16	4	373	4	preble_ssing
precising	14	4	1327	4	p__recising
premising	14	4	1241	4	p__remising
prevising	15	5	1087	4	p__revising
privatising	17	5	406	4	privatising
publicising	18	5	276	4	publicising
pulverizing	26	5	366	4	pulverizing
realising	10	3	1317	4	real__ising
releasing	10	4	1101	4	re_le_asing
reletting	10	27	1394	4	re_let_ting
replenishing	18	5	221	4	replenishing
replevining	17	4	315	4	replevining
sellotaping	14	5	258	4	sellotaping
sensitising	12	5	377	4	sensitising
solecising	13	4	575	4	_solecising
teletyping	16	4	247	4	te_letyping
tellurizing	21	5	399	4	tellurizing
telneting	10	3	559	4	telnet__ing
telnetting	11	4	388	4	telnet_ting
trellising	11	4	466	4	trell__ising

Search took 10 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	148819	0.156	1145455.1
2	DLD Change Limit	148819	81	9.013	16511.6
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	9.202	19418.7