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

397 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
shovels1337839(None) 
hovels125413331_hovels
shovel124611321shovel_
shovers134613001shovers
shoves124919421shove_s
grovels11427812grovels
hosels94218602_hosels
hotels94515512_hotels
hovel115017682_hovel_
hovers124320252_hovers
novels95512502_novels
shavers134115092shavers
shaves125224932shave_s
shekels1436042shekels
sheqels1934752sheqels
shiels95418922sh_iels
shivers133714832shivers
shives124921412shive_s
shoals94215792sho_als
shoers94518332sho_ers
shoes85429662sho_e_s
shools94919012sho_ols
shores94830412shore_s
shorls94516202sho_rls
shotes95321912shote_s
shove114421042shove__
shoved134214282shove_d
shoveled15195352shoveled
shoveler14165582shoveler
shovelers15174942shovelers
shover124515992shove_r
showers134612682showers
shrivels14376442shrivels
slovens10316572slovens
snivels10336902snivels
sorels63921162s_orels
stovers103713732stovers
stoves93818922stove_s
swivels13396772swivels
aboves114512843above_s
asphodels1541783asphodels
behoves15177353behove_s
bevels113913983_bevels
botels84815803_botels
bowels114315593_bowels
carvels124914593carvels
chapels14429153chapels
chiels115115933ch_iels
chisels12219103chisels
chives144317593chive_s
chokers164311523chokers
chokes154917383choke_s
cholers124215203cholers
chorals124614113chorals
choreas124414203choreas
chores114828023chore_s
choses115825133chose_s
clovers125114663clovers
cloves114918823clove_s
covens114919263_covens
covers114627963_covers
coves105539173_cove_s
covets114819643_covets
coveys145413503_coveys
devels104313903_devels
dholes104914793dhole_s
dishevels1653633dishevels
dovens104413903_dovens
doves94728153_dove_s
dowels104813343_dowels
drivels11397923drivels
drovers115212643drovers
droves105116673drove_s
estovers1136453estovers
foveas1238623_foveas
gavels105911093_gavels
ghouls1036043gho_uls
glovers114310883glovers
gloves104115183glove_s
gravels113611143gravels
grovel104310543grovel_
groves104318103grove_s
havens124514043_havens
havers124721483_havers
haves116034873_have_s
hazels185710083_hazels
heels85625533_h_eels
hives116925513_hive_s
hoers85724923_ho_ers
hoes75755733_ho_e_s
hokes126231643_hoke_s
holes84748653_hole_s
hols76946293_ho__ls
homely145313173_homely
homers114821973_homers
homes106938813_home_s
homeys145012873_homeys
honers94324973_honers
hones88144493_hone_s
honeys124016083_honeys
hooeys125512313_hooeys
hoovers134312703hoovers
hooves124815483hoove_s
hopers114222973_hopers
hopes105835643_hope_s
hosel86024813_hosel_
hosers95223963_hosers
hoses85443173_hose_s
hoseys124614003_hoseys
hostels103712313_hostels
hotel85520753_hotel_
housels105312133_housels
hove107132223_hove__
hoveled14209293_hoveled
hover115524133_hove_r
howes114730263_howe_s
howls116219223_ho_wls
hoyles12315013_hoyles
isohels1035393isohels
kevels134410713_kevels
koels94613903_ko_els
levels94113283_levels
losels64714583_losels
lovely12339713_lovely
lovers94223433_lovers
loves85332013_love_s
marvels123810093marvels
models94216353_models
mohels115011323_mohels
morels84820013_morels
motels83616893_motels
movers115117193_movers
moves106128423_move_s
navels95712693_navels
noels56418703_no_els
novel85615993_novel_
ovals85413393__ovals
ovens86217453__ovens
overs85224793__overs
phones114121213phone_s
phoneys15437143phoneys
plovers123611833plovers
pooves113914713poove_s
propels113412843propels
provers123817793provers
proves114322253prove_s
pushovers1743003pushovers
ravels94717073_ravels
revels94220573_revels
rovers95423523_rovers
roves84834483_rove_s
rowels94515453_rowels
salvers103916003salvers
salves94221763salve_s
samiels939763samiels
saurels749303saurels
savers93825923s_avers
saves85838633s_ave_s
schools1249113scho_ols
schorls1248353scho_rls
scones84521303scone_s
scopes104719593scope_s
scorers94115323scorers
scores84725923score_s
scoters93313813scoters
scowls11549593sco_wls
seels55632823s__eels
seidels838393seidels
sels46345983s___els
selves94119613selve_s
sequels1665703sequels
servals103410743servals
servers103214833servers
serves94423653serve_s
sevens93813663s_evens
severs94121123s_evers
shaders115915553shaders
shades105924533shade_s
shakers144015563shakers
shakes135024593shake_s
shales94731253shale_s
shames114726223shame_s
shapely1536893shapely
shapers124016893shapers
shapes115124943shape_s
sharers104720623sharers
shares95236413share_s
shauls94913113sh_auls
shave114425893shave__
shaved135118383shave_d
shaven124213303shave_n
shaver123718913shave_r
shavies134213203shavies
shawls125411973sh_awls
sheals94420643sh_eals
sheas86331793sh__eas
sheaves134412973sheave_s
sheds96122703sh__eds
sheens95116993sh_eens
sheers94322403sh_eers
sheets93918503sh_eets
sheeves133911953sheeves
shekel1338383shekel_
shelf115221113sh__elf
shell84424123sh__ell
shells94319523sh_ells
shelvers14388813shelvers
shelves134112093shelve_s
sheols94614163sh_eols
sheqel1846523sheqel_
shes75734353sh__e_s
shewers134312053shewers
shews115924713sh__ews
shiel811023773sh_iel_
shield106212973sh_ield
shields11538043sh_ields
shiers94921753sh_iers
shies86136553sh_ie_s
shills94519613sh_ills
shiners104015943shiners
shines95028913shine_s
shires95225573shire_s
shivahs16375723shivahs
shivas124512413shiv_as
shive114423423shive__
shiver124517373shive_r
shivery16317023shivery
shivs115018803shiv__s
shleps114710333sh_leps
shmoes114612103shmoe_s
shoal83920273sho_al_
shoaled113810973shoaled
shoaler102610083shoaler
shoalest1168913shoalest
shoaly124010773sho_aly
shoats94117083sho_ats
shockers17319463shockers
shocks154414583sho_cks
shoe75933443sho_e__
shoed95723013sho_e_d
shoeless1137803shoeless
shoer84722163sho_e_r
shofars1335833shofars
shogis103810943sho_gis
shogs95319713sho__gs
shoguns1134423shoguns
shojis16348493sho_jis
sholoms1278033sholoms
shone83725983shone__
shooed103916083shooe_d
shoofly1634353shoofly
shooks134515633sho_oks
shool84523153sho_ol_
shooled115212663shooled
shoos84226363sho__os
shooters112811583shooters
shoots94619363sho_ots
shoppers153010763shoppers
shoppes143411393shoppes
shops104222903sho__ps
shorans102812413shorans
shore85432653shore__
shored105723653shore_d
shoreless1236633shoreless
shorl84720253sho_rl_
shortens11288993shortens
shortly13387573shortly
shorts95321743sho_rts
shote85526103shote__
shots84730853sho__ts
shotts93614703sho_tts
should1038033sho_uld
shouters113510623shouters
shouts94017723sho_uts
shovelful1882163shovelful
shovelfuls1981483shovelfuls
shoveling1635553shoveling
shovelled16174413shovelled
shoveller15174543shoveller
shovellers16173783shovellers
shovelnose1651303shovelnose
shovelsful1951083shovelsful
shoving142910643shoving
showed135016973showe_d
shower124315113showe_r
showery16437243showery
showily1636223showily
shows115324583sho__ws
shoyus1266003sho_yus
shreds105613053sh_reds
shrews129313923sh_rews
shrieks14377673shrieks
shrills10389933shrills
shrivel13479403shrivel_
shrivers14419103shrivers
shrives134416173shrive_s
shrove125412233shrove__
shtetels1143233shtetels
shtetls1034583shtetls
shuls85319713sh__uls
shutes93518223shute_s
shyers124712203sh_yers
shyness1344993shyness
sieves93216003sieve_s
silvers104714043silvers
simnels976103simnels
sivers95324153s_ivers
skivers14409703skivers
skives134113943skive_s
skoals10438243sko_als
slavers103716503slavers
slaves95023023slave_s
slaveys13415203slaveys
slivers104115253slivers
sloes54728873slo_e_s
slopers94213093slopers
slopes84820453slope_s
sloven9389633slove_n
slovenly1443853slovenly
smokers13389323smokers
smokes124814343smoke_s
snivel9368853snivel_
snools65715883sno_ols
snorers74313803snorers
snores64324323snore_s
snorkels1234413snorkels
soaves94218673soave_s
sobers85218863s_obers
socles8418453s_ocles
soils55327983s_o_ils
sokes95031423s_oke_s
sokols10399093s_okols
solely93714213s_olely
soles55547923s_ole_s
soleus64615613s_oleus
sols45448163s_o__ls
solvers104414253solvers
solves95018223solve_s
sones55444143s_one_s
sooners73916643sooners
sorel56231443s_orel_
sorely94618013s_orely
sores55454283s_ore_s
sorrels7310723sorrels
sotols63714473s_otols
souls55127363s_o_uls
soviets1087293s_oviets
sowens93613153s_owens
sowers94923443s_owers
speels85116393s_peels
spiels85317953s_piels
spinels94512443spinels
spodes94817433spode_s
spoils84614533spo_ils
spokes124417213spoke_s
spools85115913spo_ols
spores84726613spore_s
staves94525193stave_s
steels64117983s_teels
stipels9418953stipels
stivers103613543stivers
stogeys11486123stogeys
stokers114515183stokers
stokes104821793stoke_s
stoles63927673stole_s
stoners74817953stoners
stones65130033stone_s
stools65117023sto_ols
stopers94217373stopers
stopes84525893stope_s
storers75018683storers
stores65533663store_s
storeys10559653storeys
stove85220253stove__
stover94115643stove_r
streels73811343streels
suavely1376493suavely
surveils1144523surveils
surveys13357573surveys
swevens1334613swevens
swivel12369323swivel_
swives123915183swive_s
swivets13436963swivets
tholes94919783thole_s
towels94314643_towels
travels104711293travels
trovers103713323trovers
troves94719113trove_s
trowels10358363trowels
vowels124410483_vowels
wheels123811713wh_eels
wholes124616773whole_s
whores125617103whore_s
whorls124410163who_rls
wovens12449833_wovens
yodels104610073_yodels
yokels13488063_yokels

Search took 8 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.403443402.0
2DLD Change Limit1340273976.81319672.2
3Display Results3973970.1432776.2
 (SQL Overall)1786913977.35924282.0
 
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.