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

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

93 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
funkers	14	37	1206	(None)
bunkers	13	37	1595	1	bunkers
dunkers	12	35	1219	1	dunkers
flunkers	15	34	753	1	flunkers
fuckers	16	36	1159	1	fuckers
funders	11	38	1393	1	funders
funker	13	39	1576	1	funker_
hunkers	14	33	1433	1	hunkers
junkers	18	40	1086	1	junkers
lunkers	11	34	1460	1	lunkers
punkers	13	37	1485	1	punkers
bankers	13	39	1909	2	bankers
bonkers	13	40	1530	2	bonkers
buckers	15	35	1745	2	buckers
bunker	12	45	1937	2	bunker_
bunters	9	47	1712	2	bunters
burkers	13	37	1662	2	burkers
buskers	13	34	1409	2	buskers
cankers	13	44	1875	2	cankers
clunkers	14	32	755	2	clunkers
conkers	13	37	2104	2	conkers
cunners	9	39	1347	2	cunners
duckers	14	32	1471	2	duckers
duikers	12	36	938	2	duikers
dunker	11	36	1646	2	dunker_
fakers	13	42	1953	2	f_akers
fanners	10	39	1465	2	fanners
fencers	12	38	1062	2	fencers
fenders	11	37	1726	2	fenders
finders	11	37	1787	2	finders
fingers	11	34	1843	2	fingers
flakers	14	36	1327	2	flakers
flankers	15	34	930	2	flankers
flunker	14	38	936	2	flunker_
flunkeys	18	26	317	2	flunkeys
forkers	14	46	1578	2	forkers
founders	12	39	1167	2	founders
frankers	15	34	835	2	frankers
fucker	15	34	1442	2	fucker_
fuelers	10	39	1239	2	fuelers
fuhrers	13	3	481	2	fuhrers
fullers	10	38	1737	2	fullers
fumers	11	36	1338	2	fu_mers
funder	10	40	1608	2	funder_
funked	14	42	1411	2	funke_d
funkias	14	3	538	2	funkias
funkier	14	34	998	2	funkier_
funks	12	53	1891	2	funk__s
funnels	10	34	817	2	funnels
funner	9	34	1410	2	funner_
furlers	10	42	1422	2	furlers
fussers	10	42	1081	2	fussers
gunners	8	31	1173	2	gunners
hankers	14	42	1813	2	hankers
honkers	14	33	1523	2	honkers
hungers	11	40	1330	2	hungers
hunker	13	39	1767	2	hunker_
hunkeys	17	38	619	2	hunkeys
hunters	10	39	1573	2	hunters
huskers	14	35	1004	2	huskers
inkers	10	40	1883	2	_inkers
jinkers	18	35	1181	2	jinkers
junker	17	42	1365	2	junker_
junkets	18	37	762	2	junkets
linkers	11	43	1771	2	linkers
lungers	8	38	1709	2	lungers
lunker	10	47	1834	2	lunker_
lurkers	11	39	1008	2	lurkers
muckers	15	36	1280	2	muckers
pinkers	13	41	1860	2	pinkers
plunkers	14	32	833	2	plunkers
puckers	15	35	1467	2	puckers
punker	12	37	1882	2	punker_
punkeys	16	36	649	2	punkeys
punners	9	41	1423	2	punners
punters	9	36	1704	2	punters
quakers	20	30	969	2	quakers
rankers	11	32	1746	2	rankers
runners	7	42	1245	2	runners
sinkers	11	36	1854	2	sinkers
suckers	13	37	1762	2	suckers
sulkers	11	36	1334	2	sulkers
sunders	8	41	2005	2	sunders
sunkets	11	35	1128	2	sunkets
tankers	11	34	1691	2	tankers
tinkers	11	35	1714	2	tinkers
tuckers	13	40	1435	2	tuckers
tuners	6	44	1734	2	tun_ers
tuskers	11	37	1004	2	tuskers
wankers	14	45	1471	2	wankers
winkers	14	35	1711	2	winkers
yonkers	14	37	982	2	yonkers
younkers	15	29	576	2	younkers

Search took 7 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.750	238254.7
2	DLD Change Limit	107671	93	5.830	18468.4
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	6.610	27033.4