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

296 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
options9381060(None) 
option83612711option_
potions93417421potions
actions94218512actions
adoptions1245782adoptions
captions123813222captions
cations94524142cations
coitions10312852coitions
cooptions13107762cooptions
kations114013662kations
lotions74614762lotions
motions94215002motions
nations74720562nations
notions74014482notions
onions64016432o_nions
operons91411742operons
opinions1045932opinions
opsins8411712opsi_ns
optics102810182opti_cs
optimes1148472optimes
opting94514402opti_ng
optional1047642optional
optionals1145342optionals
optioned1146382optioned
optionee1046512optionee
optionees1144342optionees
orations81515802orations
ovations11149262ovations
pions75826392_p_ions
pitons85319042_pitons
portions10514412portions
potion84519572potion_
prions84317782_prions
rations74123432rations
sorptions1137122sorptions
abortions1147783abortions
actinons10389453actinons
actins86321103acti_ns
action84719683action_
adaptions1245223adaptions
adoption1146083adoption_
alations82518893alations
amnions93710913amnions
amotions1069843amotions
anions64123033_anions
antlions839193antlions
aprons8316993ap_rons
auctions104012143auctions
avions94114393_avions
axions134713483_axions
basions94213953basions
bastions10411693bastions
batons85519423bat_ons
betons84919553bet_ons
bostons9312903bost_ons
boutons9310783bout_ons
bunions92210473bunions
buttons9310333buttons
camions113916133camions
caption113513693caption_
captious122810573captious
cation83925503cation_
cautions103313183cautions
chitons122611913chitons
cions75222853__cions
citrons92913223citrons
coactions1349743coactions
coition9314313coition_
conations111318903conations
cooption1288343cooption_
copatrons1346333copatrons
copious11311963cop_ious
cortins92421333corti_ns
cottons9312193cottons
cutins83919983cuti_ns
cytons111710183cyt_ons
dictions111812673dictions
donations101112353donations
dotations101411633dotations
durions839963durions
editions9310403editions
elations83719123elations
elutions82513053elutions
emotions10610283emotions
emptins1179403empti_ns
enations83316903enations
epigons1048183epigons
epsilons1044223epsilons
eruptions1146763eruptions
ethions1038483ethions
factions133013063factions
fanions103713073fanions
fictions132410743fictions
fusions1039153fusions
futons93911513fut_ons
gabions102410053gabions
gumptions1443773gumptions
inions64417003_inions
introns73515023introns
iodations1039113iodations
ions46737853___ions
jetons134512613jet_ons
jettons1437273jettons
kation104315683kation_
latinos73613803latinos
lections102413843lections
legions84611783legions
leptins92412693lepti_ns
leptons91910433lept_ons
lesions73813873lesions
lions55923213__lions
lobations11219613lobations
locations112512743locations
locutions11207063locutions
logions86211293logions
lotion65716523lotion_
matins84527783mati_ns
matrons93517633matrons
mentions10312893mentions
minions93314623minions
monitions11310883monitions
morions94014643morions
morrions1077673morrions
motion85217553motion_
moutons9410313mout_ons
mutons84314363mut_ons
muttons949283muttons
nasions73112383nasions
nation64322803nation_
natrons73215663natrons
nitons64614903nit_ons
notations91512973notations
notion64516583notion_
novations12139003novations
oblations1139373oblations
obtains939163obtains
obvious1244823obvious
octagons1144493octagons
octans81411143oct_ans
octrois938333octrois
odeons739023o_deons
odious749933o_dious
oleins6313523olei_ns
olios54520853o_lio_s
onion54320973o_nion_
oniony9369703o_niony
ootids71110353ooti_ds
opens76118553op__ens
operations12312953operations
operon8811773operon_
ophites12310103ophites
opine77422463op_i_ne
opines84820703op_ines
oping86322413op_i_ng
opinion946793opinion_
opioid9310083op_ioid
opioids1036523op_ioids
opiums10307073op_iums
oppidans1343083oppidans
oppugns1241933oppugns
opsin7613473opsi_n_
optic93715183opti__c
optical1149863optical
opticians1345543opticians
opticist1248923opticist
optima10106533opti_ma
optimal1145783optimal
optime1079353opti_me
optimise1255583optimise
optimism1445213optimism
optimist1256873optimist
optimum1343353optimum
optimums1442563optimums
optioning1246553optioning
opts68124743opt___s
oration71617713oration_
orcins83313433orci_ns
orisons7310563orisons
orlons6411013o_rlons
orpins83614163orpi_ns
orthicons1443423orthicons
osmious936003osmious
ostiole739013ostiole
ostioles839273ostioles
otiose639403o_tiose
otitis63612343o_titis
ottos54714323o_tto_s
outdoes8313123outdoes
outdone8311643outdone
outgoes8312643outgoes
outgone8311463outgone
outguns8318693outguns
outing74128153outi_ng
outings84014753outings
outmans92413283outmans
outrows10311403outrows
outruns72911543outruns
outsins73417863outsins
ovation101510023ovation_
pactions122613503pactions
paeons83915523_paeons
pains75138283_pai_ns
patins87528783pati_ns
patios85221783patio_s
patrons93818103patrons
peins76128063_pei_ns
peons75327183_p_eons
phons105221143_p_hons
pians75126963_p_ians
pinions93413603pinions
pinons86019943_pinons
pins65558453_p_i_ns
pion67235293_p_ion_
pious74621273_p_ious
pirns76020093_p_irns
piton76121583_piton_
pleons84213343_pleons
poisons9310353poisons
polios84019723polio_s
pompons1338553pompons
pons65850603_p__ons
pontons93315553pontons
pontoons10279313pontoons
poons75430973_p_oons
poplins11313153popli_ns
portion9615493portion_
positions11811503positions
postins93721203posti_ns
potations111615073potations
potboys1475273potboys
poteens92910883poteens
pothos114214693potho_s
pottos84615873potto_s
preoptions1447643preoptions
prion75119993_prion_
priors83914483_priors
prisons9313223_prisons
ptisans9317363_ptisans
pupations1338123pupations
putons83515153_putons
pyins105815863_pyi_ns
pylons113011243_pylons
pythons1537363pythons
ration64226013ration_
ratios64922673ratio_s
ratoons73815473ratoons
rattons73815323rattons
regions83613473regions
rogations101510823rogations
ronions73313343ronions
rotations91613843rotations
ructions102811683ructions
rutins63818393ruti_ns
satins64930483sati_ns
scions82612243_scions
sections102714703sections
setons64620173set_ons
solations9814623solations
solions7513753solions
solitons849593solitons
solutions988883solutions
sorption1037513sorption_
spins75327983sp_i_ns
spoons84116023sp_oons
stations82415223stations
suctions103012903suctions
tactions102912423tactions
talions7314113talions
tigons74112263__tigons
tins45251303__ti_ns
titians72710453titians
tompions12267003tompions
tons46553053__t_ons
toons55027533__toons
torsions839183torsions
tortious839023tortious
tritons73814883tritons
tuitions838283tuitions
turions7311573turions
unctions1039733unctions
unions64216753_unions
upsilons1043173upsilons
upticks1535153upticks
uptilts934733uptilts
uptimes1177553uptimes
uptoss836093upt_oss
uptowns12194343uptowns
upturns9264973upturns
virions1039873virions
visions10311023visions
vocations141911423vocations
volitions1288663volitions
volutions12108393volutions
wanions104011373wanions
wontons103310533wont_ons
zonations18139313zonations

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.406440125.6
2DLD Change Limit1340272966.03022226.7
3Display Results2962960.1102690.9
 (SQL Overall)1786912966.54627297.7
 
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.