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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

105 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
probities	13	3	1265	(None)
improbities	17	5	469	2	improbities
piosities	11	3	1172	2	piosities
polities	10	27	2234	2	p_olities
porosities	12	4	1148	2	porosities
priorities	12	4	915	2	priorities
privities	14	3	1204	2	privities
probates	12	4	1428	2	probat_es
probiotics	16	4	404	2	probiotics
probits	11	27	1257	2	probit__s
prodigies	13	4	695	2	prodigies
prosties	10	14	2119	2	pro_sties
apriorities	13	4	540	3	apriorities
aridities	10	9	1163	3	aridities
atrocities	12	4	859	3	atrocities
brevities	14	4	642	3	brevities
comities	12	3	1779	3	_comities
crossties	11	3	902	3	crossties
crudities	12	4	774	3	crudities
ferocities	15	4	824	3	ferocities
gravities	13	3	830	3	gravities
moronities	12	4	906	3	moronities
morosities	12	4	841	3	morosities
niobites	10	3	731	3	niobit_es
oralities	9	12	1412	3	oralities
parities	10	5	2297	3	p_arities
parotitis	11	4	917	3	parotiti_s
parotitises	13	4	642	3	parotitises
paucities	13	4	850	3	paucities
pilosities	12	4	780	3	pilosities
pities	8	38	2808	3	p___ities
ploidies	11	3	817	3	plo_idies
plotties	10	31	1141	3	plo_tties
podites	10	30	1473	3	p_odit_es
policies	12	24	1566	3	p_olicies
politics	12	25	1381	3	p_olitics
positives	14	5	917	3	p_ositives
posties	9	31	2881	3	p_o_sties
potties	9	37	2354	3	p_o_tties
prairies	10	4	1145	3	pr_airies
precocities	17	4	816	3	precocities
pretties	10	6	1513	3	pr_etties
primitives	17	4	562	3	primitives
prioritizes	22	5	427	3	prioritizes
privies	12	24	1426	3	pr__ivies
probables	15	4	543	3	probables
probate	11	4	1448	3	probat_e_
probated	13	4	1086	3	probat_ed
probating	14	3	1119	3	probating
probation	13	4	1218	3	probation
probations	14	3	1108	3	probations
probative	16	4	917	3	probative
probes	10	41	1945	3	prob___es
probiotic	15	4	666	3	probioti_c
probit	10	32	1835	3	probit___
probity	14	29	968	3	probit__y
proclitics	16	4	563	3	proclitics
proctitides	16	6	471	3	proctitides
proctitis	13	4	836	3	proctiti_s
proctitises	15	10	632	3	proctitises
proettes	10	3	1276	3	pro_ettes
profanities	16	7	625	3	profanities
profiles	13	32	1123	3	profi_les
profited	14	27	997	3	profit_ed
profiteer	14	27	449	3	profiteer
profiteers	15	21	369	3	profiteers
profiter	13	27	1020	3	profit_er
profiters	14	22	831	3	profiters
profiting	15	4	998	3	profiting
profitless	15	4	276	3	profitless
profits	12	29	1124	3	profit__s
profitwise	18	5	209	3	profitwise
progenies	12	3	1412	3	progenies
prohibits	16	4	493	3	prohibits
prolines	10	26	1969	3	proli_nes
prolixities	20	4	636	3	prolixities
promines	12	30	1880	3	promi_nes
promisees	13	24	686	3	promisees
promises	12	29	1676	3	promi_ses
promotes	12	3	1412	3	promot_es
pronates	10	4	1837	3	pronat_es
properties	14	14	1188	3	properties
propines	12	26	1893	3	propi_nes
propitiates	15	4	620	3	propitiates
propitious	14	4	660	3	propitious
proprieties	15	5	618	3	proprieties
prorates	10	4	1807	3	prorat_es
prosodies	12	4	973	3	prosodies
prossies	10	15	1523	3	pro_ssies
prostie	9	16	1774	3	pro_stie_
proustites	12	4	645	3	proustites
provides	14	3	988	3	provi_des
provinces	16	4	685	3	provinces
provisoes	14	4	665	3	provisoes
proxies	16	30	1493	3	pro__xies
proximities	22	5	588	3	proximities
purities	10	3	1628	3	p_urities
rarities	8	3	1633	3	_rarities
robotics	12	4	549	3	_robotics
robotizes	20	4	576	3	_robotizes
robotries	11	4	732	3	_robotries
serosities	10	4	1082	3	serosities
sororities	10	10	919	3	sororities
torosities	10	4	826	3	torosities
trinities	9	3	1334	3	trinities

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	148641	0.423	422437.4
2	DLD Change Limit	148641	105	6.953	21378.0
3	Display Results	105	105	0.063	1666.7
	(SQL Overall)	178691	105	7.439	24020.8