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

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

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.

80 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
pissers	9	50	1475	(None)
hissers	10	41	1231	1	hissers
kissers	11	42	1129	1	kissers
passers	9	47	1775	1	passers
pishers	12	38	1575	1	pishers
pisser	8	44	1638	1	pisser_
pisses	8	45	2508	1	pisse_s
bisters	9	39	2261	2	bisters
cussers	9	42	1340	2	cussers
dissert	8	37	2069	2	dissert
disserts	9	24	1181	2	disserts
disses	7	52	2596	2	disse_s
dossers	8	45	1623	2	dossers
fishers	13	47	1472	2	fishers
fussers	10	42	1081	2	fussers
gassers	8	47	1463	2	gassers
hisser	9	47	1379	2	hisser_
hisses	9	47	1935	2	hisse_s
isseis	6	3	856	2	_isseis
issuers	7	4	612	2	_issuers
kisser	10	42	1245	2	kisser_
kisses	10	42	1733	2	kisse_s
lispers	9	45	1432	2	lispers
listers	7	40	2653	2	listers
misers	8	50	2570	2	mi_sers
missels	9	46	1481	2	missels
misses	8	51	3087	2	misse_s
missets	9	45	1657	2	missets
misters	9	39	2751	2	misters
misusers	10	34	808	2	misusers
mossers	9	41	1619	2	mossers
parsers	9	41	1815	2	parsers
passels	9	39	1302	2	passels
passer	8	47	2103	2	passer_
passes	8	60	3047	2	passe_s
pasters	9	45	3173	2	pasters
pausers	9	41	1322	2	pausers
pesters	9	38	2709	2	pesters
piasters	10	29	1281	2	piasters
pickers	15	37	1809	2	pickers
piecers	11	41	1225	2	piecers
piers	7	59	2633	2	pi__ers
pikers	12	47	1739	2	pi_kers
pilfers	12	3	896	2	pilfers
pilsners	10	3	553	2	pilsners
pincers	11	39	1650	2	pincers
pinders	10	37	2047	2	pinders
pingers	10	40	2074	2	pingers
pinkers	13	41	1860	2	pinkers
pinners	9	35	1860	2	pinners
pipers	10	43	1866	2	pi_pers
pisher	11	43	1775	2	pisher_
pishes	11	47	2210	2	pishe_s
pissed	9	48	1693	2	pisse_d
pissoirs	10	4	469	2	pissoirs
pistes	8	53	2563	2	piste_s
pitiers	9	38	1265	2	pitiers
plisses	9	44	1177	2	plisse_s
poisers	9	42	1443	2	poisers
posers	8	42	2397	2	p_osers
posses	8	51	2880	2	posse_s
possess	9	41	912	2	possess
possets	9	42	1277	2	possets
posters	9	39	2801	2	posters
pressers	10	32	1502	2	pressers
prisses	9	48	1671	2	prisse_s
prosers	9	42	1964	2	prosers
pulsers	9	42	1315	2	pulsers
pursers	9	39	1609	2	pursers
pushers	12	38	1450	2	pushers
pusses	8	43	2284	2	pusse_s
rinsers	7	38	1574	2	rinsers
risers	6	46	2478	2	ri_sers
riskers	11	40	1199	2	riskers
sisses	6	45	2060	2	sisse_s
sisters	7	37	2159	2	sisters
tossers	7	47	1350	2	tossers
tussers	7	43	1356	2	tussers
wishers	13	32	1521	2	wishers
wisses	9	46	1960	2	wisse_s

Search took 4 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	107671	0.393	454684.5
2	DLD Change Limit	107671	80	3.326	32372.5
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	3.752	47625.5