Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

316 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ephah133706(None) 
epha9310051epha_
ephahs1435501ephahs
ephas10311541ephas
ephod1139122ephod
ephor10310012ephor
epoch1248202epoch
hah910655222__hah
opah96218402op_ah
pah88853592_p_ah
phat95837862_phat
shah105627782_shah
aah616252963__aah
agha87417303agha_
aghas97014873aghas
ah513868793___ah
aha611246643_aha_
almah106917253almah
alpha1049653alpha_
alphas1139513alphas
amah98927483_amah
apeak115513453apeak
aphid115515393aphid
aphis105917133aphis
aphtha1444483aphtha
apian75018333apian
apish105116633apish
appal95315223appal
arhat8327093arhat
ayah108022993_ayah
bah87755353__bah
bimah127013263bimah
blah98625063_blah
chad105525503_chad
chai95929903_chai
cham115532313_cham
chao95727313_chao
chap114928493_chap
char95132153_char
chat95546133_chat
chaw126224633_chaw
chay124924873_chay
coprah133710603coprah
dah78148983__dah
depth114311853dep_th
dhak125512033_dhak
dhal86719283_dhal
each95530583e_ach
ear36867883e__ar
earth85023053earth
eat36989053e__at
eath75735663e_ath
eau37450943e__au
echard1249223echard
eche97520283ech_e
eched116919223eched
eches106322163eches
echo96615953ech_o
echos105216463echos
echt95722903ech_t
eclat7523603eclat
edh76921563e__dh
edhs86212103edh_s
egad64215413e_gad
egal55119433e_gal
eggar7458883eggar
eh58339963e___h
eighth133310603eighth
elan46734243e_lan
elhi7612403elh_i
embar94011593embar
embay123410593embay
emdash12244113emdash
encash11276943encash
endash10297123endash
enhalo987563enhalo
epact94921533epact
eparch13258423eparch
epee64628503ep_ee
epees75219833epees
ephebe1336063ephebe
ephebi1345083ephebi
ephods1238363ephods
ephoral1248403ephoral
ephori1139603ephori
ephors11311403ephors
epic86921303ep_ic
epical10413393epical
epics95014283epics
epitaph1444133epitaph
epochal1445243epochal
epochs1335813epochs
epode85114093epode
epos66723733ep_os
epoxy17465773epoxy
equal1449823equal
era35741503e_ra_
eras45441503e_ras
escar74011993escar
eschar1136523eschar
eskar9457453eskar
espial839543espial
essay867623essay
eta35834193e_ta_
etas46432273e_tas
etch95419143e_tch
eth66630983e__th
ethane94613243ethane
ether84518773ether
ethic101511223ethic
ethos85514193ethos
eths76619523eth_s
ethyl1136513ethyl
etna46415263etna_
etnas54713933etnas
exam132514623e_xam
exhale1636873exhale
expat14313813expat
eyas76427433e_yas
eyra76217553eyra_
eyras84715923eyras
fellah124910773fellah
galah95917623galah
gerah9315303gerah
ghat86435283_ghat
ha510259943__ha_
had77658763__had
hae67364003__hae
hag77255743__hag
haha107821063__haha
hahas117118443hahas
hahs108333363__hahs
haj138140603__haj
ham86363283__ham
hao67251123__hao
hap87360053__hap
has67372653__has
hash106936503__hash
hat67289963__hat
hath105933913__hath
haw97153273__haw
hay97358773__hay
heehaw1543933heehaw
heh96039623__heh
hepcat13611823hepcat
heptad1237273heptad
horah117922043horah
huh96432013__huh
huppah1644183huppah
hypha1637383hypha_
hyphae1746433hyphae
hyphal1736413hyphal
jehad1637683jehad
jihad1635913jihad
jubhah2142803jubhah
keblah1545313keblah
keddah1534263keddah
khaf145319603_khaf
khan115819143_khan
khaph17395963_khaph
khat116730723_khat
lahar83114263lahar
lepta75714393lepta_
lethal939803lethal
lotah85315853lotah
mynah13569563mynah
nah69847003__nah
nephew1434113nephew
obeah1038993obeah
odah87018933_odah
ogham1138253ogham
opahs105411983opahs
opal66923523op_al
orphan1137733orphan
pa410456483_p_a_
pac79054083_p_ac
pad68057323_p_ad
pal56761673_p_al
pam77858393_p_am
pan58466443_p_an
pap76758403_p_ap
par57467023_p_ar
pas58775743_p_as
pash95638133_pash
pat58089463_p_at
path99134913_path
paw87651173_p_aw
pax127346853_p_ax
pay88461183_p_ay
pea56657243_pea_
peach125422493peach
peag75431343_peag
peak106535203_peak
peal68648103_peal
pean66147173_pean
pear69745233_pear
peas65755063_peas
peat65967933_peat
pecan91919033pecan
pech116125453_pech
pechan13511543pechan
pedal86022503pedal
peh86740963_p_eh
pehs95625763peh_s
pekan111613973pekan
penal75228373penal
pepla9312863pepla_
perch124518833perch
petal76526893petal
phage115113673_phage
phase104617213_phase
phew128417113_phew
phi86524203_ph_i
phial10313203_phial
phis95724903_phis
phiz186718843_phiz
phon95925383_phon
phot95534353_phot
phpht1538063_phpht
pht86030523_ph_t
phut96925973_phut
pia56848033_pia_
pial65636703_pial
pian66136093_pian
pias66542553_pias
pish96127913_pish
pith95432693_pith
plan65833943_plan
plash104616563_plash
plat66048873_plat
play95928983_play
poach124917863_poach
poh86740533_p_oh
pooh96027383_pooh
posh95427323_posh
prahu105013973_prahu
pram85733493_pram
prao66229023_prao
prat65952043_prat
prau66529473_prau
pray96331533_pray
pshaw13447513pshaw
pugh106619233_pugh
pujah17478543pujah
push95526623_push
pya87023753_pya_
pyas96225703_pyas
rah68052403__rah
rajah155711423rajah
raphae114311733raphae
rayah116013503rayah
rehab10312443rehab
rehash1237433rehash
repay104818453rep_ay
repeal84718283repeal
repeat85127213repeat
replan83215823replan
replay113412923replay
rupiah1146213rupiah
schav1338313schav
selah8319613selah
sepal77723003sep_al
sepia75318673sepia_
sepias83616103sepias
septa75518083septa_
septal84513383septal
sha69837783_sha_
shad86230913_shad
shag86430563_shag
shahs115919513_shahs
sham96436353_sham
shat76456593_shat
shaw108132553_shaw
shay107133343_shay
shh97121073_sh_h
spa55730813sp_a_
spae65034323sp_ae
spahi10311143spahi
spam85930043sp_am
span65234663sp_an
spar65433303sp_ar
spas67036723sp_as
spat66548523sp_at
spay96631663sp_ay
spaz155626163sp_az
speak114618673speak
spean74620513spean
spear75821063spear
splash1168823splash
splat76129343splat
splay105816043splay
sprag86418693sprag
sprat76635973sprat
spray106720063spray
subah106015213subah
surah86823253surah
tepa66021683tep_a_
tepal76319583tep_al
tepas76521683tep_as
tephra1136483tephra
tephras1236283tephras
thae76825563_thae
than76128773_than
that75639323_that
thaw107521313_thaw
torah87125273torah
unhat81119263unhat
upas68322383up_as
upheap13105213upheap
wha96422073_wha_
wham125321693_wham
whap125119643_whap
what105434073_what
yah99046353__yah
yeah106725413_yeah
zephyr2342083zephyr

Search took 5 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691836670.1061685764.2
2DLD Change Limit836673163.83021845.2
3Display Results3163160.0764157.9
 (SQL Overall)1786913164.01244539.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.