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

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

66 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
papillate	13	12	757	(None)
papillae	12	13	702	1	papilla_e
papillote	13	9	409	1	papillote
appellate	13	4	619	2	appellate
arillate	8	4	1299	2	_arillate
papilla	11	12	791	2	papilla__
papillar	12	9	671	2	papilla_r
papillary	16	9	440	2	papillary
papillose	13	9	360	2	papillose
papillotes	14	9	330	2	papillotes
patellate	11	4	748	2	patellate
pupillage	14	4	275	2	pupillage
vacillate	14	5	685	2	vacillate
apholate	13	4	1047	3	_apholate
apiculate	13	27	988	3	_apiculate
axillae	14	24	823	3	_axilla_e
cantillate	12	4	734	3	cantillate
capillary	16	13	426	3	capillary
capitate	12	17	1218	3	capi_tate
capitulate	14	4	510	3	capitulate
capsulate	13	4	756	3	capsulate
carpellate	14	4	533	3	carpellate
depilate	11	3	1170	3	depi_late
epilate	9	3	1428	3	_epi_late
gallate	8	34	1712	3	ga__llate
labellate	11	12	692	3	labellate
lamellate	11	11	670	3	lamellate
lapidate	11	5	790	3	lapi_date
maxillae	17	25	672	3	maxilla_e
oppilate	12	4	586	3	oppi_late
oscillate	11	4	547	3	oscillate
paginate	11	40	1244	3	pagi_nate
paillard	11	4	626	3	pa_illard
paillasse	11	4	269	3	pa_illasse
paillette	11	4	524	3	pa_illette
palate	8	42	2678	3	pa___late
paleate	9	41	2000	3	pa__leate
palliate	10	3	1189	3	pa_lliate
palmate	11	32	1523	3	pa__lmate
palpate	11	32	1392	3	pa__lpate
palpitate	13	6	597	3	palpi_tate
paniculate	14	4	721	3	paniculate
papilloma	15	5	229	3	papilloma
papillomata	17	6	149	3	papillomata
papillon	12	4	472	3	papill_on
papillons	13	4	409	3	papillons
papulae	11	24	935	3	pap_ula_e
patellae	10	4	762	3	patella_e
patinate	10	30	1631	3	pati_nate
petiolate	11	4	915	3	petiolate
pileate	9	38	1592	3	__pileate
pillage	10	34	1260	3	__pillage
pistillate	12	4	544	3	pistillate
pixillated	20	4	250	3	pixillated
populate	12	28	1209	3	pop_ulate
pupilage	13	4	377	3	pupi_lage
pupillages	15	4	237	3	pupillages
pupillary	16	13	314	3	pupillary
spillage	11	4	626	3	_spillage
tailgate	9	4	682	3	ta_ilgate
titillate	9	4	558	3	titillate
vacillated	16	5	463	3	vacillated
vacillates	15	5	572	3	vacillates
vallate	10	30	1656	3	va__llate
variolate	12	4	855	3	variolate
vexillate	19	4	455	3	vexillate

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.423	422437.4
2	DLD Change Limit	148641	66	7.923	18760.7
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	8.376	21333.7