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

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

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

125 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
dickers	14	41	1766	(None)
bickers	15	43	1655	1	bickers
dackers	14	34	1704	1	dackers
deckers	14	44	1383	1	deckers
dicers	9	47	2074	1	dic_ers
dickens	14	44	1013	1	dickens
dicker	13	45	2140	1	dicker_
dickeys	17	47	930	1	dickeys
dikers	11	44	1879	1	di_kers
dockers	14	37	1500	1	dockers
duckers	14	32	1471	1	duckers
ickers	12	39	1418	1	_ickers
kickers	12	40	1329	1	kickers
lickers	13	41	1825	1	lickers
nickers	13	44	1509	1	nickers
pickers	15	37	1809	1	pickers
tickers	13	36	1772	1	tickers
wickers	16	41	1470	1	wickers
backers	15	38	2188	2	backers
bicker	14	48	1917	2	bicker_
bikers	12	45	1755	2	bi_kers
bilkers	13	47	1186	2	bilkers
buckers	15	35	1745	2	buckers
clickers	16	39	1020	2	clickers
cockers	15	36	1833	2	cockers
dacker	13	49	2075	2	dacker_
daikers	12	40	1031	2	daikers
deckels	14	36	736	2	deckels
decker	13	52	1599	2	decker_
deicers	10	36	1273	2	deic_ers
detickers	16	3	442	2	detickers
dialers	8	36	1430	2	dialers
diapers	10	47	1391	2	diapers
dibbers	12	40	1317	2	dibbers
dicer	8	54	2642	2	dic_er_
dices	8	64	3424	2	dic_e_s
dicier	9	44	1623	2	dicier_
dicked	14	49	2086	2	dicke_d
dickered	16	11	753	2	dickered
dickey	16	59	1352	2	dicke_y
dickier	14	35	1245	2	dickier_
dickies	14	34	1634	2	dickies
dicks	12	58	2469	2	dick__s
dieters	8	32	1643	2	dieters
differs	14	33	997	2	differs
diggers	10	44	1339	2	diggers
diker	10	55	2455	2	di_ker_
dikes	10	58	3133	2	di_ke_s
dimers	9	43	2109	2	di_mers
dimmers	12	38	1156	2	dimmers
diners	7	55	2595	2	di_ners
dingers	9	43	2138	2	dingers
dinkeys	15	50	726	2	dinkeys
dinners	8	39	1544	2	dinners
dippers	12	36	1518	2	dippers
ditchers	14	36	1036	2	ditchers
dithers	11	40	1615	2	dithers
divers	10	50	2496	2	di_vers
docker	13	44	1765	2	docker_
dockets	14	44	1224	2	dockets
drinkers	13	27	782	2	drinkers
ducker	13	43	1799	2	ducker_
duikers	12	36	938	2	duikers
dunkers	12	35	1219	2	dunkers
flickers	17	33	888	2	flickers
fuckers	16	36	1159	2	fuckers
hackers	16	46	1904	2	hackers
hickeys	19	50	822	2	hickeys
hikers	13	50	1435	2	hi_kers
hockers	16	39	1591	2	hockers
icker	11	40	1844	2	_icker_
inkers	10	40	1883	2	_inkers
jackers	20	42	1445	2	jackers
jinkers	18	35	1181	2	jinkers
kicker	11	41	1618	2	kicker_
knickers	13	30	672	2	knickers
lackers	13	41	2054	2	lackers
licker	12	52	2204	2	licker_
likers	10	46	2091	2	li_kers
linkers	11	43	1771	2	linkers
lockers	13	35	1692	2	lockers
mickeys	18	44	794	2	mickeys
milkers	13	44	1161	2	milkers
mockers	15	38	1294	2	mockers
muckers	15	36	1280	2	muckers
neckers	13	42	1046	2	neckers
nickels	13	33	865	2	nickels
nicker	12	38	1870	2	nicker_
ockers	12	38	1390	2	_ockers
packers	15	38	1889	2	packers
peckers	15	33	1267	2	peckers
pickeers	16	34	724	2	pickeers
picker	14	44	2217	2	picker_
pickets	15	43	1418	2	pickets
pikers	12	47	1739	2	pi_kers
pinkers	13	41	1860	2	pinkers
prickers	16	37	1067	2	prickers
puckers	15	35	1467	2	puckers
rackers	13	43	2045	2	rackers
ricers	8	41	2099	2	ric_ers
rickets	13	49	1509	2	rickets
rickeys	16	54	898	2	rickeys
riskers	11	40	1199	2	riskers
rockers	13	39	1655	2	rockers
sackers	13	38	2022	2	sackers
shickers	17	30	1282	2	shickers
sickees	13	45	1421	2	sickees
sickens	13	44	1148	2	sickens
sicker	12	40	2390	2	sicker_
sinkers	11	36	1854	2	sinkers
slickers	14	31	1255	2	slickers
snickers	14	30	1096	2	snickers
stickers	14	29	1303	2	stickers
suckers	13	37	1762	2	suckers
tackers	13	43	1962	2	tackers
ticker	12	43	2150	2	ticker_
tickets	13	41	1368	2	tickets
ticklers	14	33	930	2	ticklers
tinkers	11	35	1714	2	tinkers
trickers	14	38	1281	2	trickers
tuckers	13	40	1435	2	tuckers
whickers	20	29	798	2	whickers
wicker	15	45	1867	2	wicker_
wickets	16	40	1094	2	wickets
winkers	14	35	1711	2	winkers

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.360	496363.9
2	DLD Change Limit	107671	125	3.263	32997.5
3	Display Results	125	125	0.033	3787.9
	(SQL Overall)	178691	125	3.656	48876.1