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

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

333 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
safari	9	11	1022	(None)
safaris	10	11	1066	1	safaris
acari	7	50	2028	2	_acari
afar	7	67	2078	2	_afar_
afars	8	57	1651	2	_afars
laari	5	44	1571	2	la_ari
safaried	12	3	625	2	safaried
safer	8	47	2181	2	safer_
salami	8	3	1310	2	salami
salary	9	5	1521	2	salary
samara	8	3	1385	2	samara
sari	4	54	4404	2	s__ari
satara	6	3	1553	2	satara
satori	6	4	1584	2	satori
savarin	10	3	1000	2	savarin
sofar	8	61	1549	2	sofar_
sofars	9	47	1278	2	sofars
souari	6	3	1138	2	souari
suffari	13	4	550	2	suffari
tamari	8	3	1340	2	tamari
uakari	10	4	686	2	uakari
abaci	9	47	1884	3	_abaci
abri	6	55	2221	3	_a_bri
acarid	9	50	1707	3	_acarid
afeard	10	5	826	3	_afeard
affair	12	3	435	3	affair
afire	8	62	1591	3	_afire
afore	8	58	1860	3	_afore
afraid	10	4	972	3	_afraid
afrit	8	3	2317	3	_af_rit
agar	5	87	2641	3	_agar_
agaric	9	35	1363	3	_agaric
agars	6	61	2064	3	_agars
ajar	11	62	1770	3	_ajar_
alar	4	63	4007	3	_alar_
alarm	7	66	2142	3	_alarm
alary	8	61	2344	3	_alary
alfaki	13	8	538	3	alfaki
ambari	10	30	1217	3	ambari
apart	7	43	3067	3	_apart
ascarid	10	39	1072	3	ascarid
ascaris	9	36	1332	3	ascaris
assai	5	7	1154	3	assa_i
aswarm	11	10	791	3	aswarm
award	9	71	1804	3	_award
aware	8	64	2002	3	_aware
bayard	12	44	1166	3	bayard
bazar	16	38	1600	3	bazar_
bazars	17	46	1311	3	bazars
calami	10	3	1342	3	calami
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
carfare	12	3	1007	3	carfare
curari	8	44	1440	3	curari
dalasi	7	6	1062	3	dalasi
damar	8	41	1773	3	damar_
damars	9	38	1499	3	damars
datary	10	3	1024	3	datary
denari	7	109	1735	3	denari
fair	7	63	3252	3	__fair
fanfare	13	3	667	3	fanfare
far	6	77	6260	3	__far_
farci	10	59	1931	3	__farci
fard	8	56	3906	3	__fard
fare	7	63	5446	3	__fare
farl	7	63	3855	3	__farl
farm	9	59	3453	3	__farm
faro	7	61	3692	3	__faro
fart	7	68	6056	3	__fart
gazar	15	46	1298	3	gazar_
gazars	16	48	1155	3	gazars
haar	7	73	2349	3	ha_ar_
haars	8	56	2047	3	ha_ars
hadarim	13	11	745	3	hadarim
haftara	13	13	609	3	haftara
havarti	13	4	505	3	havarti
hazard	19	3	840	3	hazard
hegari	10	3	952	3	hegari
infare	9	3	1308	3	infare
kabar	11	48	1555	3	kabar_
kabars	12	45	1395	3	kabars
kaffir	16	34	530	3	kaffir
kafir	12	48	890	3	kafir_
kafirs	13	30	698	3	kafirs
kauri	9	38	1185	3	ka_uri
labara	8	37	1289	3	labara
lahar	8	31	1426	3	lahar_
lahars	9	40	1316	3	lahars
lanai	5	3	1957	3	lana_i
lari	4	58	3915	3	__lari
lazar	14	41	1364	3	lazar_
lazars	15	38	1239	3	lazars
maar	6	60	2506	3	ma_ar_
maars	7	46	2163	3	ma_ars
maftir	11	3	649	3	maftir
makar	11	56	1497	3	makar_
makars	12	46	1263	3	makars
malar	7	64	2444	3	malar_
malaria	9	3	1369	3	malaria
malars	8	50	2068	3	malars
mazard	18	3	876	3	mazard
navar	8	39	1273	3	navar_
navars	9	28	1057	3	navars
ourari	6	34	1354	3	ourari
padri	8	58	1517	3	pa_dri
papyri	13	3	490	3	papyri
radar	6	13	1672	3	radar_
radars	7	13	1467	3	radars
sabal	7	54	2248	3	saba_l
sabals	8	46	1886	3	sabals
saber	7	53	3024	3	saber_
sabers	8	52	2473	3	sabers
sabir	7	59	1700	3	sabir_
sabirs	8	54	1463	3	sabirs
sabra	7	53	1785	3	sa_bra
sabras	8	51	1636	3	sabras
sabre	7	48	2150	3	sa_bre
sacra	7	45	1699	3	sa_cra
sacral	8	34	1441	3	sacral
sacraria	10	4	739	3	sacraria
sadi	5	58	3464	3	s__adi
safariing	13	4	455	3	safariing
safe	7	59	3095	3	saf__e
safely	12	24	939	3	safely
safes	8	52	2672	3	saf_es
safest	9	50	1660	3	safest
safety	12	20	691	3	safety
saffron	13	4	417	3	saffron
safranin	11	4	521	3	safranin
safrol	9	3	728	3	safrol
saga	5	53	3117	3	saga__
sagas	6	60	2588	3	saga_s
sager	6	54	3205	3	sager_
saggar	8	40	1085	3	saggar_
saggard	10	35	895	3	saggard
saggars	9	36	1068	3	saggars
saguaro	8	4	551	3	saguaro
sahuaro	10	4	423	3	sahuaro
saker	9	51	3202	3	saker_
sakers	10	41	2543	3	sakers
saki	8	56	2848	3	s__aki
salaam	8	7	1101	3	salaam
salad	6	53	2183	3	sala_d
salads	7	53	1696	3	salads
salal	5	54	2570	3	sala_l
salals	6	51	2008	3	salals
salamis	9	3	1351	3	salamis
salariat	8	4	1630	3	salariat
salaried	9	3	1102	3	salaried
salaries	8	3	1957	3	salaries
salmi	7	8	1586	3	sa_lmi
saluki	10	3	620	3	saluki
samadhi	13	4	406	3	samadhi
samaras	9	3	1291	3	samaras
samarium	12	5	728	3	samarium
sambar	10	39	1416	3	sambar_
sambars	11	51	1384	3	sambars
samsara	9	3	691	3	samsara
samurai	9	4	592	3	samurai
sandhi	10	3	819	3	sandhi
saner	5	43	3432	3	saner_
sangar	7	36	1768	3	sangar_
sangars	8	31	1625	3	sangars
sangria	8	3	811	3	sangria
sansar	6	36	1339	3	sansar_
sansars	7	33	1391	3	sansars
sansei	6	34	1190	3	sansei
santir	6	3	1525	3	santir
sapor	7	51	1925	3	sapor_
sapors	8	41	1881	3	sapors
saran	5	37	3030	3	sara_n
sarans	6	42	2443	3	sarans
sarape	8	48	1757	3	sarape
sard	5	53	4424	3	s__ard
sardar	7	30	1317	3	sardar_
sardars	8	31	1290	3	sardars
sarin	5	52	3925	3	s__arin
saris	5	45	4495	3	s__aris
sark	8	49	3897	3	s__ark
sarsar	6	30	1184	3	sarsar_
sarsars	7	35	1214	3	sarsars
satang	7	57	1156	3	satang
satanic	9	3	993	3	satanic
sataras	7	3	1506	3	sataras
satay	8	47	1846	3	sata_y
satays	9	44	1168	3	satays
sati	4	55	3933	3	s__ati
satire	6	32	1800	3	satire
satiric	9	3	924	3	satiric
satoris	7	3	1725	3	satoris
satrap	8	62	1255	3	satrap
satyr	8	4	848	3	satyr_
satyric	12	3	749	3	satyric
satyrid	11	3	723	3	satyrid
satyrs	9	3	796	3	satyrs
saury	8	43	1722	3	sa_ury
savage	10	4	1017	3	savage
savant	9	4	1604	3	savant
savarins	11	3	989	3	savarins
savate	9	3	1378	3	savate
saver	8	48	3125	3	saver_
savers	9	38	2592	3	savers
savor	8	54	1794	3	savor_
savors	9	56	1610	3	savors
savory	12	43	1056	3	savory
sawer	8	50	2621	3	sawer_
sawers	9	46	2016	3	sawers
sayer	8	49	2655	3	sayer_
sayers	9	42	2159	3	sayers
scalar	8	36	1243	3	scalar_
scalare	9	33	1183	3	scalare
scalars	9	37	1190	3	scalars
scar	6	64	3420	3	s_car_
scare	7	53	3446	3	s_care
scarf	10	54	2714	3	s_carf
scarp	9	57	2410	3	s_carp
scars	7	54	3353	3	s_cars
scart	7	61	3977	3	s_cart
scary	10	52	2259	3	s_cary
seafarer	11	4	484	3	seafarer
seafaring	13	4	596	3	seafaring
seamark	13	3	672	3	seamark
sear	4	73	5384	3	s_ear_
sears	5	47	4491	3	s_ears
seaward	11	4	818	3	seaward
seaware	10	4	963	3	seaware
sedarim	10	4	711	3	sedarim
senarii	7	26	914	3	senarii
senary	9	37	1607	3	senary
serai	5	68	3016	3	sera_i
sewar	8	54	2110	3	sewar_
sewars	9	40	1863	3	sewars
shard	9	61	2596	3	s_hard
share	8	64	3708	3	s_hare
sharia	9	31	1673	3	s_haria
sharif	12	29	1712	3	s_harif
shark	12	62	2502	3	s_hark
sharn	8	48	2370	3	s_harn
sharp	10	49	2253	3	s_harp
shear	8	54	2483	3	shear_
shears	9	38	2090	3	shears
shikari	14	4	451	3	shikari
shofar	12	3	631	3	shofar_
shofars	13	3	583	3	shofars
shri	7	60	2170	3	s__hri
sifaka	13	5	355	3	sifaka
simar	7	49	2081	3	simar_
simars	8	49	1693	3	simars
sitar	5	48	2054	3	sitar_
sitars	6	54	1759	3	sitars
sizar	14	52	1499	3	sizar_
sizars	15	48	1262	3	sizars
smarm	9	55	1760	3	s_marm
smart	7	58	3409	3	s_mart
smear	7	44	1639	3	smear_
smears	8	47	1443	3	smears
smeary	11	41	1080	3	smeary
snare	5	44	2998	3	s_nare
snarf	8	65	2542	3	s_narf
snark	9	54	1994	3	s_nark
snarl	5	49	2108	3	s_narl
soar	4	68	3867	3	s_oar_
soars	5	47	3251	3	s_oars
sofa	7	56	2560	3	sofa__
sofas	8	53	2071	3	sofa_s
solar	5	59	2734	3	solar_
solaria	7	3	1249	3	solaria
sonar	5	65	2342	3	sonar_
sonars	6	48	1897	3	sonars
sori	4	60	3984	3	s__ori
souaris	7	3	1233	3	souaris
sowar	8	58	2134	3	sowar_
sowars	9	43	1801	3	sowars
spahi	10	3	1114	3	s_pahi
spar	6	54	3330	3	s_par_
spare	7	51	3556	3	s_pare
sparid	9	40	1693	3	s_parid
spark	11	49	2089	3	s_park
spars	7	54	3154	3	s_pars
spear	7	58	2106	3	spear_
spears	8	40	1947	3	spears
square	15	45	1336	3	square
squark	19	43	811	3	squark
sri	3	56	3400	3	s___ri
stair	5	47	1994	3	s_tair
star	4	80	3776	3	s_tar_
stare	5	44	4026	3	s_tare
stark	9	54	2562	3	s_tark
stars	5	58	3657	3	s_tars
start	5	56	4231	3	s_tart
stearic	9	3	942	3	stearic
stearin	7	3	1200	3	stearin
stoai	5	54	1787	3	stoa_i
strati	6	35	1890	3	strati
subarid	10	3	1065	3	subarid
sudaria	8	4	797	3	sudaria
sudary	10	3	870	3	sudary
suffaris	14	4	508	3	suffaris
sugar	6	3	1291	3	sugar_
sugars	7	3	1242	3	sugars
sugary	10	3	901	3	sugary
swami	10	56	1452	3	s_wami
sward	9	42	2146	3	s_ward
sware	8	58	2821	3	s_ware
swarf	11	53	2465	3	s_warf
swarm	10	62	1884	3	s_warm
swart	8	62	3464	3	s_wart
swear	8	53	1685	3	swear_
swears	9	41	1407	3	swears
tabard	9	3	1333	3	tabard
talar	5	62	2538	3	talar_
talaria	7	4	1251	3	talaria
talars	6	60	2168	3	talars
tamarin	9	3	1191	3	tamarin
tamaris	9	4	1359	3	tamaris
tatami	8	3	919	3	tatami
tatar	5	61	2206	3	tatar_
tatars	6	46	1979	3	tatars
uakaris	11	4	663	3	uakaris
unfair	9	3	623	3	unfair
urari	5	46	1996	3	_urari
vagary	13	3	733	3	vagary
vaward	13	49	872	3	vaward
wafer	11	44	1764	3	wafer_
wafers	12	43	1614	3	wafers
wafery	15	39	869	3	wafery
warfare	13	3	673	3	warfare
warfarin	14	4	498	3	warfarin
wasabi	11	5	464	3	wasabi
zaffar	21	38	504	3	zaffar_
zaffars	22	32	523	3	zaffars
zaffir	21	39	551	3	zaffir
zaffre	21	35	466	3	zaffre

Search took 6 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	112716	0.376	475242.0
2	DLD Change Limit	112716	333	5.453	20670.5
3	Display Results	333	333	0.110	3027.3
	(SQL Overall)	178691	333	5.939	30087.7