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

317 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
marls7553516(None) 
carls77037421carls
earls56127511earls
farls85731111farls
harls85634501harls
jarls126120961jarls
mails76037781mails
malls76233431malls
maras75443291maras
marcs95726621marcs
mares76457631mares
marks115933481marks
marl66341621marl_
marly106925611marly
mars66261871mar_s
marts77442231marts
mauls76524951mauls
merls77423901merls
aals49941142_aals
ails45654712_ails
alls46740922_alls
als36663022_a_ls
amyls104512692amyls
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arils58732202_arils
arks85936872_arks
arles56735742_arles
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
aryls87015812_aryls
awls75926092_awls
baals76122702baals
bails75933522bails
balls76236412balls
bals66354042ba_ls
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
bawls105719322bawls
birls74023162birls
burls74228852burls
byrls105711232byrls
calls75634732calls
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carl65144782carl_
carle74535702carle
carles85435082carles
carns75937562carns
carols85124982carols
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
cauls75727772cauls
curls74927102curls
dahls95012282dahls
dals57145122da_ls
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dirls64720502dirls
earl45838142earl_
early85324122early
earns55927562earns
ears46356592ear_s
emails84412342emails
fails85631482fails
falls85727652falls
fards96629842fards
fares85852872fares
farl76338552farl_
farle86929242farle
farles96025782farles
farms106324952farms
faros85532022faros
farts88336842farts
furls85322052furls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
garbs86321412garbs
gars55750742gar_s
girls64518392girls
gnarls74210772gnarls
hails85231642hails
halls85633782halls
hards96435652hards
hares86255542hares
harks126333432harks
harl75740002harl_
harms106829012harms
harps105926872harps
harts88441592harts
hauls86123732hauls
herls85226432herls
hurls86522712hurls
jails125422942jails
jarl115828132jarl_
jars117338352jar_s
kails95525212kails
karns96624142karns
karts97630112karts
lalls55324132lalls
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
maars74621632maars
mabes96331532mabes
maces97139962maces
machs125722562machs
macks135127602macks
macle96127002macle
macles107023222macles
macros104017012macros
macs86742512ma_cs
madly115218132madly
madras94316432madras
madres93718182madres
mads76845372ma_ds
maes66948402ma_es
mages85036022mages
mags75444532ma_gs
magus85318752magus
maids86327142maids
mail65543452mail_
maile75232222maile
mailes84329112mailes
maill74420792maill
maills84215282maills
maims96321792maims
mains75635112mains
mairs76228302mairs
makes115336852makes
makos116518362makos
male66052302ma_le
males75049792males
mall64639372ma_ll
malm85129982ma_lm
malms95021552malms
malt66254812ma_lt
malts76331752malts
mamas95930772mamas
manas76240432manas
manes76648962manes
manly105022952manly
manos74933622manos
mans66354552ma_ns
manus75924932manus
maple95521142maple
maples104819422maples
maps86141052ma_ps
mar57965952mar__
mara67444572mar_a
marble104219102marble
marbles114516652marbles
marbly134111932marbly
marc87034632mar_c
marcels113212372marcels
march125622892march
mare64759332mar_e
marge85328332marge
marges94525712marges
maria75032882maria
marish114319052marish
mark105138062mar_k
marka114620792marka
markas124717002markas
marled95523162marled
marlin84220902marlin
marlins93420472marlins
marry104821692marry
marse76231152marse
marses84827112marses
marsh105320852marsh
mart66865982mar_t
marvels123810092marvels
marvy135014032marvy
mas58175822ma__s
masas75630412masas
masks115320532masks
mass66044942ma_ss
masts77035762masts
mates75251362mates
maths105624022maths
matres84522232matres
mats65460292ma_ts
matts76829182matts
mauds85519272mauds
maul64830722maul_
mauts75927192mauts
mavis105622722mavis
maws96437142ma_ws
maxes145629532maxes
maxis145721562maxis
mayas105924382mayas
mayos105521932mayos
mays96940032ma_ys
mazes165632172mazes
meals75933372meals
mells75031332mells
mels65941532m_els
mercs96020452mercs
meres75143572meres
merks114722402merks
merl65830972merl_
merle75824372merle
merles85322762merles
mewls105813232mewls
miauls8178712miauls
mills75435052mills
mils66045332m_ils
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
moils76125752moils
molls75129782molls
mols65948572m_ols
mools76027172mools
morals85324632morals
moras76438782moras
morels84820012morels
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
mulls75124152mulls
murals84016762murals
muras75329582muras
mures75937222mures
murks114821732murks
murrs75521302murrs
nails55730402nails
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
nurls55519682nurls
oars46846032oar_s
orals55826482orals
pails75833062pails
palls74332562palls
pals66951352pa_ls
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parle75836162parle
parles86334402parles
parols84722612parols
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawls105617662pawls
pearls84715392pearls
purls74723352purls
rails55937402rails
rares55247442rares
sails55738102sails
sals46851672sa_ls
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sauls55128122sauls
smalls84514122smalls
smarms105712532smarms
smarts86218002smarts
snarls64016872snarls
taels56822072taels
tails55634192tails
talls55133432talls
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
tirls54519802tirls
vails85825932vails
varas86028192varas
vars75742072var_s
varus85921182varus
virls85618602virls
wails86631482wails
walls85529382walls
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
wauls86120552wauls
wawls115416472wawls
yards95324612yards
yarns85621792yarns
yawls114613602yawls
zarfs174713622zarfs

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538003171.59333772.8
3Display Results3173170.0803962.5
 (SQL Overall)1786913171.98689975.3
 
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.