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

382 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
odious74993(None) 
adieus739632adieus
adios65822862adio_s
adipous1037182adipous
copious11311962copious
diols65521012_diols
folious103710732folious
idioms956412idioms
idiots768642idiots
iodous7311502iod_ous
modiolus1143772modiolus
nodous7711332nod_ous
noxious1446562noxious
obvious1244822obvious
odeons739022odeons
odiously1245422odiously
odists749852odists
odium83413032odi_um
odiums9337942odiums
odorous837662odorous
odors64514282od_ors
odour64710492od_our
odours7418252od_ours
olios54520852olio_s
ominous949032ominous
onions64016432onions
osmious936002osmious
osmous8138182osmous
pious74621272_pious
tedious838442tedious
vodous1038602vod_ous
acinous9310933acinous
acinus8311253acinus
adieu6417423adieu_
adieux1444283adieux
adits66523713adi_ts
adnoun757033adnoun
adnouns835453adnouns
ados57633513ad_o_s
agios65919863agio_s
amicus103810003amicus
animus84211613animus
anions64123033anions
anxious1437283anxious
apodous1037403apod_ous
arduous837613arduous
audios72312283audio_s
aurous64119263aurous
avions94114393avions
awmous1157713awmous
axioms15408053axioms
axions134713483axions
bayous11411153bayous
bijous1548043bijous
bilious9310933bilious
biogs85016113_biogs
bios66335323_bio_s
bodacious1443993bodacious
bodices12710593bodices
bodies94524143bodi_es
bodings113711653bodings
boubous1138693boubous
brios74725723brio_s
carious93320283carious
cerous85821203cerous
chiaus113611313chiaus
chirus114615693chirus
cions75222853_cions
coccous1039003coccous
codices12512583codices
codons96119463cod_ons
coitus8511893coitus
comous10816503comous
congous103615083congous
cormous11312353cormous
coypous14248813coypous
curious93813563curious
cymous1388403cymous
devious1138523devious
dhows125911223_dhows
dials64925343_dials
dibs76233683_di_bs
dices86434243_dices
dicks125824693_dicks
dicots94915793_dicots
didoes85716963_didoes
didos76820813_didos
dies55653523_di_es
diets66026643_diets
diffs126315483_diffs
difs86027323_di_fs
digs66036053_di_gs
dikes105831333_dikes
dills65530973_dills
dimes85833043_dimes
dimout9414243_dimout
dimouts1037893_dimouts
dims75435023_di_ms
dines66449153_dines
dings76331403_dings
dingus83611843_dingus
dinks105927953_dinks
dinos65428063_dinos
dins56652043_di_ns
dints67431313_dints
diode74716113_diode
diodes83915783_diodes
diol57329133_dio_l
dips75536913_di_ps
dirks105619523_dirks
dirls64720503_dirls
dirts66824463_dirts
dis46459893_di__s
discs85316263_discs
discus94512113_discus
disks105417473_disks
diss56434483_di_ss
disuse74012843_disuse
ditas65923673_ditas
dites66339153_dites
dits56450523_di_ts
divas95418583_divas
dives95832403_dives
divots104712203_divots
docs75631153_d_ocs
dodoes85716103dodoes
dodos75819393dodo_s
does56554473_d_oes
dogs66440153_d_ogs
doings84913183doings
doits66223673doi_ts
dojos135111793dojo_s
dolors75115313dolors
dolour75710133dolour
dolours8438823dolours
dols56943053_d_ols
doms76239573_d_oms
donors75115793donors
dons56048703_d_ons
doofus1036163doofus
dooms85321343_dooms
doors65022133_doors
dors56747603_d_ors
dos48062313_d_o_s
doss56235043_d_oss
dots55647663_d_ots
doum76226673_d_oum
doums85417643_d_oums
dour56330433_d_our
douse66329723_d_ouse
doux125817983_d_oux
dows85941053_d_ows
drops85719503_drops
dross65418093_dross
drouk1039433_drouk
drouks1137123_drouks
dubious1036893dubious
dufus94010813_dufus
duos56728133_duo_s
edacious1146023edacious
eddoes8199143eddoes
edicts94911703edicts
ediles74016983ediles
editors839423editors
edits65819033edi_ts
eidos65817753eido_s
envious1037223envious
famous11412393famous
ficus105015493_ficus
fidos95819053fido_s
folios93915463folio_s
fucous11399863fucous
furious103110633furious
glorious946823glorious
godsons966663godsons
griots74713643griots
haikus13538293haikus
heinous1038853heinous
hideous1168433hideous
hilus84817643_hilus
hydrous14197883hydrous
idiocy1273463idiocy
idiom899963idio_m
idiot6718863idio_t
idols65514133id_ols
impious1137063impious
inions64417003inions
iodides93811613iodides
iodids83711153iodi_ds
iodines83616633iodines
iodins74216523iodi_ns
iodises83413633iodises
iodisms10308483iodisms
iodizes173911723iodizes
ions46737853__ions
joyous16276763joyous
lidos65219883lido_s
lieus56218483_lieus
lions55923213_lions
logions86211293logions
lotions74614763lotions
lupous849433lupous
medius93613283medi_us
melodious1245233melodious
meous76120063_meous
miaous8511693miaous
minus75223933_minus
modicum1445073modicum
modicums1543483modicums
modioli1045483modioli
modulus10245333modulus
modus85417203mod__us
morions94014643morions
motions94215003motions
mucous104411653mucous
nairus639143nairus
nidus65913573_nidus
nimious937663nimious
nisus56014393_nisus
nocuous946583nocuous
nodulous944733nodulous
nodus66315993nod__us
notions74014483notions
nous46136983__nous
obelus8348403obelus
obias76116863obi_as
obis66226843obi__s
obits74617553obi_ts
oboes75717713o_boes
obols73715863o_bols
obolus8378813obolus
ochrous1237943ochrous
octopus1144813octopus
oculus8178393oculus
odahs95610083od_ahs
odas57230263od__as
odds68919923od__ds
odeon6411483odeo_n
odes57243243od__es
odeum84610543od_eum
odeums9367313odeums
odic74920573odi__c
odiferous1343943odiferous
odist6421913odi_st
odor55718093od_o_r
ods47546213od___s
odyles10348563odyles
odyls9428653od_yls
ogives10367913ogives
ohias84415573ohi_as
oidioid946053oidioid
oidium959813oidium
oils46337973o_i_ls
oinks94819913o_inks
oldies7314423oldi_es
oleos55419683oleo_s
olio46829673olio__
olives94313953olives
omits75018263omi_ts
omnibus1152983omnibus
onerous7312973onerous
onion54320973onio_n
oniony9369703oniony
onium73115533oni_um
onos46229003o_no_s
onus45826813o__nus
oohs75220693o__ohs
oops65232673o__ops
oots46446443o__ots
opines84820703opines
opioid9310083opioid
opioids1036523opioids
opium92812093opi_um
opiums10307073opiums
options93810603options
opus66420593o__pus
ordines83014903ordines
ordos65216203ordo_s
ordurous944753ordurous
oribis838833oribis
oriels64914623oriels
oriole6814293oriole
orioles7412993orioles
orisons7310563orisons
orlons6411013orlons
orlops847303orlops
ormolus934743ormolus
orzos143311253orzo_s
osiers63412793osiers
osmols8137313osmols
osseous736053osseous
otiose639403otiose
otitis63612343otitis
ottos54714323otto_s
ouzos143210413ouzo_s
ovibos1145463ovibos
ovines94614343ovines
ovoids10456923ovoids
oxbows1833713oxbows
oxides14109693oxides
oxids13128963oxi_ds
oximes15107423oximes
oxims14107643oxi_ms
ozonous1645263ozonous
parous84024163parous
pilous84717753pilous
pilus75921063_pilus
pions75826393_pions
podites103014733podites
podium112911913podi_um
podiums12227633podiums
podsols1056513podsols
podzols1934683podzols
poilus82210573poilus
polios84019723polio_s
pompous1338063pompous
porous84419483porous
potions93417423potions
poyous112911623poyous
primus103712173primus
prions84317783prions
priors83914483priors
quipus17458003quipus
radios74018673radio_s
radius73914873radi_us
ramous8417113ramous
rimous8311913rimous
riots54922013_riots
risus54216393_risus
rodeos75314503rodeo_s
ronions73313343ronions
rosinous847373rosinous
rubious938283rubious
rufous948273rufous
rugous739653rugous
ruinous739763ruinous
sajous13310583sajous
sanious7514103sanious
scions82612243scions
serious73616283serious
serous65023563serous
setous64917373setous
simious939803simious
sinus55523853_sinus
situs55019233_situs
sodium92111453sodi_um
sodiums10177213sodiums
sodoms989673sod_oms
solidus8338113solidus
solions7513753solions
soukous1136413soukous
sous46947213__sous
spinous9310443spinous
studious9245553studious
thiols95112763thiols
thous86017263_thous
todies74223553todi_es
torous64319033torous
tortious839023tortious
triols66117803triols
trios55528093trio_s
udons65411463ud_ons
udos56619903ud_o_s
unions64216753unions
urinous7310083urinous
uveous936603uveous
uxorious1544413uxorious
various103113103various
venous93713193venous
vicious1239493vicious
vinous93914173vinous
viols86118103_viols
virus85316843_virus
vodou939343vod_ou_
vodoun1036233vod_oun
vodouns1134763vod_ouns
vomitous13215803vomitous
vomitus12215743vomitus
widows1376563widows
wondrous1246823wondrous
yous76230653__yous
zodiacs1943423zodiacs

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.393454684.5
2DLD Change Limit1127163825.84319290.8
3Display Results3823820.1233105.7
 (SQL Overall)1786913826.35928100.5
 
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.