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

523 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
aortal6521751(None) 
aorta55922571aorta_
aortae65115471aortae
aortas65417781aortas
artal55525471a_rtal
mortal84616851mortal
portal84218461portal
aboral8314372abor_al
acetal84314902acetal
aerial64625712aerial
amoral8314632amor_al
antral65719412antral
aortic8316612aortic
areal55928732a_real
argal65023392a_rgal
artel56122742a_rtel
arval86017012a_rval
astral66919282astral
atrial65418942atrial
aural54428962aur_al
boral75831702bor_al
boreal84817212boreal
borstal939042borstal
coital84117052coital
coral76033452cor_al
corral83616252corral
costal85419512costal
curtal83914542curtal
dorsal74613942dorsal
dotal64919622do_tal
foetal9311882foetal
fontal9313142fontal
formal113215202formal
goral65125752gor_al
hartal9415472hartal
horal86328682hor_al
loral55927822lor_al
loreal63814312loreal
moral75533432mor_al
mortals93914012mortals
mortar83812042mortar
normal83213532normal
notal55221352no_tal
octal71214722_octal
oral47638122_or_al
portals94015562portals
postal84317532postal
sorta57125412sorta_
torta55925352torta_
tortas64918252tortas
total55321822to_tal
aal39058673a___al
abettal946073abettal
abnormal1244093abnormal
abort76133583abort__
aborted10310423aborted
aborter939933aborter
aborts84916183abort_s
abortus9397913abortus
abroad9310943abroad
abuttal954553abuttal
accrual1144553accrual
aceta74017353aceta_
acetals93411353acetals
acetyl11396553acetyl
acta69524803a_cta_
actual8311023actual
adrenal838263adrenal
adyta936853adyta_
aecial84817313aecial
aerate64830553aerate
aerials74017553aerials
agita6315423agita_
agitas7310593agitas
agonal7410053agonal
agora6914333agor_a_
agorae7511203agor_ae
agoras7613343agor_as
agrestal945653agrestal
agria65517143agria_
agrias74315393agrias
airbag956963airbag
airmail946213airmail
airman82414223airman
airt45757783airt__
airted74214503airted
airth85621023airt_h
airths95414253airths
airts55626343airt_s
airway1237693airway
algal66518223a_lgal
alodial899953alodial
altar55520643a_ltar
amatol838693amatol
amort75832203amort__
amrita8411133amrita_
amritas939093amritas
amtrac10109133amtrac
anal48037523a__nal
animal85016253animal
annal56520763a_nnal
anneal64812293anneal
annual64710703annual
anodal72512123anodal
anorak1038923anor_ak
anta46839583a_nta_
antae56828293a_ntae
antas55432033a_ntas
antra56521923antra_
anural65714743anural
aorist64827873aorist
aoudad835043aoudad
apetaly1237253apetaly
apical10913903apical
apneal83411123apneal
apodal9289833apodal
apogeal1045623apogeal
aporia8315863aporia_
aporias9315153aporias
aport75432173aport__
apostil947903apostil
appal95315223a_ppal
appeal103911613appeal
arak86929573a_r_ak
arboreal1045633arboreal
area45843393a_rea_
areae55229743a_reae
areas55935773a_reas
argala74712673a_rgala
argali75013753a_rgali
argals75517713a_rgals
argil65116883a_rgil
argol65317263a_rgol
arhat8327093a_rhat
aria46245423a_ria_
arias55438023a_rias
ariel55228973a_riel
aril45843023a_r_il
armorial1049453armorial
aroma71220143aroma_
aromas81018613aromas
arousal748633arousal
arras55626133a_rras
array86317143a_rray
arrayal1055843arrayal
arrear6310253arrear
arrival1037563arrival
art38679143a_rt__
artels66216233a_rtels
artful968273a_rtful
artily92814713a_rtily
arts49650263a_rt_s
artsy86012963a_rtsy
arty77531313a_rt_y
aryl75922343a_r_yl
asocial998653asocial
astrals75515243astrals
astray95615543astray
atabal839743atabal
atap66722453a__tap
atlatl637873atlatl
atonal6514023atonal
atria56022343atria_
attar56516693a_ttar
audial7312993audial
aura45836253aur_a_
aurae54128113aur_ae
aurar54420253aur_ar
auras55932563aur_as
aurate64426473aurate
auroral7310473auroral
austral73411513austral
avatar937523avatar
avowal1246323avowal
axal116520493a__xal
axial124515193a_xial
axonal1347653axonal
azonal1568273azonal
barbal104016663barbal
boatel84314093boatel
bobtail1146553bobtail
bora66141633bor_a_
borals86721913bor_als
boras75938303bor_as
borate85026153borate
borax145918723bor_ax
bordel94514573bordel
boreas85421733boreas
borstals1037473borstals
bort65960963bort__
borts76735453bort_s
borty105522833bort_y
bortz165722203bort_z
bota66236503bo_ta_
botas75328783bo_tas
botel75121863bo_tel
bromal10313653bromal
brutal859383brutal
burial84117623burial
bursal84414823bursal
cantal84122033cantal
capital112311523capital
caporal11410943capor_al
carnal83919213carnal
carpal103716253carpal
cartel85022533cartel
cental84420963cental
cercal10314123cercal
cereal8315833cereal
chital114313883chital
choral115118493chor_al
chordal13449883chordal
choreal124412223choreal
chorial124214143chorial
citral81113893citral
coal66939253co__al
coastal9411043coastal
coaxal15387303coaxal
coccal9310223coccal
coeval1138893coeval
comal95125133co_mal
copal95621783co_pal
corals85325143cor_als
corban10314693corban
corbel103715973corbel
cordial10312953cordial
coria75828323coria_
cormel103815603cormel
corneal94414503corneal
cornel84020053cornel
cornual94210173cornual
coronal94115763coronal
corrals93713853corrals
corsac10410173corsac
cortex15311473cortex
cortical12412213cortical
cortin82423153cortin
coryzal2154823coryzal
costa75523733costa_
costae85319683costae
costar85518613costar
cotan71521783co_tan
cotta75818573cotta_
cottae84615703cottae
cottar84613813cottar
cottas84615573cottas
coxal146116673co_xal
craal74117753_craal
curial84019153curial
curtail9299663curtail
curtals93111623curtals
dental74319173dental
dermal93614343dermal
distal73615773distal
domal85619203do_mal
dorsa64617283dorsa_
dorsad8408973dorsad
dorsals84110853dorsals
dorsel75315503dorsel
dorty96220813dort_y
dossal75510303dossal
dottel73610893dottel
ductal938993ductal
dural64923893dur_al
estral64716513estral
farfal123410183farfal
fatal84819373_fatal
feral85424653fer_al
ferial94621253ferial
festal94213563festal
fetal85623373_fetal
floral94313813flor_al
foal76630923fo__al
focal104917673fo_cal
fora75937393for_a_
foram105124933for_am
foray115023973for_ay
forbad122710503forbad
forestal11410283forestal
forgat104018583forgat
formals123312893formals
format113021353format
formol112910333formol
formyl14276443formyl
fort76456443fort__
forte86131463fort_e
fortes95327183fortes
forth116222673fort_h
fortis95418613fortis
forts86034453fort_s
forty114824273fort_y
foveal1237703foveal
foxtail1745383foxtail
frontal1038363frontal
gametal1037603gametal
gastral8329553gastral
glottal835103glottal
goal55829303go__al
gooral7310463gooral
gorals76917653gor_als
graal64316503_graal
gyral94412783gyr_al
hartals10313023hartals
herbal112513493herbal
hiatal9310203hiatal
hora76136563hor_a_
horah117922053hor_ah
horas86333103hor_as
horntail11105033horntail
hosta85917833hosta_
hostas94515833hostas
hostel93914153hostel
hotel85520753ho_tel
hyetal1236543hyetal
immortal1244103immortal
instal6712193instal
iota45127833io_ta_
iotas54821113io_tas
irreal657833irreal
joram145816983jor_am
jordan1468063jordan
jota116423623jo_ta_
jotas125717443jo_tas
joual12311653jo_ual
journal1484963journal
jovial1636543jovial
jural125120483jur_al
kora86431553kor_a_
korai97018523kor_ai
koras95927113kor_as
korat94934433kor_at
korats105416063korats
korma115913073korma_
kormas124511233kormas
kraal94511823_kraal
kurta95113913kurta_
kurtas10349883kurtas
lanital7310913lanital
larval948503larval
local74820273lo_cal
loran55925093lor_an
lota47233503lo_ta_
lotah85315853lo_tah
lotas55926303lo_tas
loyal84513483lo_yal
manorial10311083manorial
marital92314183marital
martial92415413martial
mayoral1237693mayor_al
meatal84114733meatal
mental84521603mental
metal75427383_metal
mitral81314323mitral
modal85919243mo_dal
molal75120343mo_lal
mora66641273mor_a_
morae75831193mor_ae
morale85220553mor_ale
morals85324643mor_als
moras76438783mor_as
moray105423793mor_ay
morel75729093mor_el
morgan9311373morgan
morsel85815893morsel
mort66758833mort__
mortally1339933mortally
mortars93411523mortars
mortary12369043mortary
morts75533563mort_s
morula8710473morula
motel76623243mo_tel
mural75225113mur_al
narial6317953narial
narwal938943narwal
natal53921493_natal
nodal64717793no_dal
nontax1348413nontax
nopal75517103no_pal
noria55722183noria_
norias65518203norias
normals92510903normals
north86018273nort_h
norths96812323norths
nota46830773no_ta_
nounal639813nounal
octad81510653_octad
octan71313483_octan
octyl10136063_octyl
offal1136243_offal
oorali6311263oor_ali
opal66923523_o_pal
ora37250833_or_a_
orad56031693_or_ad
orals55826483_or_als
orate55133303_orate
orbital936923_orbital
orca65522773_orca_
orcas75918623_orcas
ordeal779253_ordeal
oread64619603_oread
organ6915393_organ
oriel54920423_oriel
orra46120723_orra_
ort39465233_ort__
ortho8312293_ortho
orts46538333_ort_s
osteal6312963_osteal
ottar54313993_ottar
oval77119523_o_val
oxtail1337653_oxtail
palatal9310153palatal
parral85517533parral
partan83820563partan
partial92616263partial
petal76526893_petal
pontil8315463pontil
port66059633port__
portable12313203portable
portably1539313portably
portage103013643portage
portaled11239203portaled
ported94223243ported
porter84224413porter
portly114713403portly
portray1237483portray
ports75934593port_s
postals93716383postals
protyl11308213protyl
rasorial848223rasorial
ratal55025113_ratal
real45750293__real
rectal84418133rectal
rental63922023rental
retral64419743retral
rial45938093__rial
rictal83113183rictal
rorqual1663573rorqual
rostral7311333rostral
rota45834343ro_ta_
rotas54827723ro_tas
rotl45029683ro_t_l
royal85014703ro_yal
rural55821173rur_al
sacral83414413sacr_al
scrotal938493scrotal
septal84513383septal
seral56336383ser_al
serial64625863serial
serval93913413serval
setal56430903_setal
social8813333social
softa86415183softa_
softas94410403softas
somital939403somital
sora45746913sor_a_
soras55041013sor_as
sorel56231443sor_el
sororal7310653sororal
sorrel6413553sorrel
sort46264813sort__
sortable10312483sortable
sortably1338803sortably
sorted74523713sorted
sorter64425093sorter
sortie63621993sortie
sorts54536663sort_s
sotol54917653so_tol
spital83813873spital
sporal82915453spor_al
statal61613223statal
stratal72710603stratal
sural55931263sur_al
surtax1337843surtax
tapetal938273tapetal
tarnal63716503tarnal
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tectal83713253tectal
tergal72912833tergal
tertial7313863tertial
tombal102311023tombal
tonal53724303to_nal
tora47545993tor_a_
torah87125273tor_ah
toras55540373tor_as
tort46967463tort__
torte55431703tort_e
torten65314353torten
tortes64826053tortes
tortile7313193tortile
torts56138123tort_s
torula6610393torula
totals63115163to_tals
trial54926353_trial
trotyl9236673trotyl
unreal64414453unreal
ureal56722683_ureal
urial54823023_urial
uxorial1446323uxorial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vestal94615573vestal
viral86419593vir_al
virtual1045913virtual
vital84819673_vital
vocal104715643vo_cal
volta85215623volta_
vortex1635923vortex
vortical1348863vortical
wormil1138043wormil
wort76654753wort__
worth117120523wort_h
worths127812893worths
worthy15598803worthy
worts88631183wort_s
yurta86014253yurta_
zoarial1646923zoarial
zoeal144813783zo_eal
zonal145116853zo_nal
zoonal1558083zoonal
zoril143916693zor_il

Search took 6 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.390458182.1
2DLD Change Limit1127165235.19021717.9
3Display Results5235230.1703076.5
 (SQL Overall)1786915235.75031076.7
 
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.