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

304 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
option8361271(None) 
options93810601options
potion84519571potion
action84719682action
adoption1146082adoption
caption113513692caption
cation83925502cation
coition9314312coition
cooption1288342cooption
kation104315682kation
lotion65716522lotion
motion85217552motion
nation64322802nation
notion64516582notion
onion54320972o_nion
operon8811772operon
opinion946792opinion
opsin7613472opsi_n
optic93715182opti_c
optics102810182optics
optima10106532optima
optime1079352optime
opting94514402opting
optional1047642optional
optioned1146382optioned
optionee1046512optionee
oration71617712oration
ovation101510022ovation
pion67235292_p_ion
piton76121582_piton
portion9615492portion
potions93417422potions
prion75119992_prion
ration64226012ration
sorption1037512sorption
abortion1048103abortion
actin74922553acti_n
actinon9459463actinon
actions94218513actions
adaption1145643adaption
adoptions1245783adoptions
alation72920553alation
amnion84812053amnion
amotion9710473amotion
anion55028813_anion
antlion7310293antlion
apian75018333ap_ian
apron7318833ap_ron
auction93412933auction
avion84218343_avion
axion1211316913_axion
basion84315853basion
bastion9312473bastion
baton75822423bat_on
beton76022063bet_on
boston8513043bost_on
bouton8311533bout_on
bunion83111313bunion
button8310273button
camion103917193camion
captions123813223captions
cations94524143cations
caution93013523caution
chiton112612393chiton
cion613330913__cion
citron83112983citron
coaction12310773coaction
coitions10312853coitions
conation101420883conation
cooptions13107743cooptions
copatron1246753copatron
cortin82423153corti_n
cotton8312993cotton
cutin75022783cuti_n
cyton101511463cyt_on
diction102313053diction
donation91513783donation
dotation91412733dotation
durion7510963durion
edition8310853edition
elation73620453elation
elution72913823elution
emotion9711303emotion
enation73419233enation
epigon937963epigon
epsilon944293epsilon
eruption1047043eruption
ethion938813ethion
faction122613333faction
fanion94514323fanion
fiction122010733fiction
fusion939773fusion
futon83113773fut_on
gabion93211033gabion
gonion73612833gonion
gumption1343983gumption
inion54620183_inion
intron64215023intron
iodation9310383iodation
ion36051023___ion
jeton124815403jet_on
jetton1338033jetton
kations114013663kations
latino64120473latino
lection92614863lection
legion75712983legion
leptin82512333lepti_n
lepton82510793lept_on
lesion64715063lesion
lion46334443__lion
lobation102110553lobation
location102113913location
locution10227663locution
logion76013723logion
lotions74614763lotions
matin75132853mati_n
matron83918313matron
mention9314373mention
minion83416243minion
monition10311723monition
morion86217733morion
morrion959003morrion
motions94215003motions
mouton8410853mout_on
muton73817003mut_on
mutton8510453mutton
nasion63914083nasion
nations74720563nations
natron64116023natron
niton55418283nit_on
notation81414603notation
notions74014483notions
novation111710013novation
oaten55222403oat_en
oblation1039863oblation
obtain839183obtain
octagon1045243octagon
octan71313483oct_an
octroi837363octroi
odeon6411483o_deon
often84611413oft_en
olein5316003olei_n
olio46829673o_lio_
olios54520853o_lios
onions64016433o_nions
oniony9369703o_niony
ontic74418573onti_c
onto46127663ont_o_
ootid61416693ooti_d
ootids71110353ootids
open66427003op__en
operation11313993operation
operons91411743operons
ophite11410563ophite
opine77422463op_ine
oping86322413op_ing
opinions1045933opinions
opioid9310083op_ioid
opium92812093op_ium
oppidan1243463oppidan
oppugn1142793oppugn
opsins8411713opsins
opt57545543opt___
opted84914273opt_ed
optical1149863optical
optician1247243optician
optimal1145783optimal
optimes1148473optimes
optimum1343353optimum
optionals1145343optionals
optionees1144343optionees
optioning1246553optioning
opts68124743opt__s
orations81515803orations
orcin72716573orci_n
orison6411663orison
orlon5415003o_rlon
orpin73415533orpi_n
orthicon1343503orthicon
ortho8312293ortho_
ostia52315583osti_a
ostiole739013ostiole
ostium8310133ostium
otic66624813o_ti_c
otiose639403o_tiose
otto45220643o_tto_
ottos54714323o_ttos
outbox1537463outbox
outdo6312703outdo_
outdone8311643outdone
outfox1636143outfox
outgo6312093outgo_
outgone8311463outgone
outgun7349643outgun
outing74128153outing
outman83115033outman
outran63218893outran
outrow9311183outrow
outrun63213303outrun
outsin63617563outsin
outworn101610753outworn
ovations11149263ovations
paction112713963paction
paeon74819493_paeon
pain65647243_pai_n
patin76832853pati_n
patio74426353patio_
patios85221783patios
patron84018043patron
pein65834943_pei_n
pelon74423213_pelon
peon65635243_p_eon
phon95925383_p_hon
pian66136093_p_ian
pin57066723_p_i_n
pinion83815893pinion
pinon76024533_pinon
pions75826393_p_ions
pirn67128373_p_irn
pitons85319043_pitons
pleon74216383_pleon
poison8312223poison
polio75722553polio_
polios84019723polios
pompon1238943pompon
ponton83217643ponton
pontoon93010703pontoon
poon67341263_p_oon
poplin10413483popli_n
portions10514403portions
position10912193position
postin83521033posti_n
potation101716783potation
potboy1397813potboy
poteen83514263poteen
pothos114214693pothos
potman102813573potman
potmen102713093potmen
potto75320943potto_
pottos84615873pottos
preoption1348073preoption
prions84317783_prions
prior74316173_prior
prison8514023_prison
ptisan8417973_ptisan
pupation1269503pupation
puton73617913_puton
pyin96823233_pyi_n
pylon103614003_pylon
python1447143python
ratio55227583ratio_
rations74123433rations
ratios64922673ratios
ratoon64417373ratoon
ratton64116123ratton
region74614903region
rogation91612053rogation
ronion63315643ronion
rotation81615453rotation
ruction93611613ruction
rutin55421343ruti_n
satin55935213sati_n
scion72214993_scion
section92515663section
seton55223543set_on
solation8916153solation
solion6616383solion
soliton7410233soliton
solution889593solution
sorptions1137113sorptions
spin66231303sp_i_n
spoon74719443sp_oon
station72717243station
suction93713043suction
taction93213023taction
talion6317713talion
tigon63914443__tigon
tin36362173__ti_n
titian62512663titian
tompion11247103tompion
ton310265103__t_on
toon47740633__toon
torsion7310803torsion
triton63914893triton
tuition738823tuition
turion6313163turion
unction9310663unction
union54519793_union
upon65817583up__on
upsilon943583upsilon
uptick1436763uptick
uptilt8410803uptilt
uptime1067673uptime
uptorn8268093uptorn
uptown11274963uptown
upturn8286243upturn
virion9310683virion
vision9311313vision
vocation132311983vocation
volition1179173volition
volution1198603volution
wanion93213063wanion
wonton93410963wont_on
zonation171410723zonation

Search took 6 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.1401276364.3
2DLD Change Limit1127163045.67319868.9
3Display Results3043040.0933268.8
 (SQL Overall)1786913045.90630255.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.