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

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

75 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
porpoises	13	4	843	(None)
porpoise	12	4	808	1	porpoise_
porpoised	14	4	544	1	porpoised
propolises	14	4	885	2	propolises
proposes	12	25	1597	2	propo_ses
purposes	12	3	782	2	purpo_ses
tortoises	9	4	718	2	tortoises
composes	14	50	1711	3	compo_ses
comprises	15	5	1094	3	comprises
corpses	11	39	1380	3	corp__ses
corpuses	12	3	1006	3	corp_uses
lordoses	9	3	714	3	lordo_ses
lorises	7	39	1859	3	lor__ises
mispoises	13	4	835	3	mispoises
moralises	11	3	1400	3	moralises
morphines	16	4	823	3	morphines
morphoses	16	4	812	3	morphoses
morrises	10	7	1107	3	mor_rises
mortises	10	7	1361	3	mor_tises
opposes	11	4	924	3	_oppo_ses
orchises	13	3	877	3	_orchises
oroides	8	3	1197	3	_or_oides
orphisms	15	4	599	3	_orphisms
orpines	9	44	1479	3	_orp_ines
orrises	7	13	1223	3	_or_rises
papooses	12	4	805	3	p_apooses
pappooses	12	4	398	3	pappooses
paradises	12	25	1320	3	paradises
parises	9	48	2718	3	par__ises
parvises	13	39	1191	3	par_vises
poetises	10	3	1395	3	po_etises
poises	8	42	2654	3	___poises
polarises	11	5	1407	3	polarises
poloists	10	9	1052	3	po_loists
poorhouses	15	4	529	3	poorhouses
poppies	10	28	1619	3	po_ppi_es
popsies	11	28	1646	3	po_psi_es
porgies	10	30	1700	3	por_gi_es
porisms	11	37	1345	3	por__isms
porkies	13	34	1649	3	por_ki_es
porkpies	16	3	619	3	porkpi_es
porose	8	48	1874	3	por_o_se_
porpoising	15	4	583	3	porpoising
postposes	13	4	819	3	postpo_ses
pothouses	14	4	904	3	pothouses
potpies	11	31	1617	3	potp_i_es
pourboires	14	5	194	3	pourboires
pourpoints	14	4	258	3	pourpoints
praises	9	41	2110	3	p_r_aises
praxises	17	3	906	3	p_raxises
precises	12	32	1833	3	p_recises
premises	12	30	1827	3	p_remises
previses	13	38	1428	3	p_revises
prises	8	41	3317	3	p_r__ises
proclises	13	3	954	3	proclises
promises	12	29	1676	3	p_romises
prophases	16	4	1106	3	prophases
propines	12	26	1893	3	prop_ines
propones	12	25	1696	3	propo_nes
propose	11	27	1484	3	propo_se_
proposed	13	20	1107	3	propo_sed
proposer	12	18	1063	3	propo_ser
proposers	13	22	852	3	propo_sers
proptoses	13	4	987	3	proptoses
proses	8	47	3347	3	p_r_o_ses
prosses	9	40	1951	3	p_r_osses
purpose	11	3	738	3	purpo_se_
purposed	13	3	525	3	purpo_sed
pyrosises	14	5	758	3	pyrosises
sorboses	10	3	852	3	sorbo_ses
soroses	7	31	1748	3	sor_o_ses
sorosises	9	4	730	3	sorosises
surprises	11	3	743	3	surprises
tortoise	8	4	709	3	tortoise_
turkoises	13	4	363	3	turkoises

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	75	8.050	18464.7
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	8.236	21696.3