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

443 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
aboral831437(None) 
amoral8314621amoral
boral75831701_boral
abnormal1244092abnormal
aboard9312612aboard
aboil72217542abo_il
abolla8410192abolla
aboma91114602aboma_
abomas101113582abomas
aborally1347062aborally
abort76133582abor_t
aborts84916182aborts
abroad9310942abroad
agonal7410052agonal
agora6914332agora_
agorae7511202agorae
agoras7613342agoras
anodal72512112anodal
anorak1038922anorak
antral65719412antral
anural65714742anural
aortal65217512a_ortal
apodal9289822apodal
arboreal1045632arboreal
astral66919282astral
atonal6514022atonal
aural54428962a_ural
auroral7310472auroral
avowal1246322avowal
axonal1347652axonal
azonal1568272azonal
bora66141632_bora_
borals86721912_borals
boras75938302_boras
borax145918722_borax
boreal84817212_boreal
caporal11410942caporal
choral115118492choral
coral76033452_coral
floral94313812floral
gooral7310462gooral
goral65125752_goral
horal86328672_horal
loral55927822_loral
mayoral1237682mayoral
moral75533432_moral
oral47638122__oral
sporal82915452sporal
suboral92011992suboral
aal39058673a___al
aba512850953ab__a_
abaca95118043abaca_
abacas104414723abacas
abaka114313823abaka_
abakas123911743abakas
abas68642083ab__as
abaxial1646183abaxial
abaya104413173abaya_
abayas114011703abayas
abba810522643ab_ba_
abbas95918643ab_bas
abeam9316533ab_eam
abettal946073abettal
abfarad1344223abfarad
abhor10411063abhor__
abhors11410623abhor_s
abigail1044173abigail
abnormals1342773abnormals
abo59045963abo___
abode85518813abo_de
aboded104912513aboded
abodes94417513abodes
abohm1247973abo_hm
abohms1335003abohms
abollae936943abollae
abomasa11114613abomasa
abomasal12112843abomasal
abomasi11115493abomasi
aboon74918703abo_on
aborted10310423aborted
aborter939923aborter
abortus9397913abortus
abos67734413abo__s
abound9239863abound
about75229083abo_ut
above105414323abo_ve
aboves114512843aboves
abrade9313053ab_rade
abri65522213ab_r_i
abris75722603ab_ris
abroach1446213abroach
abseil837183abseil
absorb1038003absor_b
absorbs1135603absorbs
abuttal954553abuttal
abysmal1453963abysmal
abyssal1243753abyssal
accrual1144553accrual
acetal84314903acetal
achiral12109183achiral
acorn75616623acor_n
acorns85013013acorns
actual8311023actual
admiral1046363admiral
adorable1138773adorable
adorably1446443adorably
adore65723663ador_e
adored84714233adored
adorer74713443adorer
adores74420713adores
adorn64917093ador_n
adorns74212613adorns
aecial84817313aecial
aerial64625713aerial
affray1534973affray
afore85818603afor_e
afoul8510193afo_ul
agorot7414993agorot
ahorse9311513ahorse
ajowan1634893ajowan
albinal937813albinal
algal66518213a_lgal
alodial899953alodial
aloha8513613aloha_
alohas9411703alohas
ammonal1137013ammonal
amorally1348073amorally
amort75832203amor_t
amphoral1565623amphoral
amtrac10109123amtrac
anal48037523a__nal
anconal939423anconal
angora71111573angora_
angoras8811363angoras
animal85016253animal
annal56520763a_nnal
anneal64812293anneal
annual64710703annual
anoa45634473ano_a_
anoas57226493ano_as
anomaly1238843anomaly
anoraks1137603anoraks
antra56521923antra_
anuran64313243anuran
aorta55922573a_orta
aortae65115473a_ortae
aortas65417783a_ortas
apical10913903apical
apneal83411123apneal
apnoeal956193apnoeal
apogeal1045613apogeal
aporia8315863aporia
aporias9315133aporias
aport75432173apor_t
appal95315223a_ppal
appeal103911613appeal
apteral9311523apteral
arak86929573a__rak
arbitral1045423arbitral
arbor74818113arbor__
arbored103811603arbored
arbores94016033arbores
arbors84717873arbor_s
arboviral1442513arboviral
areal55928733a_real
argal65023383a_rgal
aril45843023a__ril
armorial1049453armorial
aroma71220143aroma_
aromas81018613aromas
arousal748633arousal
arras55626133a_rras
array86317143a_rray
artal55525473a_rtal
arval86017013a_rval
aryl75922343a__ryl
ashram1139053ashram
asocial998653asocial
astrals75515243astrals
astray95615543astray
atabal839743atabal
atoll57913923ato_ll
atrial65418943atrial
audial7312993audial
augural856403augural
aura45836253a_ura_
aurae54128113a_urae
aurar54420253a_urar
auras55932553a_uras
aurora6411763aurora_
aurorae739663aurorae
auroras7311703auroras
austral73411513austral
avowals1335013avowals
awol75620673awo__l
axal116520493a__xal
axial124515193a_xial
baal67033113_b_aal
babool103012153babo_ol
bal56662723_b__al
balmoral1244633balmoral
banal75925993_banal
baobab946403baobab
barbal104016663barbal
barrel84517873barrel
basal75722283_basal
beryl101211673_beryl
bharal1138893bharal
binal75323823_binal
birl65830463_bir_l
boa56954033_bo_a_
boar66134293_bo_ar
board85523003_board
boars75229603_boars
boart78835933_boart
boas66150833_bo_as
boat66360313_bo_at
bogan87519003_bogan
boil66335183_bo_il
bola66035563_bola_
bolar75123473_bolar
bolas74733763_bolas
boll65634753_bo_ll
borage93917013_borage
borane84620213_borane
borate85026153_borate
bordel94514573_bordel
bore66051333_bor_e
boreas85421733_boreas
bored85034303_bored
borer75131273_borer
bores76448253_bores
boric98024223_boric
bork106933823_bor_k
borks115727703_borks
born67338413_bor_n
borne77926793_borne
boron76727143_boron
borstal939043_borstal
bort65960963_bor_t
borts76735453_borts
borty105522833_borty
bortz165722203_bortz
bota66236503_bota_
botas75328783_botas
botel75121863_botel
bowel105621203_bowel
bowl96827703_bo_wl
boyar106013763_boyar
boyla102912363_boyla
bra56339463_b_ra_
brad75234343_b_rad
brae65639113_b_rae
brag75229723_b_rag
brail75525553_b_rail
bran65740383_b_ran
bras65746453_b_ras
brat66055543_b_rat
braw94829563_b_raw
brawl106217963_b_rawl
bray95232903_b_ray
broad84817693_broad
broil74918223_broil
bromal10313653bromal
bubal94218213_bubal
bura66139533_bura_
buran75225303_buran
buras74736293_buras
burial84117623_burial
burl64937183_bur_l
bursal84414823_bursal
byrl95716013_byr_l
cabal95222153cab__al
cameral11311263cameral
caporals1238923caporals
carbora11310703carbora_
carboras12311573carboras
ceorl7410913ceor_l
chiral114614413chiral
chloral12169983chloral
chorale124313353chorale
chorals124614103chorals
chordal13449883chordal
choreal124412223choreal
chorial124214143chorial
citral81113883citral
clonal8310913clonal
coal66939253_co_al
cobra95214403cobra_
cobras104014193cobras
comal95125133_comal
copal95621783_copal
corals85325143_corals
corral83616253corral
coxal146116673_coxal
crural8610633crural
dobra85013103dobra_
dobras94811913dobras
domal85619203_domal
dorsal74613943_dorsal
dotal64919623_dotal
dural64923893_dural
ephoral1248403ephoral
estral64716513estral
femoral1238723femoral
feral85424653_feral
flora85317103flora_
florae94713883florae
florals104210063florals
floras94715693floras
foal76630923_fo_al
focal104917673_focal
fora75937393_fora_
foram105124933_foram
foray115023973_foray
formal113215203_formal
gastral8329553gastral
global937663global
goal55829303_go_al
goorals838703goorals
gorals76917653_gorals
gyral94412783_gyral
hoorah124411113hoorah
hooray123011373hooray
hora76136553_hora_
horah117922043_horah
horas86333093_horas
humoral1237973humoral
immoral1146783immoral
ixora1236913ixora_
ixoras1337193ixoras
joram145816983_joram
joual12311653_joual
jural125120483_jural
kora86431553_kora_
korai97018513_korai
koras95927113_koras
korat94934433_korat
labara83712893labara_
labial84714333lab_ial
labor75117313labor__
labored102810243labored
laborer9249503laborer
labors84016403labor_s
labra75415463lab_ra_
lateral7313563lateral
liberal9310183liberal
litoral7610763litoral
local74820273_local
loran55925093_loran
loreal63814313_loreal
loyal84513483_loyal
manorial10311063manorial
mbira977953mbira_
mbiras1077143mbiras
mitral81314323mitral
modal85919233_modal
molal75120343_molal
mora66641273_mora_
morae75831193_morae
morale85220553_morale
morals85324633_morals
moras76438763_moras
moray105423793_moray
morel75729093_morel
mortal84616853_mortal
mural75225103_mural
nadiral836343nadiral
natural739513natural
neural6311993neural
nodal64717793_nodal
nonoral7313593nonoral
nopal75517103_nopal
normal83213533_normal
notal55221353_notal
obol65220613obo__l
oorali6311263_oorali
opal66923523__opal
ora37250833__ora_
orad56031693__orad
orals55826483__orals
oval77119523__oval
pakora1247283pakora_
pakoras1337473pakoras
papyral1445773papyral
parral85517533parral
pastoral10310483pastoral
peroral9314793peroral
phonal11310383phonal
plural839823plural
portal84218463_portal
preoral9312673preoral
puberal1147773puberal
rasbora945943rasbora_
rasboras1045893rasboras
rasorial848223rasorial
retral64419743retral
royal85014703_royal
rural55821173_rural
sabal75422483sab__al
sabra75317853sab_ra_
sabras85116363sab_ras
sacral83414413sacral
seral56336383_seral
shoal83920263sho_al
shoran94016033shoran
shorl84720243shor_l
skoal93811453sko_al
sora45746913_sora_
soras55041013_soras
sorel56231443_sorel
sororal7310653sororal
spiral83715343spiral
stomal85213313stomal
storax1389783storax
suboval12216723suboval
sudoral8148543sudoral
sural55931263_sural
tabor75518393tabor__
tabored102810563tabored
taborer9269293taborer
taboret92916113taboret
taborin92210453taborin
tabors84517093tabor_s
thorax1638253thorax
tonal53724303_tonal
tora47545993_tora_
torah87125273_torah
toras55540373_toras
total55321823_total
tumoral938133tumoral
umbonal1144383umbonal
umbral1038623umbral
unmoral948693unmoral
uxorial1446323uxorial
viral86419593_viral
vocal104715643_vocal
whorl114612453whor_l
woorali1045263woorali
zoeal144813783_zoeal
zonal145116853_zonal
zoonal1558083zoonal
zoril143916693_zoril

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.1561145455.1
2DLD Change Limit1127164438.75012881.8
3Display Results4434430.1403164.3
 (SQL Overall)1786914439.04619753.6
 
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.