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

243 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
owns7681958(None) 
awns75324431awns
downs94918571downs
gowns95115101gowns
ons36148511o_ns
owes75137101owes
owls76022931owls
own66429701own_
towns86018881towns
wons74942041wons
ains46158882ains
awes76037552awes
awls75926092awls
awn68035912awn_
awny105919302awny
bans66555142bans
bens65945702bens
bins66548252bins
boons75031912boons
bowls106121432bowls
bows96242862bow_s
browns116415632browns
buns66243722buns
cans65050852cans
clowns114810112clowns
coins75834552coins
conns75024232conns
cons66057692cons
coons76737282coons
corns76034762corns
cowls106922212cowls
cows97046642cow_s
crowns115615112crowns
cwms11439572cwms
dans56748152dans
dawns95916592dawns
dens55945072dens
dins56652042dins
dons56048702dons
down86427492down_
downy125714552downy
dows85941052dow_s
drowns105612332drowns
duns55140432duns
ens37245922_ens
eons46638712eons
erns45428232erns
ewes76328702ewes
fans76247372fans
fawns115914262fawns
fens76139762fens
fins75849092fins
fohns117310782fohns
foins85523382foins
fons76943892fons
fowls115518892fowls
frowns126011392frowns
funs75235732funs
gens55740072gens
gins55543952gins
goons65326772goons
gowans105512292gowans
gowds105814042gowds
gowks136011952gowks
gown85724072gown_
guns55533482guns
hens75642572hens
hins76447992hins
hons77350782hons
horns86125332horns
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602how_s
huns76136932huns
inns46920932inns
ins35945602_ins
ions46737852ions
iwis77117012iwis
jins115635012jins
johns15398712johns
joins125818412joins
jowls156214522jowls
jows146632092jow_s
kens85435232kens
kins85747912kins
knowns13426442knowns
koans95818622koans
lawns85215422lawns
lens46146492lens
lins47059052lins
loans56026462loans
loins56728422loins
loons55731722loons
lowes85732462lowes
lown76929292lown_
lows75843012low_s
mans66354552mans
moans74624372moans
mons68152262mons
moons75331002moons
morns75527442morns
mown95424442mown_
mows96340832mow_s
muns65535922muns
nans46139402nans
noons54125282noons
nouns56717312nouns
nows75738232now_s
nowts86915862nowts
nuns45228232nuns
oafs76425262oafs
oaks86527902oaks
oars46846032oars
oats46554212oats
obas65730932obas
obes66036832obes
obis66226842obis
ocas66729632ocas
odas57230262odas
odds68919922odds
odes57243242odes
ods47546212o_ds
oes35866192o_es
offs107117012offs
ohms95514032ohms
ohs66232312o_hs
oils46337972oils
oink85429342oink
oinks94819912oinks
okas85225392okas
okes84936342okes
olds55926572olds
oles46453472oles
omens75618962omens
oms56337512o_ms
on28057182o_n_
one37050912o_ne
ones46146532ones
ono36838032o_no
onos46229002onos
onus45826812onus
oohs75220692oohs
oops65232672oops
oots46446442oots
opens76118552opens
opes65942612opes
ops56641252o_ps
opts68124742opts
opus66420592opus
orbs66626252orbs
orcs67025432orcs
ores46056682ores
ornis54616772ornis
ors35750112o_rs
orts46538332orts
os211359882o__s
oses46641512oses
ouds56430102ouds
ours47237562ours
outs45746962outs
ovens86217452ovens
ow58950172ow__
owe67041032ow_e
owed86833872owed
owing96222722owing
owl66228972ow_l
owned95113232owned
owner84613312owner
owners94210702owners
owse76321622owse
oxes116530722oxes
oyes74940132oyes
pans65855732pans
pawns108818132pawns
pens65649642pens
pins65558452pins
pons65850602pons
poons75430972poons
porns75527342porns
pows95537662pow_s
puns66641482puns
rins46153192rins
roans54926442roans
rowans95715342rowans
rowens94515302rowens
rows75941752row_s
runs46438082runs
sans45153362sans
sins46755272sins
sons46049552sons
sorns55028422sorns
sowans94215892sowans
sowens93613152sowens
sown75127452sown_
sows75342492sow_s
suns45841902suns
swans84625012swans
tans46154822tans
tens45647412tens
tins45251302tins
tons46553052tons
toons55027532toons
town76928702town_
towny116114492towny
tows78545552tow_s
tuns45138662tuns
twas76824082twas
twins85118982twins
twos76718022twos
uns35936762_uns
urns46323902urns
vans76236732vans
vows106626942vow_s
wans76452272wans
was68767562_was
wens76337932wens
wins75949172wins
wis66552332_wis
woes76440662woes
wogs86531402wogs
woks116224902woks
won66252062won_
wonk116125302wonk
wonks124818342wonks
wont75842502wont
wonts87621542wonts
woos76238802woos
wops96634152wops
wos66953532_wos
wots76342892wots
wows104633492wows
wyns105717032wyns
yawns114213272yawns
yens75832262yens
yins75335122yins
yowes114926372yowes
yowls115715432yowls
yows106433122yow_s
ywis105313102ywis
zins135735002zins
zoons144919692zoons

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.313570897.8
2DLD Change Limit298722430.79637527.6
3Display Results2432430.0633857.1
 (SQL Overall)1786912431.172152466.7
 
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.