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

286 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
operons9141174(None) 
operon8811771operon_
aprons8316992ap_rons
herons94820542_herons
hyperons1649202hyperons
odeons739022ode_ons
onerous7312972onerous
opens76118552ope__ns
operand1038002operand
operands1146812operands
operant9317222operant
operants1039482operants
operas8312452oper_as
operose939432operose
options93810602options
peons75327182_pe_ons
pereons92815002_pereons
perrons93115482_perrons
persons93717012_persons
acerous9513333acerous
aeons57624653_ae_ons
ailerons849843ailerons
aleurons867003aleurons
apercus1136573apercus
aperies9423203aperies
apers76629133aper__s
apron7318833ap_ron_
apterous10410463apterous
barons85025383_barons
belons84119413_belons
betons84919553_betons
bicrons113410473bicrons
boleros9310293bolero_s
borons85520543_borons
ceros74726073_cero_s
cerous85821203_cerous
chaperons1646893chaperons
chevrons1665463chevrons
citrons92913223citrons
copatrons1346333copatrons
copens106119963cope__ns
copepods1544713copepods
copers104629843coper__s
crepons1139313crepons
dacrons103211033dacrons
daemons10269233daemons
demons94917723_demons
devons104512253_devons
diurons838823diurons
dopers95522483doper__s
ebons74316093__ebons
elevons1067573elevons
emerods10137653emerods
emperors1256123emperors
enterons8314153enterons
eons46638713__e_ons
epergne1046143epergne
epergnes1156713epergnes
epigons1048183epigons
erns45428223__er_ns
eros45238453__ero_s
exons125813343__exons
felons93615763_felons
ferns85220083_fer_ns
flaperons14125043flaperons
fleurons1155343fleurons
foreruns1146623foreruns
frons86124043__frons
garrons82713463garrons
girons75014373_girons
governs1136103gover_ns
guenons836563guenons
guerdons1044233guerdons
gyrons105511223_gyrons
hadrons113314303hadrons
herns84825583_her_ns
heroes94923823_heroes
heroins103518013_heroins
heron85025503_heron_
heros84930863_hero_s
hopers114222973hoper__s
hyperon1548183hyperon_
introns73515023introns
irons55324133__irons
jetons134512613_jetons
kerns94719563_ker_ns
ladrons83813193ladrons
lemons84415053_lemons
leprous938843leprous
leptons91910423leptons
longerons1045893longerons
lopers84424143loper__s
macrons113514893macrons
marrons93216973marrons
matrons93517633matrons
melons84117713_melons
merlons93311273_merlons
mesons83215843_mesons
microns113814783microns
mikrons13428413mikrons
moderns1037963moder_ns
monerans10310343monerans
monurons1037093monurons
moperies12313873moperies
mopers104220373moper__s
morons84919543_morons
natrons73215663natrons
neons55818683_ne_ons
nephrons1346853nephrons
nerols6914883_nerols
neurons7410443neurons
nonpersons1285503nonpersons
oceans81211003oce_ans
ocelots977233ocelots
ocherous1347013ocherous
ochrous1237943ochrous
octrois938333octrois
odeon6411483ode_on_
odorous837663odorous
offerors1443533offerors
olefins1037493olefins
oleins6313523ole_ins
oleos55419683ole_o_s
omens75618963ome__ns
omers76923193omer__s
omicrons1275193omicrons
omikrons1462963omikrons
onions64016433o_nions
open66427003ope__n_
openers9339493openers
opening1039923opening
openings1134803openings
opera7313573oper__a
operate9615733operate
operates10515413operates
operations12312953operations
operators11410753operators
opes65942613ope___s
opinions1045933opinions
oppress1135993oppress
oppugns1241933oppugns
opsins8411713op_sins
option83612713option_
orisons7310563orisons
orlons6411013o_rlons
outrows10311403outrows
outruns72911543outruns
ovens86217453ove__ns
overdoes121212543overdoes
overdogs13127493overdogs
overdone121210913overdone
overfond1537323overfond
overing111918053overing
overjoys2135183overjoys
overlong1238123overlong
overmans13310313overmans
overruns1138173overruns
overs85224793over__s
overtone111012573overtone
overtones121011853overtones
overtops1338513overtops
oyers87620883oyer__s
paeons83915523_paeons
pardons103817623_pardons
parols84722613_parols
parous84024163_parous
parsons93516873_parsons
partons94620513_partons
patrons93818103patrons
peans75437643_pe_ans
pecans101515833_pecans
pedros9312183_pedro_s
peens76428193_pe_ens
peins76128063_pe_ins
pekans121710553_pekans
pekins121812233_pekins
pekoes124410423_pekoes
pelon74423213_pelon_
pennons939713_pennons
pens65649643_pe__ns
peon65635243_pe_on_
peones83821043_pe_ones
peony105717563_pe_ony
peperoni1246273peperoni
peperonis1346623peperonis
pepos96620083_pepo_s
perdus93711273_perdus
pereions10310853_pereions
pereon83517453_pereon_
peres76246643_per_es
perigons11310083_perigons
perils84121853_perils
periods10312243_periods
peris75537073_per_is
perks115325803_per_ks
perms95524513_per_ms
pernod9310453_pernod
pernods1038483_pernods
peroxy1838243_peroxy
perps95521483_per_ps
perron83216623_perron_
perses85428063_perses
person83517873_person_
persona92812453_persona
personas102511883_personas
pervs105117373_per_vs
pesos77221623_peso_s
petrols92913083_petrols
petrous92714423_petrous
phons105221143_p_hons
pinons86019943_pinons
pions75826393_p_ions
pirns76020093_pir_ns
pitons85319043_pitons
pleons84213343_pleons
pogroms1237643pogroms
poisons9310353poisons
polarons1039863polarons
pompons1338553pompons
pons65850603_p__ons
pontons93315553pontons
poons75430973_p_oons
popcorns1444023popcorns
popedoms1545283popedoms
poperies12316793poperies
pornos85015253_pornos
porns75527343_por_ns
porous84419483_porous
potions93417423potions
preens85020113_preens
preops104911943_preops
prions84317783_prions
proas75028803_p_roas
prods85523553_p_rods
profs105120893_p_rofs
progs86624153_p_rogs
proms95426413_p_roms
prone75332623_p_rone
prong85218113_p_rong
prongs94314483_p_rongs
props95726883_p_rops
pros65742783_p_ro_s
pross76529403_p_ross
prows106327013_p_rows
pterins9812993pterins
purins83722653_purins
putons83515153_putons
pylons113011243_pylons
pyrans11411063_pyrans
pyrone112714473_pyrone
pyrones123113303_pyrones
pyros105718293_pyro_s
querns15307943quer_ns
recons84922993_recons
redons75222183_redons
repros84216003repro_s
reruns66413743_reruns
roperies10315763roperies
ropers84325903roper__s
serins64029673_serins
sermons9311783_sermons
serous65023563_serous
serows96016393_serows
setons64620173_setons
speans85417143spe_ans
spermous1247933spermous
sperms102512603sper_ms
spoons84116013sp_oons
spurns84811383spur_ns
sterns64616763ster_ns
sterols7313443sterols
tenons62916603_tenons
terns55226873_ter_ns
thorons104511913thorons
topcross1253383topcross
topers85025323toper__s
toreros7311343torero_s
unpersons1146853unpersons
upfront1246973upfront
upgrows1334323upgrows
uphroes1236303uphroes
upprops1044223upprops
viperous1347613viperous
xenons132710483_xenons
zeroes154314343_zeroes
zeros144918113_zero_s

Search took 8 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.1561145455.1
2DLD Change Limit1340272867.17018692.7
3Display Results2862860.0933075.3
 (SQL Overall)1786912867.41924085.6
 
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.