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

291 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
herbals12271060(None) 
herbal112513491herbal_
verbals121910741verbals
aerials74017552aerials
cereals9313172cereals
ferals94216642fer_als
ferbams1435742ferbams
gerbils1037302gerbils
hartals10313022hartals
heals85733452he__als
herald10311342her_ald
heralds1137712her_alds
herbage1337002herbage
herbages1437092herbages
herbalism1647582herbalism
herbalist1449812herbalist
herbs105520502herb__s
herls85226432her__ls
serials73919742serials
servals103410742servals
thermals13518532thermals
verbal112513662verbal_
yerbas11119292yerba_s
aerial64625713aerial_
aerobats1049843aerobats
airbags1036293airbags
argals75517713_argals
atabals938413atabals
bals66354043___bals
barbal104016663barbal_
barbels114514433barbels
beryls11107883ber_yls
bharals1236733bhar_als
borals86721913bor_als
bubals103513843_bubals
burials93612083burials
cabals104020153_cabals
carpals113414633carpals
ceibas1038503ceiba_s
cembali13156043cembali
cembalo13145533cembalo
cembalos14135163cembalos
centals94317053centals
ceramals1246513ceramals
cercal10314123cercal_
cereal8315833cereal_
cerebrals1354833cerebrals
cerias83321983ceria_s
chervils1644553chervils
chorals124614113chor_als
corals85325143cor_als
corbans11313173corbans
corbels113813593corbels
corrals93713853corrals
craals84113303_craals
curtals93111623curtals
cymbals16236143cymbals
darbars10510093darbars
deals65435343de__als
debags104211063de_bags
debars94218043de_bars
decals93717713de_cals
decrials1137133decrials
denials84114133denials
dentals83915393dentals
derails84216393derails
derats74625063der_ats
derays105514253der_ays
derbies103016053derbies
dermal93614343dermal_
dermas94116813derma_s
deverbals1544103deverbals
dorsals84110843dorsals
durbars1077973durbars
embalm1236653_embalm
embalms1335333_embalms
embars103812883_embars
embays131408333_embays
equals1538693_equals
eras45441503_er_a_s
ervils948773_ervils
eternals8238953eternals
farfals13268503farfals
fecials123510333fecials
feral85424653fer_al_
ferbam1339003ferba_m
ferial94621253ferial_
ferias95020393feria_s
ferrels10248623ferrels
ferulas103110753ferulas
fetials103711743fetials
formals123312893formals
gerahs1039413ger_ahs
gerbil938343gerbil_
germans1079473germans
gharials1245123gharials
gimbals12257823gimbals
gorals76917653gor_als
graals74112913_graals
hairball1344633hairball
hairballs1443843hairballs
halals95018313h_alals
hamals114816823h_amals
hammals14409223hammals
harass9313943har_ass
harbors12412413harbors
hardass1139753hardass
hardball14116303hardball
hardballs15115543hardballs
harls85634503har__ls
hartal9415473hartal_
heads95127113he__ads
heal75645693he__al_
heaps105223223he__aps
hearable131611603hearable
hears86737373he__ars
hearsays1444513hearsays
heats85838403he__ats
hebes105521673he_b_es
heehaws1643343heehaws
heelball1343893heelball
heelballs1443433heelballs
heels85625533he__els
heils85222193he__ils
hells85032043he__lls
hemal104419803he_mal_
henbane1237353henbane
henbanes1336573henbanes
henbits12177003henbits
hennas94211803henna_s
hepcats1436473hepcats
heptads1335873heptads
herb94730963herb___
herbaged1554523herbaged
herbalisms1746283herbalisms
herbalists1546193herbalists
herbaria1346093herbaria
herbed123513453herb_ed
herbier1239593herbier
herbiest1339993herbiest
herbless1336663herbless
herby134715313herb__y
hercules1337633hercules
herders113914123herders
herdics13249523herdics
herds96424683her__ds
hereat93527413herea_t
heredes11313133heredes
heres86245903her__es
heriots10312063heriots
herl75834553her__l_
herma105318883herma__
hermae115314473herma_e
hermai118912863herma_i
hermits12312143hermits
herms105626433her__ms
hernial10310433hernial_
hernias10310773hernias
herns84825583her__ns
heroes94923823her_oes
heroics122912003heroics
heroins103518013heroins
herons94820543her_ons
heros84930863her__os
herpes115517323her_pes
herries104025073herries
hers75844873her___s
herself1337623herself
hertzes1938303hertzes
hetmans12187593hetmans
hewable15177823hewable
hexads17468193he_xads
hexyls1933433he_xyls
heydays1734143heydays
hirable121612313hirable
hirsels10128343hirsels
horahs126313873hor_ahs
horal86328683hor_al_
horas86333103hor_a_s
humerals1347173humer_als
hurls86522713hur__ls
hurrahs13336773hurrahs
hurrays13386153hurrays
hymnals1543523hymnals
jebels15418913je_bels
jerboas1636163jerboas
jumbals18106533jumbals
kebabs14418513ke_babs
kebars124112493ke_bars
kerbs115013673kerb__s
kernels11417953kernels
keypals1634353keypals
kraals10378433_kraals
legals73412733le_gals
lethals1038113lethals
meals75933373me__als
medals94218053me_dals
medials103914733medials
menials94015683menials
merls77423903mer__ls
mescals112911563mescals
metals84520883me_tals
mezcals20246533mezcals
morals85324633mor_als
mortals93914003mortals
murals84016763mur_als
narwals1036983narwals
nerols6914883ner_ols
normals92510903normals
orals55826483_or_als
parrals94414573parrals
peals75235493pe__als
pedals94316033pe_dals
percale11314093percale
percales12313803percales
perhaps1446123perhaps
perils84121853per_ils
persalt9315413persalt
persalts1038193persalts
perusals1047143perusals
petals84719813pe_tals
pibals103813083_pibals
portals94015563portals
reals55038653__reals
rebars84019833re_bars
rebels84518133re_bels
recoals94214623recoals
redbays1336013redbays
redials84416883redials
rentals74017473rentals
repeals94014523repeals
rereads81512293rereads
rerolls739943rerolls
reseals73917663reseals
retrials8510823retrials
reveals103812723reveals
rials55026673__rials
sabals84618863_sabals
sambals115213483sambals
seabags1037483seabags
seals54839693se__als
sendals81912263sendals
sepals85217373se_pals
seracs84418573ser_acs
serails73318363serails
serais64326133ser_ais
seral56336383ser_al_
serdabs1035323serdabs
serial64625863serial_
serval93913413serval_
sheals94420643she__als
sherbets1335213sherbets
sherpas1238093sherpa_s
tarsals72512603tarsals
teals56234133te__als
tepals85415043te_pals
terais64023513ter_ais
terbias9310743terbias
tercels94110363tercels
tergal72912833tergal_
terras63516973terra_s
tertials8510073tertials
theriacs1336543theriacs
therians1138313therians
thermal125010973thermal_
thermels13607763thermels
timbals11239533timbals
trials64319883_trials
tribals9610753tribals
turbans939563turbans
tymbals14265723tymbals
urials64415193_urials
veals84926193ve__als
verbalism1647373verbalism
verbalist1449503verbalist
verbally1647183verbally
verbids13259203verbids
verbile1249863verbile
verbiles1338923verbiles
verbs104614393verb__s
verglas1137813verglas
vernal93514213vernal_
versal93013753versal_
vestals104612333vestals
weals85428743we__als
wheals124512523whe__als
whereas13448903wherea_s
yerba101010763yerba__
zeals145320853ze__als
zebras1737853zebra_s
zebrass1834113zebrass

Search took 7 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.420425454.8
2DLD Change Limit1340272916.19021652.2
3Display Results2912910.1102645.5
 (SQL Overall)1786912916.72026590.9
 
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.