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

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

314 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
gurneys	11	40	646	(None)
gurnets	8	40	1079	1	gurnets
gurney	10	42	941	1	gurney_
barneys	12	56	956	2	barneys
burleys	12	47	967	2	burleys
burners	9	41	1567	2	burners
burnets	9	38	1326	2	burnets
carneys	12	43	1054	2	carneys
garners	8	38	1598	2	garners
garnets	8	41	1540	2	garnets
garveys	14	12	446	2	garveys
gooneys	11	40	707	2	gooneys
greys	9	66	1485	2	g_r_eys
guanays	11	3	495	2	guanays
guernseys	13	8	103	2	guernseys
guineas	8	3	675	2	guineas
gulleys	11	43	852	2	gulleys
gunnels	8	35	856	2	gunnels
gunners	8	31	1173	2	gunners
gurges	8	47	1686	2	gurge_s
gurnet	7	49	2087	2	gurne_t
hurleys	13	40	733	2	hurleys
journeys	18	4	320	2	journeys
murreys	12	36	732	2	murreys
purveys	15	61	590	2	purveys
surreys	10	48	944	2	surreys
surveys	13	35	757	2	surveys
tourneys	11	3	401	2	tourneys
turkeys	14	3	452	2	turkeys
turners	7	39	1289	2	turners
turnkeys	15	4	212	2	turnkeys
aures	5	51	3709	3	aur_e_s
aureus	6	53	1488	3	aur_eus
barleys	12	50	1184	3	barleys
barney	11	53	1445	3	barney_
blarneys	13	18	319	3	blarneys
bournes	9	36	1502	3	bourne_s
brunets	9	41	955	3	brunets
burdens	10	3	971	3	burdens
burets	8	43	2126	3	bur_ets
burgees	10	49	1589	3	burgees
burgers	10	39	1857	3	burgers
burgess	10	40	934	3	burgess
buriers	9	40	1719	3	buriers
buries	8	46	3327	3	burie_s
burkers	13	37	1662	3	burkers
burkes	12	44	2131	3	burke_s
burlers	9	41	2027	3	burlers
burley	11	47	1575	3	burley_
burned	9	58	1896	3	burne_d
burner	8	38	1920	3	burne_r
burnet	8	43	2617	3	burne_t
burnies	9	40	1782	3	burnies
burnous	9	3	882	3	burnous
burns	7	49	2677	3	burn__s
burrers	9	38	1449	3	burrers
burses	8	44	2551	3	burse_s
carnets	9	39	1840	3	carnets
carney	11	53	1570	3	carney_
churners	13	31	689	3	churners
chutneys	16	4	232	3	chutneys
coneys	11	52	1842	3	_coneys
corneas	9	47	1700	3	corneas
cornels	9	47	1666	3	cornels
corners	9	47	2331	3	corners
cornets	9	48	2057	3	cornets
cunners	9	39	1347	3	cunners
curbers	11	55	1438	3	curbers
curers	8	49	2319	3	cur_ers
cures	7	56	4543	3	cur_e_s
curets	8	49	2234	3	cur_ets
curfews	15	29	491	3	curfews
curies	8	49	3402	3	curie_s
curlers	9	42	1807	3	curlers
curlews	12	38	739	3	curlews
curns	7	49	2427	3	curn__s
cursers	9	43	1716	3	cursers
curses	8	53	2827	3	curse_s
curtesy	12	6	583	3	curtesy
curtness	10	3	726	3	curtness
curtseys	13	4	274	3	curtseys
curves	11	46	1928	3	curve_s
curvets	12	39	991	3	curvets
curvey	14	41	1184	3	curvey_
cuteys	11	56	998	3	cu_teys
darkeys	15	35	653	3	darkeys
darnels	8	37	1043	3	darnels
darners	8	38	1577	3	darners
dourness	9	4	768	3	dourness
dueness	8	23	1012	3	dueness
dulness	8	30	798	3	dulness
dunes	6	53	3217	3	du_ne_s
dunness	8	29	898	3	dunness
dures	6	56	3592	3	dur_e_s
duress	7	47	1206	3	dur_ess
durned	8	41	1317	3	durne_d
durns	6	48	1986	3	durn__s
earners	7	40	1645	3	earners
ernes	5	52	2481	3	_erne_s
eupneas	9	3	523	3	eupneas
farness	10	29	1220	3	farness
fulness	10	24	896	3	fulness
funnels	10	34	817	3	funnels
furanes	10	32	1486	3	furane_s
furies	9	51	2637	3	furie_s
furlers	10	42	1422	3	furlers
furless	10	32	1014	3	furless
furzes	18	66	1369	3	furze_s
gainers	8	42	1459	3	gainers
galleys	11	36	971	3	galleys
ganefs	10	48	920	3	g_anefs
ganevs	10	45	691	3	g_anevs
gannets	8	38	1144	3	gannets
gardens	9	33	1209	3	gardens
garganeys	14	4	261	3	garganeys
gargets	9	46	1457	3	gargets
garner	7	39	1700	3	garne_r
garnet	7	39	2841	3	garne_t
garrets	8	44	1362	3	garrets
garters	8	42	1823	3	garters
garvey	13	12	787	3	garvey_
gayness	11	3	684	3	gayness
genes	6	51	3309	3	g_ene_s
genets	7	57	1666	3	g_enets
genres	7	55	1562	3	genre_s
gerents	8	26	1292	3	gerents
germens	10	7	862	3	germens
ginners	8	43	1422	3	ginners
girders	9	37	994	3	girders
girned	8	40	1051	3	girne_d
girns	6	45	1680	3	girn__s
gleys	9	65	1485	3	g__leys
gluiness	9	3	736	3	gluiness
glumness	11	3	520	3	glumness
gonefs	10	43	987	3	g_onefs
goners	7	44	2017	3	g_oners
gooney	10	66	1231	3	gooney_
gores	6	57	4037	3	gor_e_s
gorgers	9	48	1364	3	gorgers
gorges	8	53	2189	3	gorge_s
gorgets	9	47	1178	3	gorgets
gorhens	11	3	718	3	gorhens
goriness	9	3	1075	3	goriness
gorses	7	47	2329	3	gorse_s
gourdes	9	10	938	3	gourde_s
gourmets	11	4	415	3	gourmets
grays	9	56	2133	3	g_r_ays
greeds	8	43	1428	3	g_reeds
greens	7	57	1687	3	g_reens
grees	6	51	3247	3	g_r_ees
greets	7	51	1742	3	g_reets
grey	8	56	2404	3	g_r_ey_
griefs	10	41	872	3	g_riefs
gruels	7	39	1015	3	g_ruels
grues	6	57	2196	3	g_rue_s
grumes	9	44	1555	3	grume_s
grungers	10	29	850	3	grungers
grunges	9	33	1040	3	grunges
grungy	11	34	597	3	grungy_
grunters	9	35	903	3	grunters
grunts	7	55	1185	3	grun_ts
guanay	10	3	791	3	guanay_
guanins	8	8	1001	3	guanins
guanos	7	38	1199	3	guan_os
guans	6	44	1944	3	guan__s
guarders	10	3	588	3	guarders
gudes	7	45	2081	3	gu_de_s
guenons	8	3	656	3	guenons
guernsey	12	8	148	3	guernsey_
guess	6	42	1336	3	gu__ess
guglets	9	36	969	3	guglets
guiders	9	41	1111	3	guiders
guides	8	41	1828	3	guide_s
guiles	7	39	1928	3	guile_s
guinea	7	3	761	3	guine_a
guises	7	42	1631	3	guise_s
guldens	9	35	657	3	guldens
gules	6	48	3104	3	gu_le_s
gullets	8	40	1371	3	gullets
gulley	10	42	1316	3	gulley_
gulpers	10	29	901	3	gulpers
gumless	10	22	827	3	gumless
gummers	12	37	1220	3	gummers
gunks	10	45	1772	3	gu_n_ks
gunky	13	55	1411	3	gu_nky_
gunless	8	29	963	3	gunless
gunned	8	35	1309	3	gunne_d
gunnel	7	34	1105	3	gunne_l
gunnen	7	33	871	3	gunne_n
gunner	7	38	1398	3	gunne_r
gunnery	11	37	637	3	gunnery
gunnies	8	34	1312	3	gunnies
gunny	9	44	1366	3	gu_nny_
guns	5	55	3348	3	gu_n__s
gunsels	8	33	813	3	gunsels
gurge	7	54	1978	3	gurge__
gurged	9	55	1336	3	gurge_d
gurgles	9	43	1287	3	gurgles
gurglets	10	35	554	3	gurglets
gurnard	9	4	477	3	gurnard
gurnards	10	4	363	3	gurnards
gurries	8	35	1595	3	gurries
gurry	9	45	1541	3	gur_ry_
gurshes	11	22	1003	3	gurshes
gurus	6	43	1819	3	gur__us
gushers	11	35	1251	3	gushers
gushes	10	47	1903	3	gushe_s
gussets	8	3	744	3	gussets
gutless	8	26	1071	3	gutless
gutters	8	37	1551	3	gutters
guys	8	50	1964	3	gu___ys
gyrenes	11	26	752	3	gyrenes
gyres	9	48	2032	3	gyr_e_s
harness	10	24	1393	3	harness
honeys	12	40	1608	3	_honeys
hornets	10	41	1355	3	hornets
hunkeys	17	38	619	3	hunkeys
hurlers	10	37	1432	3	hurlers
hurley	12	50	1252	3	hurley_
hurrays	13	38	615	3	hurrays
hurters	10	34	1364	3	hurters
jarveys	20	12	341	3	jarveys
jerseys	17	3	324	3	jerseys
jitneys	17	31	317	3	jitneys
journey	17	3	487	3	journey_
jurels	13	37	1058	3	jur_els
juries	13	41	2063	3	jurie_s
kernels	11	41	795	3	kernels
kernes	10	47	1753	3	kerne_s
kerseys	14	3	399	3	kerseys
kidneys	15	3	342	3	kidneys
looneys	10	48	701	3	looneys
lunes	5	53	3777	3	lu_ne_s
lunets	6	69	1476	3	lu_nets
lurers	6	42	1749	3	lur_ers
lures	5	61	3853	3	lur_e_s
lurkers	11	39	1008	3	lurkers
moneys	11	55	1362	3	_moneys
mourners	10	3	691	3	mourners
muleys	11	40	964	3	mu_leys
mulleys	12	29	920	3	mulleys
murders	10	33	1136	3	murders
mures	7	59	3722	3	mur_e_s
murines	9	37	1822	3	murine_s
murres	8	50	1904	3	murre_s
murrey	11	43	1226	3	murrey_
nursers	7	43	1183	3	nursers
nurses	6	39	1935	3	nurse_s
parleys	12	52	1237	3	parleys
phoneys	15	43	714	3	phoneys
preys	10	57	1778	3	_pr_eys
pruners	9	37	1072	3	pruners
prunes	8	34	1906	3	prune_s
pulleys	12	39	914	3	pulleys
punkeys	16	36	649	3	punkeys
punners	9	41	1423	3	punners
punnets	9	40	926	3	punnets
purees	8	47	2168	3	pur_ees
pureness	10	11	1018	3	pureness
purgers	10	47	1400	3	purgers
purges	9	44	2176	3	purge_s
purines	9	44	2076	3	purine_s
pursers	9	39	1609	3	pursers
purses	8	48	2637	3	purse_s
purvey	14	55	957	3	purvey_
pusleys	12	28	623	3	pusleys
queys	17	39	836	3	qu__eys
ruiners	7	42	1302	3	ruiners
runes	5	55	3022	3	ru_ne_s
runnels	7	32	915	3	runnels
runners	7	42	1245	3	runners
sawneys	13	27	464	3	sawneys
sorners	7	34	1687	3	sorners
sourness	8	3	954	3	sourness
spurners	10	28	849	3	spurners
spurreys	13	36	460	3	spurreys
subnets	9	25	1208	3	subnets
sunrays	10	3	708	3	sunrays
sureness	8	9	1290	3	sureness
surfers	10	36	1413	3	surfers
surgers	8	35	1748	3	surgers
surges	7	39	2459	3	surge_s
surrey	9	44	1458	3	surrey_
survey	12	41	1167	3	survey_
tawneys	13	32	477	3	tawneys
ternes	6	54	2290	3	terne_s
tourney	10	3	627	3	tourney_
treys	8	50	1821	3	_tr_eys
tuners	6	44	1734	3	tu_ners
tunes	5	53	3219	3	tu_ne_s
tunnels	7	32	872	3	tunnels
tureens	7	28	987	3	tureens
turkey	13	3	776	3	turkey_
turned	7	39	1447	3	turne_d
turner	6	39	1461	3	turne_r
turnery	10	35	742	3	turnery
turnips	9	3	501	3	turnips
turnkey	14	3	301	3	turnkey_
turnons	7	3	786	3	turnons
turns	5	56	2323	3	turn__s
turnups	9	3	389	3	turnups
turrets	7	30	1067	3	turrets
turves	9	42	1269	3	turve_s
uraeus	6	3	879	3	_uraeus
ureas	5	58	2601	3	_ur_eas
urgers	7	33	1362	3	_urgers
urges	6	46	1991	3	_urge_s
urines	6	47	2412	3	_urine_s
urns	4	63	2389	3	_urn__s
usneas	6	3	833	3	_usneas
warners	10	33	1556	3	warners
witneys	13	27	472	3	witneys
wurzels	19	3	408	3	wurzels
yarners	10	43	1220	3	yarners

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	134027	0.390	458182.1
2	DLD Change Limit	134027	314	5.780	23188.1
3	Display Results	314	314	0.110	2854.5
	(SQL Overall)	178691	314	6.280	28454.0