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

326 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
operon881177(None) 
operons91411741operons
apron7318832ap_ron
heron85025502_heron
hyperon1548182hyperon
odeon6411482ode_on
open66427002ope__n
opera7313572oper_a
operand1038002operand
operant9317222operant
operas8312452operas
operose939432operose
option83612712option
pelon74423212_pelon
peon65635242_pe_on
pereon83517452_pereon
perron83216622_perron
person83517872_person
aeon45634613_ae_on
aero45435343_aero_
aileron739833aileron
aleuron757383aleuron
aper66336233aper__
apercu1057383apercu
apers76629133aper_s
apery106517903aper_y
aprons8316993ap_rons
baron78131243_baron
belon73924113_belon
beton76022063_beton
bicron103710773bicron
bolero8412093bolero_
boleros9310293boleros
boron76727143_boron
cero66329453_cero_
ceros74726073_ceros
chaperon1547353chaperon
chevron1575783chevron
citron83112983citron
copatron1246753copatron
copen94826433cope__n
copepod1444853copepod
coper95336093coper__
copers104629843coper_s
crepon1039943crepon
dacron94310693dacron
daemon9279593daemon
demon86520313_demon
devon95113683_devon
dipteron1145593dipteron
diuron738573diuron
doper86128393doper__
dopers95522483doper_s
ebon66821103__ebon
elevon977953elevon
emerod9139213emerod
emperor1155483emperor
enteron7313333enteron
eon36052083__e_on
epergne1046143epergne
epigon937963epigon
ern35738363__er_n
eros45238453__eros
exon117116803__exon
felon84619293_felon
fern76129323_fer_n
flaperon13124843flaperon
fleuron1055573fleuron
foreran10311793foreran
forerun1037653forerun
garron73113493garron
giron66118993_giron
govern1036823gover_n
guenon736403guenon
guerdon944343guerdon
gyron95314623_gyron
hadron102913753hadron
hereon93914363_hereon
hern76134893_her_n
hero74635783_hero_
heroin94420593_heroin
herons94820543_herons
heros84930863_heros
hoper105829143hoper__
hopers114222973hoper_s
hyperons1649203hyperons
intron64215023intron
iron46728463__iron
jeon116821443_je_on
jeton124815403_jeton
kern85326213_ker_n
ladron73413323ladron
lemon75618183_lemon
lepton82510803lepton
longeron945763longeron
loper75129233loper__
lopers84424143loper_s
macron103615673macron
marron83717543marron
matron83918313matron
melon73922083_melon
merlon83012353_merlon
meson74118313_meson
micron103714283micron
mikron12318503mikron
modern939523moder_n
moneran9311113moneran
monuron937463monuron
moper94925923moper__
mopers104220373moper_s
mopery135210973moper_y
moron76925423_moron
natron64116023natron
neon47026423_ne_on
nephron1246653nephron
nerol51017813_nerol
neuron6310373neuron
noniron738373noniron
nonperson1165263nonperson
ocean71212963oce_an
ocelot8813383ocelot
octroi837363octroi
odeons739023ode_ons
offeror1342943offeror
olefin937583olefin
olein5316003ole_in
oleo46630483ole_o_
oleos55419683ole_os
omen66828183ome__n
omer67028393omer__
omers76923193omer_s
omicron1165063omicron
omikron1353173omikron
onerous7312973onerous
onery8414123oner_y
onion54320973o_nion
ope56845243ope___
oped76230153ope__d
opened94311863opened
opener83910993opener
opening1039923opening
openly1137123openly
opens76118553ope_ns
operands1146813operands
operants1039483operants
operate9615733operate
operation11314003operation
operator10310093operator
opes65942613ope__s
opinion946793opinion
oppugn1142793oppugn
opsin7613473op_sin
options93810603options
orison6411663orison
orlon5415003o_rlon
outran63218893outran
outrow9311183outrow
outrun63213303outrun
oven76624143ove__n
over77227343over__
overborn13128703overborn
overcoy1536633overcoy
overdo10128363overdo
overdog12106523overdog
overdone121210913overdone
overed102216623overed
overfond1537323overfond
overhot13411223overhot
overing111918053overing
overjoy2034873overjoy
overlong1238123overlong
overly122411363overly
overman12311463overman
overmen12311803overmen
overran10311663overran
overrun1038023overrun
overs85224793over_s
oversoon1138303oversoon
overt85630723over_t
overtone111012573overtone
overtop1237723overtop
overworn14118833overworn
oxen116218593oxe__n
oyer75927653oyer__
oyers87620883oyer_s
paeon74819493_paeon
pardon94618733_pardon
parol74826273_parol
parson83817903_parson
parton84720993_parton
patron84018043patron
pean66147173_pe_an
pecan91919033_pecan
pedro8313153_pedro_
pedros9312183_pedros
peen65938083_pe_en
pein65834943_pe_in
pekan111613973_pekan
pekin111514423_pekin
pekoe114612363_pekoe
pen56558843_pe__n
pennon8310643_pennon
peons75327183_pe_ons
peony105717563_pe_ony
peperoni1246273peperoni
pepo87622153_pepo_
pepos96620083_pepos
per56353093_per__
perch124518833_perch
perdu84216273_perdu
perdy115417333_perdy
pere66450263_per_e
perea75026443_perea
pereion9312053_pereion
pereons92815003_pereons
peres76246643_peres
peri65636973_per_i
perigon1039853_perigon
peril75425953_peril
period9314983_period
peris75537073_peris
perk106232843_per_k
perks115325803_perks
perky145319483_perky
perm85834633_per_m
perms95524513_perms
pernod9310453_pernod
peroxy1838253_peroxy
perp89029893_per_p
perps95521483_perps
perrons93115483_perrons
perry105222713_perry
perse75429523_perse
persona92812453_persona
persons93717013_persons
pert66759323_per_t
perv97224813_per_v
pervs105117373_pervs
peso66925823_peso_
pesos77221623_pesos
petrol82714063_petrol
phon95925383_p_hon
pinon76024533_pinon
pion67235293_p_ion
pirn67128373_pir_n
pirog83913673_pirog
piton76121583_piton
pleon74216383_pleon
pleuron976343pleuron
pogrom1138593pogrom
poison8312223poison
polaron939843polaron
pompon1238943pompon
ponton83217643ponton
poon67341263_p_oon
popcorn1344903popcorn
popedom1445453popedom
popery134511703poper_y
porn65636023_por_n
porno75120653_porno
potion84519573potion
preen75925053_preen
preop94715873_preop
prion75119993_prion
pro55837263_p_ro_
proa66229963_p_roa
prod76129503_p_rod
prof96134663_p_rof
prog75729003_p_rog
prom87631703_p_rom
prone75332623_p_rone
prong85218113_p_rong
prop85932813_p_rop
pros65742783_p_ros
prow97030383_p_row
pterin81014153pterin
purin75527593_purin
puton73617913_puton
pylon103614003_pylon
pyran10514473_pyran
pyro96019393_pyro_
pyrone112714473_pyrone
pyros105718293_pyros
quern143610403quer_n
recon75624243_recon
redon65424883_redon
repro75315913repro_
repros84216003repros
reran57329103_reran
rerun58722153_rerun
rewon86920583_rewon
roper75431913roper__
ropers84325903roper_s
ropery114313873roper_y
serin55434443_serin
sermon8413553_sermon
serow86720443_serow
seton55223543_seton
spean74620513spe_an
sperm93216023sper_m
sperms102512603sperms
spoon74719443sp_oon
spurn74815453spur_n
stern55319123ster_n
sterol6613333sterol
tenon53320513_tenon
tern46134803_ter_n
thereon10199263thereon
thoron94713903thoron
toper75231023toper__
topers85025323toper_s
torero6313203torero_
toreros7311343toreros
unperson1046383unperson
upfront1246973upfront
upgrow1234273upgrow
upgrown1343853upgrown
uphroe1136083uphroe
upon65817583up__on
upprop944093upprop
uptorn8268093uptorn
whereon13196503whereon
xenon122612453_xenon
xerox1138623_xerox
zero134822473_zero_
zeros144918113_zeros

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.376475242.0
2DLD Change Limit1127163265.45320670.5
3Display Results3263260.0933505.4
 (SQL Overall)1786913265.92230174.1
 
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.