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

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

278 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
urd	4	64	2704	(None)
burd	7	55	3426	1	burd
curd	7	76	3498	1	curd
nurd	5	62	2434	1	nurd
surd	5	64	3381	1	surd
turd	5	60	2762	1	turd
urb	5	57	3110	1	urb
urds	5	59	2242	1	urds
urn	3	57	3146	1	urn
urp	5	64	2639	1	urp
ad	3	119	7503	2	_ad
add	5	101	3236	2	add
aid	4	92	6907	2	aid
and	4	72	4416	2	and
ar	2	113	7938	2	ar_
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
arf	6	74	5337	2	arf
arid	5	76	4271	2	arid
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
auld	5	41	2536	2	auld
aura	4	58	3625	2	aura
bad	6	77	6315	2	bad
bard	7	56	4886	2	bard
bed	6	79	5062	2	bed
bid	6	77	5178	2	bid
bird	7	61	2831	2	bird
bod	6	70	5554	2	bod
bra	5	63	3946	2	bra
brad	7	52	3434	2	brad
bred	7	51	3097	2	bred
bro	5	62	3660	2	bro
brr	5	69	2192	2	brr
bud	6	70	4127	2	bud
bund	7	55	3066	2	bund
bur	5	57	4469	2	bur_
bura	6	61	3953	2	bura
burb	8	53	3467	2	burb
burds	8	46	2606	2	burds
burg	7	49	3036	2	burg
burl	6	49	3718	2	burl
burn	6	56	3642	2	burn
burp	8	50	2888	2	burp
burr	6	56	3123	2	burr
burs	6	58	4742	2	burs
bury	9	56	3359	2	bury
cad	6	74	5636	2	cad
card	7	102	4587	2	card
cod	6	96	6012	2	cod
cord	7	67	4092	2	cord
cred	7	65	3088	2	cred
cru	5	71	2956	2	cru
crud	7	52	1961	2	crud
cry	8	97	2624	2	cry
cud	6	79	3745	2	cud
cued	7	63	2956	2	cued
cur	5	68	4198	2	cur_
curb	8	67	3222	2	curb
curds	8	57	2561	2	curds
curdy	11	59	1652	2	curdy
cure	6	61	4912	2	cure
cured	8	59	3213	2	cured
curf	9	75	3878	2	curf
curl	6	60	3505	2	curl
curn	6	67	3188	2	curn
curr	6	54	2965	2	curr
curs	6	56	4554	2	curs
curt	6	70	5171	2	curt
dad	5	84	5616	2	dad
did	5	68	5051	2	did
dry	7	65	2603	2	dry
duad	6	65	2141	2	duad
dud	5	67	3759	2	dud
dura	5	52	3211	2	dura
dure	5	63	4181	2	dure
dured	7	50	2540	2	dured
durn	5	61	2762	2	durn
duro	5	62	2802	2	duro
durr	5	56	2435	2	durr
ed	3	86	4518	2	_ed
eld	4	67	3379	2	eld
end	4	68	3435	2	end
er	2	83	4514	2	er_
era	3	57	4150	2	era
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3835	2	ern
err	3	56	2653	2	err
ers	3	60	4628	2	ers
euro	4	53	2527	2	euro
fad	7	74	5241	2	fad
fard	8	56	3906	2	fard
fed	7	65	4835	2	fed
fid	7	68	4768	2	fid
ford	8	68	3549	2	ford
fro	6	55	3064	2	fro
fry	9	62	2650	2	fry
fud	7	63	3515	2	fud
fund	8	56	2498	2	fund
fur	6	66	3732	2	fur_
furl	7	70	3088	2	furl
furs	7	67	3504	2	furs
fury	10	77	2797	2	fury
gad	5	75	5665	2	gad
ged	5	70	4453	2	ged
gid	5	70	4726	2	gid
gird	6	54	2499	2	gird
god	5	74	4979	2	god
gourd	7	10	1190	2	gourd
grad	6	68	2986	2	grad
grid	6	58	2961	2	grid
guard	7	44	1554	2	guard
guid	6	60	2282	2	guid
guru	5	46	2391	2	guru
had	7	76	5876	2	had
hard	8	54	4350	2	hard
herd	8	49	3306	2	herd
hid	7	62	4836	2	hid
hod	7	68	5246	2	hod
hued	8	69	2585	2	hued
hurds	9	52	1907	2	hurds
hurl	7	60	2993	2	hurl
hurt	7	71	4257	2	hurt
id	3	89	4183	2	_id
ire	3	69	4317	2	ire
ired	5	51	3187	2	ired
irid	5	59	2716	2	irid
irk	7	64	2636	2	irk
jura	11	60	2489	2	jura
jury	14	67	1959	2	jury
kid	8	65	4061	2	kid
kuru	8	55	2180	2	kuru
lad	4	81	6570	2	lad
lard	5	67	4200	2	lard
led	4	62	5455	2	led
lid	4	74	5351	2	lid
lord	5	50	3208	2	lord
lure	4	51	4246	2	lure
lured	6	54	2749	2	lured
lurid	6	46	1897	2	lurid
lurk	8	66	2416	2	lurk
mad	6	89	5870	2	mad
med	6	61	4674	2	med
mid	6	73	5445	2	mid
mod	6	90	5440	2	mod
mud	6	73	3686	2	mud
mura	6	56	3329	2	mura
mure	6	59	4133	2	mure
mured	8	57	2670	2	mured
murid	8	45	2058	2	murid
murk	10	55	2725	2	murk
murr	6	52	2513	2	murr
nard	5	66	3445	2	nard
nerd	5	66	2494	2	nerd
nod	4	75	4956	2	nod
nurds	6	55	1852	2	nurds
nurl	4	53	2724	2	nurl
od	3	92	5524	2	_od
odd	5	77	2545	2	odd
old	4	70	3346	2	old
or	2	73	5473	2	or_
ora	3	72	5083	2	ora
orad	5	60	3169	2	orad
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ordo	5	46	2235	2	ordo
ore	3	66	6183	2	ore
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
oud	4	74	3907	2	oud
our	3	60	4289	2	our_
ours	4	72	3756	2	ours
pad	6	80	5732	2	pad
pard	7	64	4132	2	pard
ped	6	67	5152	2	ped
pod	6	63	5148	2	pod
pro	5	58	3726	2	pro
prod	7	61	2950	2	prod
pry	8	57	2805	2	pry
pud	6	58	3665	2	pud
pur	5	68	4055	2	pur_
purda	8	29	1469	2	purda
pure	6	55	4333	2	pure
puri	6	59	3144	2	puri
purl	6	56	3142	2	purl
purr	6	49	2581	2	purr
purs	6	56	4104	2	purs
quad	14	46	1870	2	quad
quid	14	49	2235	2	quid
quod	14	54	1362	2	quod
rad	4	76	6200	2	rad
re	2	61	5374	2	_re
red	4	67	5580	2	red
rid	4	67	5462	2	rid
rod	4	79	5389	2	rod
rub	5	63	4282	2	rub
rudd	6	59	1747	2	rudd
rude	5	56	3278	2	rude
rue	3	55	4926	2	rue
rued	5	57	2979	2	rued
rug	4	60	3915	2	rug
rum	5	66	4464	2	rum
run	3	62	4498	2	run
rut	3	55	6052	2	rut
sad	4	74	5920	2	sad
sard	5	53	4424	2	sard
sod	4	60	5370	2	sod
sord	5	62	3720	2	sord
sri	3	56	3400	2	sri
sudd	6	47	1977	2	sudd
sued	5	65	3793	2	sued
sura	4	57	4029	2	sura
surds	6	56	2466	2	surds
sure	4	54	4741	2	sure
surf	7	60	3931	2	surf
tad	4	79	5982	2	tad
ted	4	64	4656	2	ted
tod	4	94	5707	2	tod
trad	5	56	3091	2	trad
trod	5	76	2795	2	trod
try	6	65	2967	2	try
turds	6	50	2169	2	turds
turf	7	53	3405	2	turf
turk	8	61	2586	2	turk
turn	4	63	3038	2	turn
udo	4	90	2730	2	udo
ugh	7	65	2068	2	ugh
uh	5	74	2985	2	u_h
uke	7	57	2729	2	uke
ulu	3	60	2870	2	ulu
um	4	73	3883	2	u_m
umm	7	119	2126	2	umm
ump	7	61	3044	2	ump
un	2	83	4113	2	u_n
unde	5	58	2548	2	unde
undo	5	56	2015	2	undo
undy	8	50	1516	2	undy
uns	3	59	3675	2	uns
up	4	78	3282	2	u_p
updo	7	67	1288	2	updo
upo	5	89	2586	2	upo
ups	5	56	2905	2	ups
urbs	6	59	2205	2	urbs
urea	4	65	2805	2	urea
uredo	6	51	1299	2	uredo
urge	5	47	2241	2	urge
urged	7	53	1603	2	urged
uric	6	36	2493	2	uric
urns	4	63	2389	2	urns
urped	8	46	1528	2	urped
urps	6	69	2047	2	urps
ursa	4	41	1690	2	ursa
ursid	6	3	1148	2	ursid
urus	4	64	2613	2	urus
us	2	69	3743	2	u_s
use	3	68	3516	2	use
used	5	57	2282	2	used
ut	2	86	4703	2	u_t
uta	3	74	2558	2	uta
ute	3	53	3588	2	ute
uts	3	55	3437	2	uts
vid	7	72	4180	2	vid
wad	7	70	5389	2	wad
ward	8	65	4225	2	ward
wed	7	58	4362	2	wed
word	8	98	3200	2	word
wry	9	65	2470	2	wry
wud	7	62	2715	2	wud
yard	8	56	3325	2	yard
yid	7	66	4082	2	yid
yird	8	70	1898	2	yird
yod	7	75	4550	2	yod
yurt	7	64	3504	2	yurt
zed	13	54	3117	2	zed

Search took 1 second 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	14084	0.060	2978183.3
2	DLD Change Limit	14084	278	0.406	34689.7
3	Display Results	278	278	0.063	4412.7
	(SQL Overall)	178691	278	0.529	337790.2