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

260 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
oniony936970(None) 
onion54320971onion_
onions64016431onions
anion55028812anion_
anions64123032anions
briony1149042briony
gonion73612832gonion_
incony1139082incony
inion54620182inion_
inions64417002inions
ninny84514932_ninny
ronion63315642ronion_
ronions73313342ronions
union54519792union_
unions64216752unions
agony96415653_agony
alimony1236013alimony
amnion84812053amnion_
amnions93710913amnions
ancon75718233ancon_
ancone83916953ancone
anionic9312873anionic
annona648873annona
annoy869713anno_y
anoint6423633anoint
anomy105113393an_omy
anon46134853an_on_
anonym1136383an_onym
antimony1358303antimony
antonym1246513antonym
anyon85615223anyon_
anyone94612733anyone
anyons94513503anyons
astony9510523astony
atony87218853_atony
avion84218343avion_
avions94114393avions
axion1211316913axion_
axions134713483axions
barony115915303barony
betony114211583betony
biont7727163_biont
bonbon10310073bonbon_
bonbons1139333bonbons
boning94223293boni_ng
bonny105816623bon__ny
bony96732083__bony
briny104719663bri_ny
bryony1435833bryony
bunion83111313bunion_
bunions92210473bunions
cairny11557823cairny
cion613330913_cion_
cions75222853_cions
colony115417273colony
compony1613011913compony
condone102616293condone
coniine9316803coniine
conin76232723coni_n_
conine84528553coni_ne
coning94331823coni_ng
conins84327233coni_ns
convoy14348543convo_y
cony96537833__cony
cottony1237253cottony
crony105918673_crony
djinny1732873djinny
donjon1436463donjon_
donjons1536733donjons
ebony104511513_ebony
enjoy1545963enjo_y
envoy1156723envo_y
eobiont959943eobiont
eonian6311833eonian_
fanion94514323fanion_
fanions103713073fanions
felony123710323felony
finny114716753_finny
ginny95314573_ginny
gobony1236913gobony
goony95519783_goony
hinny115616673_hinny
hominy144511483homi_ny
honing103421503honi_ng
idiocy1273463idiocy
intone61115433intone
ion36051023__ion_
ionone6313443ion_one
ions46737853__ions
irony85015903_irony
lemony11419553lemony
lineny94011443lineny
liny78141323_li_ny
lion46334443_lion_
lions55923213_lions
logion76013723logion_
logions86211293logions
loony86918963_loony
lotion65716523lotion_
lotions74614763lotions
meiny104015413mei_ny
minion83416243minion_
minions93314623minions
minny104518663_minny
monitory1347853monitory
monody1238243mon_ody
monotony1347073monotony
mony96830013__mony
moony104818273_moony
morion86217733morion_
morions94014643morions
motion85217553motion_
motions94215003motions
nanny84813813_nanny
neon47026423_neon_
neons55818683_neons
nifty115211633_nifty
nine45842173_ni_ne
ninon55517383_ninon
ninons64913773_ninons
nippy124911113_nippy
niton55418283_niton_
nitons64614903_nitons
nitty85418313_nitty
nixy145714513_ni_xy
nobody1235743nobody
noily86120993noi_ly
noisy86813363noi_sy
nona46929063_n_ona
nonbody1344823nonbody
none45743173_n_one
nonionic1049233nonionic
noniron738373noniron_
nonmoney1346273nonmoney
nonoily1049543nonoily
nonyl849773_n_onyl
nooky124814813_nooky
noon47134623_noon_
noons54125283_noons
nosy76322893_n_osy
notion64516583notion_
notions74014483notions
oblong935383oblong
ochone11311293ochone
odeon6411483odeon_
odeons739023odeons
odious749933odious
ohing96018813ohi_ng
oily77932253o_i_ly
oink85429343o_i_nk
olio46829673olio__
olios54520853olio_s
ology94113113o_logy
onery8414123on_ery
ongoing938793ongoing
onium73115533oni_um
onlay84212943on_lay
online6315843online
onload7268633onload
only75319723on__ly
ono36838033on_o__
onos46229003on_o_s
onto46127663onto__
ontogeny1244793ontogeny
oogeny10117923oogeny
oology103210253oology
oolong738073oolong
oozy167018133o__ozy
opine77422463opi_ne
oping86322413opi_ng
opinion946793opinion_
opinions1045933opinions
opioid9310083opioid
option83612713option_
options93810603options
orgone71110913orgone
orient6322533orient
oriole6814293oriole
orison6411663orison_
orisons7310563orisons
orlon5415003orlon_
orlons6411013orlons
ostomy1137833ostomy
otiose639403otiose
ovine86316643ovi_ne
owing96222723owi_ng
owning104110333owni_ng
ozone14310613o_zone
peony105717563_peony
phony136715443_phony
pinion83815893pinion_
pinions93413603pinions
pinny105222063_pinny
pinon76024533pinon_
pinons86019943pinons
piny911838353_pi_ny
pion67235293_pion_
pions75826393_pions
ponton83217643ponton_
pontons93315553pontons
pony96434053__pony
potion84519573potion_
potions93417423potions
prion75119993prion_
prions84317783prions
priory114110263priory
rainy85921083rai_ny
ronyon9309133ronyon_
ronyons10258433ronyons
rosiny94414533rosi_ny
saxony1636233saxony
scion72214993scion_
scions82612243scions
shinny124810783shinny
shiny115122143shi_ny
simony1137903simony
skinny13456613skinny
sniffy15337193sniffy
snippy1374843snippy
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
snowy115011563sn_owy
solion6616383solion_
solions7513753solions
sonny85016103son__ny
spinny114510183spinny
spiny104921303spi_ny
spoony114111793spoony
stony85818643_stony
swoony12408263swoony
syntony1344523syntony
thionyl1343713thionyl
tinny85317653_tinny
tiny76134633_ti_ny
toning74025793toni_ng
tony75635153__tony
twiny116012813twi_ny
uncoy104111413unco_y
undone7914253undone
unfond10149113unfond
unholy1238163unholy
unibody1343353unibody
unify113611113uni_fy
unison649033unison_
unisons748423unisons
unity84918493uni_ty
unsoncy1245513unsoncy
unsonsy1045023unsonsy
unwon84512343unwon_
veiny115414363vei_ny
viny106025953_vi_ny
wanion93213063wanion_
wanions104011373wanions
whinny15587493whinny
whiny144915573whi_ny
winy107034323_wi_ny
wonton93410963wonton_
wontons103310533wontons
zoning162914333zoni_ng

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.373479064.3
2DLD Change Limit1127162605.30021267.2
3Display Results2602600.0763421.1
 (SQL Overall)1786912605.74931082.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.