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

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

86 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
porkpie	15	4	467	(None)
porkpies	16	3	619	1	porkpies
porkier	13	37	1234	2	pork_ier
porkies	13	34	1649	2	pork_ies
potpie	10	34	1243	2	po_tpie
birkie	12	41	1013	3	birk_ie
bookie	12	35	1600	3	book_ie
cockpit	17	4	799	3	cockpit
cookie	12	37	1604	3	cook_ie
corbie	10	36	1820	3	cor_bie
corkage	14	3	837	3	corkage
corkier	13	31	1430	3	cork_ier
corklike	13	3	599	3	corklike
corpse	10	40	1340	3	cor_pse
corrie	8	36	2123	3	cor_rie
cowpie	13	35	1151	3	co_wpie
croppie	13	27	879	3	croppie
darkie	11	37	1401	3	dark_ie
dorkier	12	28	1002	3	dork_ier
dormie	9	3	1262	3	dor_mie
folkie	13	36	961	3	folk_ie
forkier	14	43	1159	3	fork_ier
forklike	14	3	581	3	forklike
groupie	10	4	578	3	groupie
honkie	13	30	1167	3	honk_ie
hornpipe	15	4	276	3	hornpipe
kookie	9	38	984	3	kook_ie
koppie	14	27	788	3	ko_ppie
nookie	10	37	1243	3	nook_ie
oorie	5	30	2636	3	oor__ie
orpin	7	34	1553	3	_or_pin
orpine	8	39	1448	3	_or_pine
pardie	9	60	2144	3	par_die
parkade	14	3	758	3	parkade
parklike	13	3	749	3	parklike
perdie	9	47	1851	3	per_die
perkier	13	38	1312	3	perk_ier
perspire	12	4	666	3	perspire
pinkie	12	44	1427	3	pink_ie
pockier	15	39	1160	3	pock_ier
poke	10	53	3536	3	po_k__e
pokier	12	49	1463	3	po_k_ier
pokies	12	59	2133	3	po_k_ies
polypi	13	45	859	3	polypi_
polypide	16	4	701	3	polypide
pommie	12	37	1050	3	po_mmie
pope	8	55	3561	3	po__p_e
poppied	11	38	898	3	po_ppied
poppies	10	28	1620	3	po_ppies
popple	9	27	1098	3	po_pple
popsie	10	30	1305	3	po_psie
porcine	11	3	1284	3	porcine
porcupine	15	4	327	3	porcupine
pore	6	64	5126	3	por___e
porgies	10	30	1700	3	por_gies
pork	10	69	2968	3	pork___
porked	13	47	1762	3	pork_ed
porker	12	49	1754	3	pork_er
porkers	13	43	1493	3	porkers
porkiest	14	35	1371	3	pork_iest
porking	14	35	1581	3	porking
porks	11	51	2414	3	pork__s
porky	14	50	1933	3	pork__y
pornier	9	34	1313	3	por_nier
porose	8	48	1874	3	por_ose
porpoise	12	4	808	3	porpoise
portage	10	30	1364	3	portage
portlier	10	3	837	3	portlier
portside	11	3	816	3	portside
postie	8	41	2396	3	po_stie
potpies	11	31	1617	3	po_tpies
potsie	8	39	1603	3	po_tsie
poussie	9	3	662	3	poussie
premie	10	36	1799	3	p_remie
preppie	10	5	809	3	preppie
propine	11	30	2021	3	p_ropine
prossie	9	18	1295	3	prossie
prostie	9	16	1774	3	prostie
punkie	12	35	1361	3	punk_ie
purple	10	27	1268	3	pur_ple
pyrope	13	28	1053	3	pyrop_e
rookie	10	36	1326	3	rook_ie
scrapie	11	50	1094	3	scrapie
sortie	6	36	2199	3	sor_tie
torpid	9	3	1091	3	tor_pid
workpiece	20	5	201	3	workpiece

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	134027	0.403	443402.0
2	DLD Change Limit	134027	86	6.923	19359.7
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	7.359	24282.0