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

217 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
obelia832945(None) 
abelia83114401abelia
lobelia947211lobelia
obeli73711931obeli_
obelias9279031obelias
abelian92810642abelian
abelias93213562abelias
abulia83512502abulia
belga8313232_belga
belie75630382_belie
lobelias1047202lobelias
obelise9310172obelise
obelisk1345192obelisk
obelism1138202obelism
obelize1838242obelize
obelus8348402obelus
obia67923112ob__ia
oboli73712872oboli_
telia55821142_telia
abasia8712953abasia
abele76323253abel_e
abeles84719393abeles
abolla8410193abolla
aboulia966553aboulia
abulias93210693abulias
abulic106411423abulic
acedia9310393acedia
aecia73819283_aecia
akela9311343akel_a
alexia132910463alexia
anemia82613573anemia
aphelia1249423aphelia
atelic8313703atelic
babesia1146623babesia
balsa77920413_balsa
bedim10313833_bedim
befit105222663_befit
beflea1147123_beflea
begin85117353_begin
bel57148463_bel__
belay105021523_belay
belch124415503_belch
beldam11410113_beldam
beleap10410283_beleap
belgas9311713_belgas
belied95022163_belied
belief115018603_belief
belier84423563_belier
belies84631053_belies
belike124616283_belike
belive115415303_belive
bell66237183_bel_l
belle75827833_belle
bells76432163_bells
belly104625493_belly
belon73924113_belon
below104617193_below
bels66142493_bel_s
belt65754033_bel_t
belts75931163_belts
beluga936233_beluga
bema85825253_be_ma
bemix165011453_bemix
berlin83116373_berlin
beta66234133_be_ta
betta74916843_betta
bewig1138903_bewig
beylic1337823_beylic
beylik1545883_beylik
bezil163812883_bezil
blin67228173_b_lin
blip88322773_b_lip
boccia12338793boccia
bohemia1446363bohemia
bola66035563_bol_a
bollix1538053bollix
borrelia1044553borrelia
boyla102912363boyl_a
bulla74620563_bulla
bumelia1145263bumelia
camelia11510433camelia
celiac101910433_celiac
cella75420313_cella
ceria75125353_ceria
chela103916803chel_a
cilia73016763_cilia
cobia94117513cob__ia
codeia94112193code_ia
coeliac1138233coeliac
coremia11310363coremia
dahlia1035773dahlia
deli55631293_deli_
delis64928543_delis
delta66117773_delta
dobla84913643dob_l_a
dulia61014983_dulia
eyelid1038443eyelid
felid94717173_felid
fella84918653_fella
feria85922713_feria
folia83618933_folia
gelid74916983_gelid
glia56423153__glia
goblin939503gob_lin
godetia945353godetia
heliac111010893_heliac
helio85321193_helio
helix154413013_helix
ilia46026823__ilia
kelim11912553_kelim
labella988943labella
lobefin1244603lobefin
lobeline1039963lobeline
media84721713_media
melic94722333_melic
milia72719573_milia
mohelim1444763mohelim
mycelia1444843mycelia
myelin1138973myelin
nobelium1245713nobelium
novella1076213novella
oba57531553ob___a
obe56638643obe___
obeah1038993obe_ah
obeahs1135863obeahs
obeliscal1351953obeliscal
obelised1136173obelised
obelises1039103obelises
obelisks1443443obelisks
obelisms1236393obelisms
obelized2036333obelized
obelizes1937513obelizes
obento837893obento
obes66036833obe__s
obese75212423obe_se
obesity1275653obesity
obey96521303obe__y
obeyed1235823obeyed
obeyer1135893obeyer
obeying1336543obeying
obeys107010643obe_ys
obi57127733ob__i_
obias76116863ob__ias
obis66226843ob__is
obit66837083ob__it
oblige937653ob_lige
obol65220613obol__
obole75917143obol_e
oboles83815833oboles
obols73715863obol_s
obolus8378813obolus
obtain839183obtain
ocellar936533ocellar
ocelli836843ocelli
oceloid1037973oceloid
ocelot8813383ocelot
oculi72010793oculi_
odea56224573ode__a
ohia75719363o__hia
oidia6314953o_idia
olea46532723o__lea
olefin937583olefin
oleic7313333ole_ic
olein5316003ole_in
olio46829673o__lio
olla44821173o__lla
omega836383ome_ga
omelet8317073omelet
omenta83411723omenta
opera7313573ope_ra
osetra667423osetra
ossia53710403o_ssia
ostia52315583o_stia
otalgia844483otalgia
outlie62419533outlie
overlie102615013overlie
overlit102714743overlit
ovoli8358283ovoli_
oxalic1537093oxalic
oxalis1339223oxalis
oxlip1456883o_xlip
ozalid1696683ozalid
paella8410913paella
pallia83015593pallia
prelim10311423prelim
pyemia1337553pyemia
qualia1559563qualia
quelea1547303quelea
realia6314593realia
redia65524483_redia
relic74623363_relic
relit55340683_relit
retia55326113_retia
rubella9146523rubella
selva83014273_selva
sepia75318673_sepia
sheila969843sheila
shelta93111793shelta
sobeit8315363sobe_it
stela54019043stel_a
stelai63912563stelai
stelic8313083stelic
stella63612973stella
taenia6313193taenia
tela45532973_tel_a
telial65815363_telial
telic76019823_telic
tenia55324483_tenia
thulia936113thulia
toxemia1644873toxemia
uredia73610063uredia
uremia82910893uremia
vela75725543_vel_a
xenia124814773_xenia
yeelin939343yeelin
zoecia1735553zoecia
zooecia1843843zooecia

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 Filter1786911127160.403443402.0
2DLD Change Limit1127162175.95318934.3
3Display Results2172170.0802712.5
 (SQL Overall)1786912176.43627764.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.