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

422 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
obelus834840(None) 
obolus8378811obolus
abeles84719392abeles
beaus75127112_beaus
bells76432162_bells
bels66142492_bel_s
belts75931162_belts
bolus79125542_bolus
obeahs1135862obeahs
obeli73711932obel_i
obelia8329452obelia
obelias9279032obelias
obelise9310172obelise
obelisk1345192obelisk
obelism1138202obelism
obes66036832obe__s
obeys107010642obe_ys
oboles83815832oboles
obols73715862obol_s
ocellus935982ocellus
oculus8178392oculus
abacus10349763abacus
abele76323253abel_e
abelia83114403abelia
abelias93213563abelias
abets75621673abe_ts
ables75935543ab_les
ablush1147223ab_lush
akelas10311193akelas
aneles64626293aneles
angelus8418463angelus
axels126313633axel_s
babels105216723babel_s
babus95620333_babus
balas76937213_balas
balds85524643_balds
bales76250083_bales
balks114926293_balks
balls76236413_balls
balms95723923_balms
bals66354043_bal_s
beads85429503_beads
beaks115326623_beaks
beams95328173_beams
beans75734693_beans
bears75739043_bears
beats76042243_beats
beau66137273_beau_
beaut75135213_beaut
beauts86015283_beauts
beaux146513213_beaux
becks135522013_becks
beds75937783_be_ds
bedu75923693_bedu_
beefs105618563_beefs
beeps95320973_beeps
beers75628393_beers
bees65453383_be_es
beets76131443_beets
begs75733833_be_gs
begum105213923_begum
begums11429493_begums
begun85113443_begun
bel57148463_bel__
belaud939133_belaud
belauds1036643_belauds
belay105021523_belay
belays114313853_belays
belch124415503_belch
belga8313233_belga
belgas9311713_belgas
belie75630383_belie
belies84631053_belies
bell66237183_bel_l
belle75827833_belle
belles85325993_belles
belly104625493_belly
belon73924113_belon
belons84119413_belons
below104617193_below
belows114614183_belows
belt65754033_bel_t
beluga936233_beluga
belugas1035903_belugas
bemas96424283_bemas
bemuse1038943_bemuse
bends85628973_bends
benes75536233_benes
bens65945703_be_ns
bents76033693_bents
bergs84718043_bergs
berks115423123_berks
berms95323663_berms
bes56557433_be__s
beses75830723_beses
bests75932613_bests
betas75528763_betas
beths105519223_beths
bets67051443_be_ts
beys913829553_be_ys
bields94110003bields
biles75542143_biles
bilks115117893_bilks
bills75632863_bills
blebs96416153_blebs
bless75917813_bless
blets75324943_blets
blub85324873_b_lub
blubs95818153_b_lubs
blue65328463_b_lue
blues75127043_b_lues
blur66020533_b_lur
blurs74619083_b_lurs
blush105115313_b_lush
bobbles104514913bobbles
bogles95020833bogles
bogus85616473_bogus
boils75427193boil_s
bolas74733763_bolas
bolds85825283_bolds
boles75448603_boles
boletus948643boletus
bolls75531313_bolls
bolos75531373_bolos
bolts76232113_bolts
bonus75324323_bonus
botels84815803botel_s
boules84925973boules
bowels114315593bowel_s
bowls106121433bowl_s
boylas113011723boylas
bubus95115453_bubus
bulbs96016933_bulbs
bulks115920613_bulks
bulls75629573_bulls
bus56950973_b__us
callus85317073callus
cells75428063_cells
cels65534973_cel_s
celts75325783_celts
chelas113817203chelas
cobalts1139203cobalts
cobbles133814823cobbles
cobles104622883cob_les
coleus86818273cole_us
corbels113813593corbel_s
cowbells1544993cowbells
deles65139253_deles
delfs94918673_delfs
delis64928543_delis
dells66630943_dells
dels56745473_del_s
delts65731793_delts
doblas93812293dob_las
dowels104813343dowel_s
duels65619233duel_s
dwells10417713dwells
ecus65421463__ecus
eels46536743_eel_s
elds56324853__elds
elks85820033__elks
ells46431353__ells
elms67322703__elms
els37645723__el_s
embolus1135543embolus
emeus76913333eme_us
emus66821683__emus
feels85223043feel_s
fells85327383_fells
felts85324543_felts
fetus85816543_fetus
feus75830753_fe_us
fields104211043fields
fjelds17414473fjelds
flus75626543__flus
foetus958523foetus
fuels87117353fuel_s
gallus74313203gallus
gelds75118343_gelds
gels56836103_gel_s
gelts65924613_gelts
genus65319833_genus
gobbles123512583gobbles
goblets103210183goblets
heels85625533heel_s
hells85032043_hells
helms105619463_helms
helos84928063_helos
helps105219343_helps
hilus84817643_hilus
hobbles143313783hobbles
hosels94218613hosel_s
hotels94515523hotel_s
hovels125413343hovel_s
ibexes15436163ibexes
iglus6609933_iglus
ileus54616893ile_us
jebels15418913jebel_s
jehus15488573_jehus
jells125522163_jells
jobless16237563jobless
keels94622413keel_s
kelps115116423_kelps
kelts95222633_kelts
knells10439253knells
kobolds1474343kobolds
koels94613903koel_s
kvells13346613kvells
labels84515683label_s
libelous1047193libelous
libels85112693libel_s
lieus56218483lie_us
lobelia947213lobelia
lobelias1047203lobelias
lobes75331003lobe__s
lobules92510813lobules
loculus9296973loculus
losels64714593losel_s
lulus54315163_lulus
melds84822383_melds
mells75031333_mells
mels65941533_mel_s
melts74930103_melts
menus75822843_menus
meous76120063_meous
mobiles112813123mobiles
models94216363model_s
modulus10245333modulus
mohels115011333mohel_s
morels84820023morel_s
motels83616903motel_s
naevus934593naevus
negus64513563_negus
nevus84611393_nevus
nexus124710663_nexus
nobbles114014523nobbles
nobelium1245713nobelium
nobeliums1343893nobeliums
nobles83319723nob_les
noels56418703noel_s
nonplus936183nonplus
novels95512503novel_s
obas65730933ob__as
obe56638643obe___
obeah1038993obe_ah
obelised1136173obelised
obelises1039103obelises
obelisks1443443obelisks
obelisms1236393obelisms
obelize1838243obelize
obelizes1937513obelizes
obento837893obento
obentos936703obentos
obese75212423obe_se
obey96521303obe__y
obeyed1235823obeyed
obeyer1135893obeyer
obeyers1234813obeyers
obias76116863ob_ias
obis66226843ob__is
obits74617553ob_its
objects18123693objects
objets15125323objets
oblast8613663ob_last
oboes75717713ob_oes
obol65220613obol__
obole75917143obol_e
oboli73712873obol_i
obsequy2141863obsequy
obsess845943obsess
obtests9136233obtests
obtuse8147483ob_tuse
obverts1235403obverts
obvious1244823obvious
oceans81211003oceans
ocelli836843ocelli
ocelot8813383ocelot
ocelots977233ocelots
odeons739023odeons
odes57243243ode__s
odeum84610543ode_um
odeums9367313odeums
odious749933odious
odyles10348563odyles
odyls9428653odyl_s
oes35866193o_e__s
ogees65119143oge_es
oglers74313183oglers
ogles65223183o_gles
oilers64721193oilers
oils46337973o_il_s
okehs12477463oke_hs
okes84936343oke__s
olds55926573o__lds
oleins6313523oleins
oleos55419683ole_os
oles46453473o__les
oleum73613323ole_um
oleums8358783oleums
ollas54218283o_llas
ombers104214403ombe_rs
omegas936983omegas
omelet8317073omelet
omelets938333omelets
omens75618963ome_ns
omers76923193ome_rs
onerous7312973onerous
ones46146533one__s
onus45826813o__nus
oodles73517183oodles
opals75718353opal_s
opens76118553ope_ns
operas8312453operas
opes65942613ope__s
opus66420593o__pus
orals55826483oral_s
orbless937493orbless
oreads73915773oreads
ores46056683ore__s
oriels64914623oriel_s
orles55326213o_rles
ormolus934743ormolus
oses46641513ose__s
osmous8138183osmous
osseous736063osseous
ousels64815283ousel_s
ouzels15408703ouzel_s
ovals85413393oval_s
ovens86217453ove_ns
overlush1445273overlush
overplus1336063overplus
overs85224793ove_rs
overuse10310923overuse
ovolos9257203ovolos
ovules938223ovules
owes75137103owe__s
owlets93110393owlets
owls76022933o_wl_s
oxalis1339223oxalis
oxes116530723oxe__s
oxeyes1635893oxeyes
oyers87620883oye_rs
oyes74940133oye__s
oyezes1835053oyezes
peels75226423peel_s
peles75738083_peles
pelfs105016293_pelfs
pelts76128813_pelts
peplus10138343peplus
pileus84514943pileus
pilus75921063_pilus
plexus15377283plexus
plus66324833__plus
poilus82210573poilus
pomelos11218133pomelos
quells15359703quells
rebels84518133rebel_s
rebus75721113_rebus
reels55333263reel_s
rhesus936203rhesus
riels55121333riel_s
robalos937683robalos
robes75133303robe__s
robles85321693rob_les
rowels94515453rowel_s
rubels84112993rubel_s
seels55632823seel_s
selfs85220243_selfs
sells55134433_sells
sels46345983_sel_s
shells94319523shells
skells105013783skells
skelms12368023skelms
skelps12407923skelps
smells83914743smells
smelts85412773smelts
snells64614203snells
sobers85218863sobe_rs
soleus64615613sole_us
solus54726983_solus
sorels63921163sorel_s
spells84617683spells
spelts84614643spelts
steles63725663steles
stylus9397463stylus
sulus54821883_sulus
swells93913983swells
taels56822073tael_s
talus55423263_talus
teels55726373teel_s
teles54536003_teles
tells55828943_tells
telos55424523_telos
tels46841693_tel_s
tolus55024483_tolus
towels94314643towel_s
ulus45622563__ulus
umbels104510593umbel_s
unbelts9237663unbelts
uterus639203uterus
uveous936603uveous
velds95615583_velds
velum10713383_velum
venus84918903_venus
villus93611223villus
vowels124410483vowel_s
welds94719163_welds
wells85426193_wells
welts85225193_welts
whelks16367323whelks
whelms14377573whelms
whelps14437843whelps
wields10469623wields
wobbles143412433wobbles
xerus12313333_xerus
yelks126413623_yelks
yells85821943_yells
yelps105712993_yelps
yields10466843yields
yodels104610073yodel_s
yokels13488063yokel_s
zebus164610053_zebus

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 Filter1786911127160.393454684.5
2DLD Change Limit1127164226.93616250.9
3Display Results4224220.1263349.2
 (SQL Overall)1786914227.45523969.3
 
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.