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

251 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
awls7592609(None) 
aals49941141aals
ails45654711ails
alls46740921alls
als36663021a_ls
awes76037551awes
awl67635301awl_
awns75324431awns
awols84713521awols
bawls105719321bawls
owls76022931owls
pawls105617661pawls
wawls115416471wawls
yawls114613601yawls
aahs716428562aahs
aal39058672aal_
aas310975392a_as
abas68642082abas
able66340532able
ables75935542ables
ably99725132ably
abos67734412abos
abs59356072a_bs
abys97221882abys
aces67645092aces
acts66929862acts
acyls104211522acyls
adds67622452adds
ados57633512ados
ads49755732a_ds
agas55938842agas
ages55844592ages
agly86821802agly
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846362aids
ail37171042ail_
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
al210674042a_l_
ala312463602a_la
alas46358122alas
alb57342652a_lb
albs68628572albs
ale36572342a_le
ales47067102ales
all36148232a_ll
ally76935642ally
alms65834922alms
alp56641132a_lp
alps65529242alps
also46423442a_lso
alt36467962a_lt
alts46639902alts
amas67746292amas
amis66445322amis
amps86230342amps
amus65529612amus
amyls104512692amyls
anas46649862anas
ands57833612ands
anes45255932anes
anils56326722anils
anis45746462anis
anlas55626932anlas
ants47243472ants
anus47131112anus
apes66047432apes
apos65433822apos
apps86319692apps
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arils58732202arils
arks85936872arks
arles56735742arles
arms66137492arms
ars37670932a_rs
arts49650262arts
aryls87015812aryls
as211083072a__s
asks85721212asks
asps65622092asps
ass37844062a_ss
ates45047922ates
atlas55821582atlas
auks85525262auks
auld54125362auld
aves76142602aves
avos77227012avos
aw512563402aw__
awa611939672aw_a
awash116613162awash
away108024222away
awe67746622aw_e
awed88436032awed
awee76336642awee
awless939262awless
awn68035912aw_n
awny105919302awny
awol75620672awol
awry107619682awry
axels126313632axels
axes117337852axes
axils127217502axils
axis116127912axis
axle116424602axle
axles125219472axles
ayes76543512ayes
ays67050292a_ys
baals76122702baals
bails75933522bails
balls76236412balls
bals66354042bals
bawds116115492bawds
bawl95326062bawl_
bels66142492bels
bowls106121432bowls
brawls115214332brawls
calls75634732calls
carls77037422carls
cauls75727772cauls
caws96036112caw_s
cels65534972cels
cols66553082cols
cowls106922212cowls
crawls114712082crawls
cwms11439572cwms
dahls95012282dahls
dals57145122dals
dawks135213492dawks
dawns95916592dawns
daws86638242daw_s
dawts97216122dawts
dels56745472dels
dols56943052dols
drawls105511392drawls
earls56127512earls
eels46536742eels
ells46431352ells
els37645722_els
ewes76328702ewes
fails85631482fails
falls85727652falls
farls85731112farls
fawns115914262fawns
fils75838692fils
fowls115518892fowls
galls64729322galls
gals57946502gals
gaols66717572gaols
gawks136811632gawks
gawps115911012gawps
gels56836102gels
guls55930852guls
hails85231642hails
halls85633782halls
harls85634502harls
hauls86123732hauls
hawks155415702hawks
haws106439442haw_s
hols76946292hols
howls116219222howls
ills47030422ills
iwis77117012iwis
jails125422942jails
jarls126120962jarls
jaws145027292jaw_s
jowls156214522jowls
kails95525212kails
lalls55324132lalls
lawns85215422lawns
laws76441682law_s
mails76037782mails
malls76233432malls
marls75535162marls
mauls76524952mauls
maws96437142maw_s
mels65941532mels
mewls105813232mewls
mils66045332mils
mols65948572mols
nails55730402nails
nils46132452nils
oils46337972oils
owes75137102owes
owl66228972owl_
owns76819582owns
pails75833062pails
palls74332562palls
pals66951352pals
pawl95123262pawl_
pawns108818132pawns
paws96038182paw_s
pols66044562pols
puls65437562puls
rails55937402rails
rawly115115832rawly
raws75238212raw_s
sails55738102sails
sals46851672sals
sauls55128122sauls
saws75839482saw_s
sels46345982sels
shawls125411972shawls
sols45448162sols
taels56822072taels
tails55634192tails
talls55133432talls
taws75641592taw_s
tels46841692tels
tils45739612tils
trawls94412392trawls
twas76824082twas
twos76718022twos
vails85825932vails
vaws105527322vaw_s
wabs97337232wabs
wads87343142wads
waes76048602waes
wags86140552wags
wails86631482wails
wale74546432wale
wales86142832wales
walk115625612walk
walks126218502walks
wall76236102wall
walls85529382walls
waly105830902waly
wans76452272wans
waps96642082waps
wars78659802wars
was68767562_was
wats77555882wats
wauls86120552wauls
wawl105321942wawl_
waws106834902waws
ways107737952ways
wis66552332_wis
wos66953532_wos
yawl104918972yawl_
yawns114213272yawns
yawps13628792yawps
yaws105531212yaw_s
yowls115715432yowls
ywis105313102ywis

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.266671770.7
2DLD Change Limit298722510.81036879.0
3Display Results2512510.0633984.1
 (SQL Overall)1786912511.139156884.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.