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 “onos” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

290 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
onos4622900(None) 
monos75930861monos
nos38859321_nos
ones46146531ones
ono36838031ono_
ons36148511on_s
onus45826811onus
abos67734412abos
ados57633512ados
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
anoa45634472anoa
anoas57226492anoas
anon46134852anon
ants47243472ants
anus47131112anus
apos65433822apos
avos77227012avos
bios66335322bios
bohos105618252bohos
bolos75531372bolos
bonds86126842bonds
bones76446532bones
bongos95316652bongos
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boons75031912boons
boos67955032boos
bos57966812_bos
boyos105418282boyos
bozos165216862bozos
bros65635662bros
cocos95624692cocos
cohos105921852cohos
condos94322332condos
cones76457422cones
congos94219882congos
conks115525702conks
conns75024232conns
cons66057692con_s
contos84923232contos
conus76726532conus
coons76737282coons
coos67456492coos
cos510270392_cos
dinos65428062dinos
dodos75819392dodos
dojos135111792dojos
donas65926472donas
dongs76525812dongs
donor64418192donor
donors75115792donors
dons56048702don_s
dos48062312_dos
duos56728132duos
egos55821652egos
ends56528522ends
engs56121392engs
enol45823822enol
enols54718402enols
enow77819872enow
enows85115492enows
ens37245922en_s
eons46638712eon_s
epos66723732epos
eros45238452eros
fanos85926502fanos
finos86226952finos
fonds95824822fonds
fons76943892fon_s
fonts86124752fonts
gnus56518002gnus
gobos86219372gobos
gogos77516522gogos
gongs74921612gongs
gonof95218652gonof
gonofs10459862gonofs
goons65326772goons
goos57644912goos
gos47155132_gos
hobos106321352hobos
homos105921782homos
hones88144492hones
hongs95126202hongs
honks125124522honks
honor85718622honor
honors94816792honors
hons77350782hon_s
hos68364192_hos
infos84311672infos
inks86926502inks
inns46920932inns
ins35945602in_s
ions46737852ion_s
jones125028182jones
kenos95220622kenos
kinos96626142kinos
knob107417012knob
knobs11519712knobs
knop107116592knop
knops115911812knops
knosp11576822knosp
knot85630502knot
knots95614722knots
know116115842know
knows124912412knows
kobos115616892kobos
kolos94921212kolos
konks84917112konks
kos76944822_kos
kotos95717692kotos
lenos56024862lenos
linos55631502linos
lobos75921842lobos
locos75822602locos
logos67225332logos
longs65527062longs
loons55731722loons
loos49051122loos
lotos54724632lotos
manos74933612manos
mhos95517772mhos
mojos145314462mojos
monas74732152monas
mondos95217332mondos
mongos94318622mongos
monks116123392monks
mono66036712mono_
mons68152252mon_s
moons75331002moons
moos66051302moos
mos57067122_mos
mozos165516332mozos
naos47429732naos
no29353242_no_
nob58954422_nob
nobs66436902nobs
nod47549562_nod
nods55838222nods
noes45845392noes
nog46847312_nog
nogs56534612nogs
noh66640642_noh
nolos54423352nolos
nom510450642_nom
nomos75919742nomos
noms65636402noms
nonas55126652nonas
nones55639132nones
noo37154042_noo
nook85728492nook
nooks95420392nooks
noon47134622noon
noons54125282noons
noose55624062noose
nor38048822_nor
nose46739362_nose
nosh76223542_nosh
nosy76322892_nosy
not39474662_not
nous46136982nous
now65950192_now
nows75738232nows
nus37939392_nus
oafs76425262oafs
oaks86527902oaks
oars46846032oars
oats46554212oats
obas65730932obas
obes66036832obes
obis66226842obis
oboe66822942oboe
oboes75717712oboes
obol65220612obol
obols73715862obols
ocas66729632ocas
odas57230262odas
odds68919922odds
odes57243242odes
odor55718092odor
odors64514272odors
ods47546212o_ds
oes35866192o_es
offs107117012offs
ohms95514032ohms
oho66534382oho_
ohs66232312o_hs
oils46337972oils
oinks94819912oinks
okas85225392okas
okes84936342okes
olds55926572olds
oleos55419682oleos
oles46453472oles
olios54520852olios
oms56337512o_ms
on28057182on__
once65423082once
one37050912on_e
onion54320972onion
onions64016432onions
only75319722only
onto46127662onto
onyx1478362onyx
ooh67637092o_oh
oohs75220692oohs
oops65232672oops
oot311274692o_ot
oots46446442oots
opes65942612opes
ops56641252o_ps
opts68124742opts
opus66420592opus
orbs66626252orbs
orcs67025432orcs
ordos65216202ordos
ores46056682ores
ornis54616772ornis
ors35750112o_rs
orts46538332orts
orzos143311252orzos
os211359882__os
oses46641512oses
ottos54714322ottos
ouds56430102ouds
ours47237562ours
outs45746962outs
ouzos143210412ouzos
owes75137102owes
owls76022932owls
owns76819582owns
oxes116530722oxes
oxo107322962oxo_
oyes74940132oyes
phonos114114792phonos
polos76129912polos
pomos95321582pomos
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
poons75430972poons
poos65949112poos
pornos85015252pornos
pros65742782pros
rhos76319062rhos
rondos74616722rondos
rotos56027882rotos
snob65825592snob
snobs74716152snobs
snog55623632snog
snogs66017492snogs
snot44745442snot
snots55225102snots
snow76324792snow
snows84719882snows
solos54830792solos
sones55444142sones
songs67725552songs
sons46049552son_s
sos37761602_sos
taos45541002taos
tondos75115912tondos
tones56048662tones
tongs65928462tongs
tons46553052ton_s
tonus56324302tonus
toons55027532toons
topos75726392topos
toros54336192toros
toyos87519142toyos
twos76718022twos
udos56619902udos
uncos74117032uncos
uns35936752un_s
vinos84723072vinos
winos84625042winos
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
woos76238802woos
wos66953532_wos
yonis85020822yonis
zones145528042zones
zonks184815172zonks
zoons144919692zoons
zoos135828802zoos

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298722900.95331345.2
3Display Results2902900.0634603.2
 (SQL Overall)1786912901.079165608.0
 
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.