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

284 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
own6642970(None) 
awn68035911awn
down86427491down
gown85724071gown
lown76929291lown
mown95424441mown
on28057181o_n
ow58950171ow_
owe67041031owe
owl66228971owl
owns76819581owns
sown75127451sown
town76928701town
won66252061won
adown95611662adown
ain37579092ain
an211879072_an
aw512563402aw_
awa611939672awa
awe67746622awe
awl67635302awl
awns75324432awns
awny105919302awny
ban58366832ban
ben56554922ben
bin56658632bin
blown105716672blown
boon67142172boon
born67338412born
bow87051902bow_
bowl96827702bowl
bows96242862bows
brown105619532brown
bun56348142bun
can57760132can
clown105214732clown
coin66645352coin
con510268022con
conn66229132conn
coon67248942coon
corn69945812corn
cow89856712cow_
cowl97530812cowl
cows97046642cows
cowy126427362cowy
crown105620082crown
cwm106815082cwm
dan46859662dan
dawn85624202dawn
den47554342den
din46459462din
don46757652don
dow76749972dow_
downs94918572downs
downy125714552downy
dows85941052dows
drown95515822drown
dun46545582dun
en28052392_en
eon36052082eon
ern35738352ern
ewe66630982ewe
fan67158852fan
fawn105321952fawn
fen66851352fen
fin66458032fin
flown116213992flown
fohn106116552fohn
foin77231562foin
fon66352272fon
fowl105723632fowl
frown115415972frown
fun66841142fun
gan48060122gan
gen45950512gen
gin46055752gin
goon57236172goon
gowan95415742gowan
gowd96519982gowd
gowk125516472gowk
gowns95115102gowns
grown95317352grown
gun47240802gun
hen67555272hen
hewn106719852hewn
hin67559562hin
hon67759382hon
horn76735612horn
how97252432how_
howe106734102howe
howf136127202howf
howk145221962howk
howl107625692howl
hows106345602hows
hun65844712hun
hwan105716892hwan
in28150862_in
inn36727432inn
ion36051022ion
jin106443932jin
john145512902john
join116724832join
jow137639302jow_
jowl146120302jowl
jows146632092jows
jun105932062jun
ken76343982ken
kin76353962kin
known12568342known
koan85425032koan
lawn75925632lawn
lin37967372lin
loan47436452loan
loin46838722loin
loon47344792loon
lorn46435252lorn
low66051872low_
lowe75435312lowe
lows75843012lows
man57465852man
mawn94424132mawn
men59252842men
moan65832012moan
mon57561572mon
moon67140812moon
morn66237562morn
mow86650352mow_
mows96340832mows
mun56143852mun
nan37854872nan
noon47134622noon
noun45724182noun
now65950192now_
nows75738232nows
nowt78833752nowt
nun35537742nun
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127722obi
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
oh57447002o_h
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
oink85429342oink
oka76926802oka
oke75839482oke
old47033462old
ole37155212ole
om48553002o_m
omen66828182omen
oms56337512oms
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
open66427002open
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orb55736862orb
orc57034922orc
ore36661832ore
ors35750112ors
ort39465232ort
os211359882o_s
ose38147342ose
oud47439072oud
our36042892our
out38072152out
ova66823792ova
oven76624142oven
owed86833872owed
owes75137102owes
owing96222722owing
owls76022932owls
owned95113232owned
owner84613312owner
owse76321622owse
owsen84210192owsen
ox98242382o_x
oxen116218592oxen
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pan58466442pan
pawn94625302pawn
pen56558842pen
pin57066722pin
poon67341262poon
porn65636022porn
pow87147282pow_
pows95537662pows
pun58846512pun
ran38266612ran
rin36663182rin
roan47234202roan
row67453672row_
rowan85418732rowan
rowen84921152rowen
rows75941752rows
run36244982run
sawn75428162sawn
sen36058522sen
sewn76124332sewn
shown115216472shown
sin36265892sin
son37761952son
soon46240502soon
sorn46641062sorn
sow66554762sow_
sows75342492sows
sun37149032sun
swan76631312swan
syn67024122syn
tan37167562tan
ten35856112ten
tin36362172tin
ton310265102ton
toon47740632toon
torn46044252torn
tow610557362tow_
towns86018882towns
towny116114492towny
tows78545552tows
towy105325472towy
tun35845192tun
twa67721642twa
twin76023082twin
two67925832two
un28341132_un
urn35731462urn
van66246322van
vow96136312vow_
vows106626942vows
wan66761932wan
we57043452_we
wen66249602wen
win66456292win
wo510447762_wo
woe66651242woe
wog76242732wog
wok106334172wok
wonk116125302wonk
wons74942042wons
wont75842502wont
woo66949802woo
wop87145132wop
worn75631752worn
wos66953532wos
wot610467482wot
wow96643472wow
wows104633492wows
wyn95921442wyn
yawn106219092yawn
yen66847382yen
yin67648732yin
yon67348952yon
yow96945292yow_
yowe106728742yowe
yowl105820952yowl
yows106433122yows
zin125643772zin
zoon137326982zoon

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140842840.42333295.5
3Display Results2842840.0604733.3
 (SQL Overall)1786912840.546327272.9
 
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.