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 “espial” 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.

301 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
espial83954(None) 
espials937091espials
bestial9311642bestial
despisal1144672despisal
epical10413392e_pical
especial1246292especial
espied9359772espied
espies83716802espies
estival1036322estival
estral64716512estral
mesial84818082mes_ial
pial65636702__pial
sepal77723002sep_al
sepia75318672sepia_
sepias83616102sepias
septal84513382septal
serial64625862serial
sial45938832_s_ial
spail74921552_spail
spiel74623912_spiel
spill74821162_spill
spinal84915312_spinal
spiral83715342_spiral
spital83813872_spital
aecial84817313aecial
aerial64625713aerial
aestival1145483aestival
apian75018333_apian
apical10913903_apical
appal95315223_appal
appeal103911613appeal
apsidal1046703apsidal
asocial998653asocial
asphalt1248083asphalt
aspic95114733aspi_c
aspics104211563aspics
aspire8612123aspire
aspis74618143aspi_s
aspish114810333aspish
assail6610153assail
astral66919283astral
aswirl935093aswirl
atrial65418943atrial
audial7312993audial
axial124515193_axial
bespeak1544573bespeak
burial84117623burial
capias10318353capias
capital112311523capital
copal95621783cop_al
curial84019153curial
cuspal1037883cusp_al
cuspidal1343473cuspidal
decrial10310323decrial
denial74720513denial
despair1045463despair
despisals1243503despisals
despise1038683despise
despite10410123despite
despoil1046523despoil
dial55935063__dial
egal55119433e__gal
eluvial1045853eluvial
email74715103emai_l
empale102611263emp_ale
empire1039323empire
encinal949243encinal
entail61114343entail
entia5318203entia_
eolian6312593eolian
eonian6311833eonian
epha9310053e_pha_
ephah1337063e_phah
ephas10311543e_phas
epic86921303e_pi_c
epics95014283e_pics
epigeal1046243e_pigeal
equal1449823e_qual
ervil8310303ervi_l
escar74011993es_car
eschar1136523eschar
eskar9457453es_kar
espanol943783espanol
espiegle1142603espiegle
espousal1083013espousal
esprit8312843esprit
esprits938393esprits
espy969373esp__y
espying1336193espying
essay867623es_say
estray95713333estray
estriol747553estriol
estrual7367933estrual
ethical1238443ethical
eusocial1045463eusocial
evil75318073e_vi_l
expat14313813exp_at
expel1448233exp_el
expiable1946113expiable
expiate16910593expiate
expire1538023expire
expiry1834653expiry
exposal1645313exposal
exuvial1744253exuvial
facial113615633facial
fascial1258303fascial
fecial114714623fecial
ferial94621253ferial
festal94213563fes_tal
festival1444713festival
fetial95716193fetial
filial93013253filial
finial92814183finial
gavial10310083gavial
genial74917613genial
gestical1138983gestical
glial66715433_glial
hernial10310433hernial
hessian1035853hessian
hospital1344743hospital
hyphal1736413hyphal
ilial55317843_ilial
ischial1246423ischial
jovial1636543jovial
keypal1534893keyp_al
labial84714343labial
lesbian944463lesbian
loessial843783loessial
medial93819863medial
menial84223033menial
mescal104113483mes_cal
mesian84315503mes_ian
messiah1246793messiah
misdial1039643misdial
narial6317953narial
nasial6413283nasial
nopal75517103nop_al
nuptial946633nuptial
oedipal1045173oedipal
opal66923523_op_al
ossia53710403ossia_
osteal6312963osteal
ostia52315583ostia_
pail66141833__pail
pal56761673__p_al
papal95820673pap_al
peal68648103__peal
penial84120893penial
phial10313203_phial
pia56848033__pia_
pian66136093__pian
pias66542553__pias
pibal95217323__pibal
pical95524373__pical
pill65339463__pill
pipal95118353__pipal
pupal97616873pup_al
pupil94712983pupi_l
racial83419243racial
radial74020393radial
redial74923113redial
repeal84718283repeal
resail64418733resai_l
reseal64819643res_eal
respeak1335933respeak
respell947023respell
respire9411543respire
respite9513033respite
respool937643respool
respray1236503respray
retial64724993retial
retrial7615553retrial
rial45938093__rial
rupiah1146213rupiah
sabal75422483_sabal
sail45447163_sai_l
sal36462883_s__al
salal55425703_salal
seal45654373_s_eal
seminal91213403seminal
sendal73314993sendal
sepals85217373sep_als
sepic94617053sepi_c
septa75518083septa_
septical1259363septical
serail64222673serail
seral56336383_seral
serials73919743serials
serval93913413serval
setal56430903_setal
sexual1338413sexual
sheal84927703_sheal
shiel811023773_shiel
shill85325333_shill
shoal83920273_shoal
sials54227243_s_ials
sill45545153_s_ill
sisal54217733_sisal
skill94316723_skill
skirl96012913_skirl
skoal93811463_skoal
snail57020203_snail
social8813333social
soil46138833_soi_l
spa55730813_sp_a_
spacial1138763_spacial
spae65034323_sp_ae
spails84817823_spails
spait75631603_spait
spale74929213_sp_ale
spall74919303_spall
spam85930043_sp_am
span65234663_sp_an
spar65433303_sp_ar
spas67036723_sp_as
spat66548523_sp_at
spatial9310323_spatial
spay96631663_sp_ay
spaz155626163_sp_az
speak114618673_speak
spean74620513_spean
spear75821063_spear
special11310303_special
speel74420763_speel
speil75618643_speil
spell75020303_spell
spic85227433_spi_c
spica94717943_spica
spicae104313703_spicae
spicas104715823_spicas
spice95528813_spice
spick134519073_spick
spics94123243_spics
spicy125417713_spicy
spied85427713_spied
spiels85317953_spiels
spier75728033_spier
spies76037623_spies
spiff133616403_spiff
spik105419713_spi_k
spike114922843_spike
spiks114117473_spiks
spiky146014113_spiky
spile75230083_spile
spills84717463_spills
spilt75532223_spilt
spin66231303_spi_n
spinals93911863_spinals
spine76534423_spine
spinel85317333_spinel
spins75327983_spins
spiny104921303_spiny
spirals93212513_spirals
spire75828693_spire
spirt75032953_spirt
spiry105017353_spiry
spit65545083_spi_t
spitals93011593_spitals
spite75430663_spite
spits74429553_spits
spitz166017973_spitz
spiv95917793_spi_v
spivs105114243_spivs
splat76129343_splat
splay105816043_splay
spoil75818653_spoil
spool75219043_spool
sporal82915453_sporal
sprag86418693_sprag
sprat76635973_sprat
sprawl11188063_sprawl
spray106720063_spray
steal56125473_steal
still54922083_still
sural55931263_sural
swail86217163_swail
swill83417373_swill
swirl84514143_swirl
telial65815363telial
tepal76319583tep_al
tertial7313863tertial
thespian1343203thespian
tibial849843tibial
topical1139953topical
trial54926353_trial
typal105311153typ_al
typical1436343typical
uncial83715223uncial
urial54823023_urial
usual5310183us_ual
venial94218283venial
vesical12159813vesical
vesperal1344883vesperal
vespiary1642743vespiary
vespid1246083vespi_d
vespids1334613vespids
vespine1237903vespine
vestal94615573ves_tal
vestral104111013vestral
vial76731093__vial
xenial133414903xenial

Search took 10 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163019.61011729.0
3Display Results3013010.0933236.6
 (SQL Overall)1786913019.84318154.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.