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

434 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
burials9361208(None) 
burial84117621burial_
urials64415191_urials
aerials74017552aerials
borals86721912bor_als
brails84621292b_rails
briars84814822b_riars
bridals1038622b_ridals
brills84916292b_rills
bubals103513842bu_bals
burans85019302bur_ans
buras74736292bur_a_s
bureaus979282bureaus
buriers94017192buriers
buries84633272buri_es
burins84221892buri_ns
burkas124513802burka_s
burlaps1156252burlaps
burls74228852bur__ls
burqas174410902burqa_s
bursal84414822bursal_
bursars94510892bursars
bursas85318272bursa_s
buttals938502buttals
curial84019152curial_
curtals93111622curtals
durians839572durians
murals84016752mur_als
reburials1143932reburials
rials55026672__rials
serials73919742serials
trials64319882_trials
urial54823022_urial_
urinals7610252_urinals
abulias93210693abulia_s
abuttals1043923abuttals
aerial64625713aerial_
agrias74315393agria_s
anurias7312243anuria_s
argals75517703_argals
arias55438023_aria_s
ariels65119373_ariels
arils58732203_ari_ls
arrivals1145933arrivals
atrial65418943atrial_
audial7312993audial_
aural54428963aur_al_
auras55932553aur_a_s
auricle9139813auricle
auricles10138333auricles
auris55331523auri__s
aurists74615783aurists
baals76122703b__aals
bails75933523b_ai_ls
bals66354043b___als
banians9312033banians
barbal104016663barbal_
barbels114514433barbels
barbitals1345253barbitals
barcas101016603barca_s
barilla9310323barilla
barillas10310193barillas
barites94322333barites
bariums1139143bariums
barrels94514363barrels
basils85717473basi_ls
bedrails1136293bedrails
berimes115216643berimes
beryls11107883ber_yls
bewails1277553bewails
bezils1711310603bezi_ls
bharals1236733bharals
biali73419073b__iali
bialis83617163b__ialis
bialy105119323b__ialy
bialys11387913b__ialys
bias64738153b__ia_s
bills75632863b__ills
biriani945643biriani
birianis1056343birianis
birls74023163b__irls
boils75427193b_oi_ls
boral75831703bor_al_
boras75938303bor_a_s
bordels103911973bordels
boreal84817213boreal_
boreas85421733borea_s
borides10515153borides
borings103614243borings
borstals1037463borstals
brads85528293b_r_ads
braes75735053b_r_aes
brags85625103b_r_ags
braids95015683b_raids
brail75525553b_rail_
brains85125473b_rains
brans75437433b_r_ans
bras65746453b_r_a_s
brass75428023b_r_ass
brats75336013b_r_ats
brawls115214333b_rawls
braws106425193b_r_aws
brays106723113b_r_ays
breads95419203b_reads
breaks124816423b_reaks
breams104815043b_reams
briar75718153b_ria_r
briard94311293b_riard
briards10398553b_riards
briary114912003b_riary
bribes105918533b_ribes
bricks144614623b_ricks
bridal9511453b_ridal_
brides94423513b_rides
bridle94115463b_ridle
bridles104114473b_ridles
briefs115510073b_riefs
briers85319733b_riers
bries74942153b_ri_es
brigs85823223b_ri_gs
brill74819953b_ri_ll
brillo84211003b_rillo
brillos9369173b_rillos
brims94721623b_ri_ms
brines85028853b_rines
brings94618433b_rings
brinks124616313b_rinks
brins75533973b_ri_ns
brios74725723b_ri_os
bris65539613b_ri__s
brises84927613b_rises
brisks124611403b_risks
briss75824273b_ri_ss
briths115113863b_riths
brits76433083b_ri_ts
britts84813443b_ritts
broads94515143b_roads
broils84114173b_roils
bromals1139743bromals
bruins86014953brui_ns
bruises93212913bruises
bruits85714453brui_ts
brumal1049503brumal_
brutal859383brutal_
bubal94218213bu_bal_
bubale104014623bu_bale
bubales113513343bu_bales
bubalis11359903bu_balis
bubbas94110703bubba_s
buccal1248243buccal_
buffalo1553723buffalo
buffalos1642863buffalos
buhls105111803bu__hls
build84413353bu_i_ld
builds9378493bu_ilds
built74325923bu_i_lt
buirdly1334203buirdly
bulbels11398013bulbels
bulbils11338333bulbils
bulbuls11346783bulbuls
bulls75629573bu__lls
bummalo1353793bummalo
bummalos1442873bummalos
bunas75126573bu_na_s
bunions92210473bunions
bunyas11359433bunya_s
bura66139533bur_a__
buran75225303bur_a_n
burble104617703bur_ble
burbles114916803burbles
burbly134311153bur_bly
burbots1168673burbots
burbs95423493bur__bs
burdens1039713burdens
burdies104117563burdies
burds84626063bur__ds
bureau8712523burea_u
bureaux1664593bureaux
burets84321263bur_ets
burgage1136633burgage
burgages1236483burgages
burgees104915893burgees
burgers103918573burgers
burgess10409343burgess
burghal1335073burghal_
burghs12519923bur_ghs
burglar1065533burglar
burglars1154593burglars
burgle94815863bur_gle
burgles105615963burgles
burgoos1037123burgoos
burgs84924093bur__gs
buried94822373buri_ed
burier84324653buri_er
burin75626063buri__n
burka114617693burka__
burkers133716623burkers
burkes124421313bur_kes
burkites1436673burkites
burl64937183bur__l_
burlap1098353burla_p
burlers94120273burlers
burleys12479673burleys
burlily1237713burlily
burly104922833bur__ly
burnable1237263burnable
burnables1344003burnables
burners94115673burners
burnets93813263burnets
burnies94017823burnies
burnings11387623burnings
burnous938823burnous
burns74926773bur__ns
burps94220173bur__ps
burqa165013093burqa__
burrers93814493burrers
burritos1044473burritos
burros85114993bur_ros
burrows12399093burrows
burrs74925653bur__rs
burs65847423bur___s
bursa74921523bursa__
bursae84515603bursa_e
bursar85413253bursa_r
bursary12397583bursary
bursate94111203bursate
burses84425513bur_ses
bursitis1045033bursitis
bursts85116243bur_sts
burtons9310853burtons
busbars1138153busbars
busgirls1142653busgirls
bushels124110713bushels
busies85525263busi_es
busily112211503busi_ly
busings103711223busings
butyls1176753bu_tyls
butyrals1344503butyrals
byrls105711233byr__ls
byroads1335293byroads
carpals113414623carpals
cereals9313173cereals
cerias83321973ceria_s
corals85325143cor_als
cordials1139603cordials
corrals93713853corrals
craals84113303_craals
cuirass934973cuirass
curia74523763curia__
curiae84518373curia_e
curies84934023curi_es
curios83218333curi_os
curious93813563curious
curites93919863curites
curiums1138503curiums
curls74927103cur__ls
currans9310613currans
curtails10318243curtails
curtal83914543curtal_
decrials1137133decrials
denials84114133denials
derails84216393derails
dials64925343__dials
diurnals943803diurnals
dorsals84110843dorsals
drails74716953_drails
drills74414203_drills
duals65620083du__als
dulias71212743dulia_s
dural64923893dur_al_
duras65727723dur_a_s
durbars1077973durbars
durian7312003duria_n
durions839963durions
durras74713373durra_s
espials937093espials
euripus934623euripus
facials123310743facials
farfals13268503farfals
fecials123510333fecials
ferals94216643fer_als
ferial94621253ferial_
ferias95020393feria_s
fetials103711743fetials
finials103210153finials
formals123312893formals
frails93716473_frails
friars93812093_friars
frills94414223_frills
fungals11276783fungals
furans94515953fur_ans
furies95126373furi_es
furious103110633furious
furls85322053fur__ls
fusils93912343fusi_ls
fuzils18407963fuzi_ls
gavials1136603gavials
gharials1245123gharials
gorals76917653gor_als
graals74112913_graals
grails77518783_grails
grills74314803_grills
guaiacs1054353guaiacs
hartals10313023hartals
herbals122710603herbals
hurls86522713hur__ls
hurrahs13336773hurrahs
hurrays13386153hurrays
journals1574353journals
jumbals18106533jumbals
jural125120483jur_al_
jurats134213203jur_ats
jurels133710583jur_els
juries134120633juri_es
jurists14409123jurists
kraals10378433_kraals
krills104211283_krills
kurgans12145653kurgans
kurtas10349883kurta_s
labials9299873labials
lariats7615053lariats
lurdans837073lurdans
luridly1196283luridly
medials103914733medials
menials94015683menials
morals85324633mor_als
mortals93914003mortals
mughals1355753mughals
mural75225103mur_al_
muras75329563mur_a_s
muriate9313363muriate
muriates10312083muriates
murices112612283murices
murids93212193muri_ds
murines93718223murines
murras84916003murra_s
musicals1247093musicals
mutuals937123mutuals
myriads1334343myriads
narial6317953narial_
narwals1036983narwals
norias65518183noria_s
normals92510903normals
nubias8310083nubia_s
nuchals12216933nuchals
nuptials1044303nuptials
nurls55519683nur__ls
nutrias739813nutria_s
orals55826483_or_als
oriels64914623_oriels
outrivals1243893outrivals
pariahs123812343pariahs
parians93519733parians
parrals94414573parrals
partials101911953partials
perils84121853peri_ls
phials1158873_phials
plurals936913plur_als
pluvials1343713pluvials
portals94015563portals
prills84015613_prills
pupils10389913pupi_ls
purdahs13285483purdahs
purdas92612263purda_s
purines94420763purines
purins83722653puri_ns
puris75332023puri__s
purisms114110833purisms
purists94014073purists
puritans1037633puritans
purls74723353pur__ls
pyurias1236703pyuria_s
quails153412643quai_ls
quezals2544253quezals
quills153811843qu_ills
radials83614633radials
rails55937403__rails
reals55038653__reals
reburial1046203reburial_
redials84416883redials
retrials8510823retrials
rial45938093__rial_
rias45540593__ria_s
riels55121333__riels
rills55032713__rills
rivals94213183__rivals
riyals94111083__riyals
rupiahs1253333rupiahs
rural55821173rur_al_
saurians837763saurians
serails73318363serails
serial64625853serial_
servals103410743servals
shrills10389933shrills
sials54227243__sials
socials999633socials
spirals93212513spirals
sundials946753sundials
surahs94515543sur_ahs
sural55931263sur_al_
suras55336323sur_a_s
surimis938843surimis
surpass938283surpass
surras65919533surra_s
survivals1543013survivals
tarsals72512603tarsals
tertials8510073tertials
thrills10398783thrills
trails64622513_trails
triacs83913223_triacs
triads74513523_triads
trial54926353_trial_
tribals9610743_tribals
trills64319853_trills
triols66117803_triols
turbans939563turbans
turbinals1144253turbinals
turions7311573turions
tutorials945133tutorials
umiacs1035663_umiacs
umiaks1244953_umiaks
umiaqs1733003_umiaqs
uncials92510523uncials
urbias839083_urbia_s
ureal56722683_ureal_
ureas55826013_urea_s
urinal6614123_urinal_
urines64724123_urines
usuals637783_usuals
varias95019903varia_s
verbals121910733verbals
vials85822383__vials
wurzels1934083wurzels
zorils153810883zori_ls

Search took 9 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 Filter1786911340270.220812231.8
2DLD Change Limit1340274348.42315912.0
3Display Results4344340.2162009.3
 (SQL Overall)1786914348.85920170.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.