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

278 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
awns7532443(None) 
ains46158881ains
awes76037551awes
awls75926091awls
awn68035911awn_
awny105919301awny
dawns95916591dawns
fawns115914261fawns
lawns85215421lawns
owns76819581owns
pawns108818131pawns
wans76452261wans
yawns114213271yawns
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abos67734412abos
abs59356072a_bs
abys97221882abys
aces67645092aces
acne66625872acne
acnes75922622acnes
acts66929862acts
adds67622452adds
ados57633512ados
ads49755732a_ds
aeons57624652aeons
agas55938842agas
ages55844592ages
agons66423782agons
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ain37579092ain_
airns55521032airns
airs46447422airs
ais39083572a_is
aits46355532aits
alans55636172alans
alas46358122alas
albs68628572albs
ales47067102ales
alls46740922alls
alms65834922alms
alps65529242alps
als36663022a_ls
alts46639902alts
amas67746292amas
amens75624842amens
amins75534312amins
amis66445312amis
amps86230342amps
amus65529612amus
an211879072a_n_
ana39559822a_na
anas46649862anas
and47244162a_nd
ands57833612ands
ane37866942a_ne
anes45255932anes
ani37751172a_ni
anis45746462anis
anna45529012anna
annas55824882annas
ansa45927772a_nsa
ant37270782a_nt
ants47243472ants
anus47131112anus
any68440482a_ny
apes66047432apes
apos65433822apos
apps86319692apps
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
ars37670932a_rs
arts49650262arts
as211083072a__s
asks85721212asks
asps65622092asps
ass37844062a_ss
ates45047922ates
auks85525262auks
aunt46553652aunt
aunts55227632aunts
avens86419332avens
aves76142602aves
avos77227012avos
aw512563402aw__
awa611939672aw_a
awash116613162awash
away108024222away
awe67746622aw_e
awed88436032awed
awee76336642awee
awing96827322awing
awl67635302aw_l
awned96615952awned
awol75620672awol
awols84713522awols
awry107619682awry
axes117337852axes
axis116127912axis
axons125517932axons
ayes76543512ayes
ayins85321612ayins
ays67050292a_ys
azans146516882azans
azons146518252azons
banns75321232banns
bans66555132bans
barns76335142barns
bawds116115492bawds
bawls105719322bawls
bens65945702bens
bins66548242bins
brawns115614082brawns
buns66243722buns
cains75334302cains
cans65050842cans
carns75937562carns
caws96036102caw_s
cons66057692cons
cwms11439572cwms
damns84916922damns
dans56748142dans
darns66927892darns
dawks135213492dawks
dawn85624202dawn_
daws86638242daw_s
dawts97216122dawts
dens55945072dens
dins56652042dins
dons56048702dons
downs94918572downs
duns55140432duns
earns55927562earns
ens37245922_ens
eons46638712eons
erns45428222erns
ewes76328702ewes
fans76247362fans
fauns84516752fauns
fawn105321952fawn_
fawny144711712fawny
fens76139762fens
fins75849092fins
fons76943892fons
funs75235732funs
gains65729512gains
gawks136811632gawks
gawps115911012gawps
gens55740072gens
gins55543952gins
gowns95115102gowns
guns55533482guns
hawks155415702hawks
haws106439442haw_s
hens75642572hens
hins76447992hins
hons77350782hons
huns76136932huns
inns46920932inns
ins35945602_ins
ions46737852ions
iwis77117002iwis
jawans1657842jawans
jaws145027292jaw_s
jins115635012jins
kains96125642kains
kaons95014852kaons
karns96624142karns
kens85435232kens
kins85747902kins
lawn75925632lawn_
lawny115912012lawny
laws76441682law_s
lens46146492lens
lins47059052lins
mains75635092mains
mans66354532mans
mawn94424132mawn_
maws96437132maw_s
mons68152252mons
muns65535912muns
naans55815252naans
nans46139392nans
nuns45228232nuns
ons36148512_ons
owes75137102owes
owls76022932owls
own66429702own_
pains75138282pains
pans65855722pans
pawls105617662pawls
pawn94625302pawn_
paws96038182paw_s
pens65649642pens
pins65558452pins
pons65850602pons
prawns11509022prawns
puns66641482puns
rains55140232rains
rawins95617622rawins
raws75238212raw_s
rins46153192rins
runs46438072runs
sains55639972sains
sans45153352sans
sawn75428162sawn_
saws75839482saw_s
sins46755272sins
sons46049552sons
spawns11577922spawns
suns45841902suns
swans84625012swans
tains54936322tains
tans46154812tans
tarns56433952tarns
tawny114713652tawny
taws75641592taw_s
tens45647412tens
tins45251302tins
tons46553052tons
towns86018882towns
tuns45138662tuns
twas76824082twas
twins85118982twins
twos76718022twos
uns35936752_uns
urns46323892urns
vans76236722vans
vaws105527322vaw_s
wabs97337232wabs
wads87343142wads
waes76048602waes
wags86140552wags
wains86930862wains
wan66761932wan_
wand85833872wand
wands96425482wands
wane76344712wane
wanes85040882wanes
wank115632502wank
wanks126124482wanks
want76156162want
wants87932212wants
wany106432352wany
waps96642082waps
warns87231002warns
wars78659802wars
was68767562_was
wats77555882wats
wawls115416472wawls
waws106834902waws
ways107737952ways
wens76337932wens
wins75949172wins
wis66552332_wis
wons74942042wons
wos66953532_wos
wyns105717032wyns
yarns85621792yarns
yawls114613602yawls
yawn106219092yawn_
yawps13628792yawps
yaws105531212yaw_s
yens75832262yens
yins75335122yins
ywis105313102ywis
zins135735002zins

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.0802233637.5
2DLD Change Limit298722781.15625840.8
3Display Results2782780.0604633.3
 (SQL Overall)1786912781.296137878.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.