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

494 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
nares5554415(None) 
ares45871021_ares
bares75457131bares
cares77369181cares
dares66146701dares
fares85852871fares
hares86255541hares
lares54852631lares
mares76457631mares
nabes75427091nabes
nacres85614451nacres
names74833361names
napes74828461napes
narcs76122021narcs
nards65928461nards
naris55735291naris
narks96026031narks
nates55238331nates
naves87030381naves
pares77164481pares
rares55247441rares
snares65329031snares
tares57456561tares
wares88250581wares
aces67645092_aces
acres76327762acres
ages55844592_ages
ales47067102_ales
anes45255932_anes
antes56334322antes
antres65021002antres
apes66047432_apes
apres75426402apres
arbs66834732_arbs
arcs67834782_arcs
are37874572_are_
area45843392_area
areas55935772_areas
arfs76029962_arfs
arks85936872_arks
arles56735742_arles
arms66137492_arms
ars37670932_ar_s
arse46539272_arse
arses55733872_arses
arts49650262_arts
ates45047922_ates
aures55137092aures
aves76142602_aves
awes76037552_awes
axes117337852_axes
ayes76543512_ayes
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
barbes104526232barbes
barbs95928192barbs
bardes95026932bardes
bards87139642bards
bare65460522bare_
bared85144482bared
barer74535802barer
barest85327692barest
barfs104826002barfs
barges94528252barges
barks115735812barks
barms96128462barms
barns76335142barns
barres84427542barres
bars66564092bar_s
baryes116218502baryes
bases75644352bases
bates75846342bates
blares85021632blares
bores76448252bores
braes75735052braes
byres104421382byres
cades85440732cades
cadres94017922cadres
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
carbs96031462carbs
cards85137932cards
care66968372care_
cared86050092cared
carer74942332carer
carers85133952carers
caress85720262caress
caret75360562caret
carets85330772carets
carex144822292carex
caries85147622caries
carks115534212carks
carles85435082carles
carls77037422carls
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762car_s
carse74934332carse
carses85233652carses
cartes86239472cartes
carts78946292carts
carves115128452carves
cases75048382cases
cates75951872cates
caves105639702caves
ceres75540012ceres
chares115631802chares
cires74932912cires
cores76361852cores
cures75645432cures
daces85030682daces
dales66439742dales
dames85435852dames
darbs85323262darbs
dare55848862dare_
dared75935012dared
darer65230792darer
darers75921872darers
darks106727872darks
darns66927892darns
darts67635732darts
dates65639152dates
dazes155024142dazes
dures65635922dures
eagres74014572eagres
eared65139502eared
earls56127512earls
earns55927562earns
ears46356592ear_s
eases56041612eases
eaves85231992eaves
enates64026422enates
enures63919712enures
eyres84921772eyres
faces106439432faces
fades94932862fades
fakes126032482fakes
fames105735922fames
fanes84639892fanes
farces115223322farces
fards96629842fards
fare76354462fare_
fared95842342fared
farer86733142farer
farers95924052farers
farles96025782farles
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
feres86038182feres
fires85740752fires
flares94521702flares
fores85847102fores
gaes56348032ga_es
gages74529972gages
gales65442482gales
games86238552games
gapes86030822gapes
garbs86321412garbs
gars55750742gar_s
gases65633992gases
gates65939502gates
gazes155425912gazes
glares75518862glares
gnarls74210772gnarls
gnarrs7407662gnarrs
gnars66718852gnar_s
gores65740372gores
gyres94820322gyres
hades96035112hades
haeres94017032haeres
haes77651022ha_es
hajes155420942hajes
hakes126034302hakes
hales85449842hales
hames106138702hames
hards96435652hards
hare76255732hare_
hared95742182hared
harem104924452harem
harems115513822harems
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
hates86742572hates
haves116034872haves
hazes174928322hazes
heres86245902heres
hires86134342hires
inanes62519802inanes
inarms8410092inarms
infares10313022infares
inures63318952inures
ires45639282_ires
jades135222112jades
jakes165023642jakes
janes124928122janes
japes146322822japes
jarls126120962jarls
jars117338352jar_s
kaes85734062ka_es
kales95730982kales
kames115024692kames
kanes95529372kanes
karns96624142karns
karts97630112karts
knars94416112knar_s
knaves13439522knaves
knawes13328392knawes
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lards65331862lards
laree56036292laree
larees65323112larees
larges74824232larges
laris54737462laris
larks95227812larks
lars46956572lar_s
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
lores55045402lores
lures56138532lures
lyres85019962lyres
mabes96331532mabes
maces97139962maces
madres93718182madres
maes66948392ma_es
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
maras75443282maras
marcs95726622marcs
mare64759322mare_
marges94525712marges
marks115933482marks
marls75535162marls
mars66261862mar_s
marse76231152marse
marses84827112marses
marts77442232marts
mates75251362mates
matres84522232matres
maxes145629532maxes
mazes165632172mazes
meres75143572meres
mires75640882mires
mores76249642mores
mures75937212mures
naans55815252naans
nabe66029492nabe_
nabis76020572nabis
nabs66236192na_bs
naches114622412naches
nacre75715362nacre_
nacred95212492nacred
nadas66320812nadas
nae35952742na_e_
naffs116213962naffs
nags55436022na_gs
naifs87617422naifs
nails55730402nails
nairas6312772nairas
nairus639142nairus
naives94914222naives
naked105320852naked
nalas55528362nalas
naled65525052naled
naleds7469132naleds
name65637412name_
named85223062named
namer75622102namer
namers84517332namers
nanas55928632nanas
nances83618642nances
nans46139392na_ns
naos47429732na_os
napas75924352napas
nape65230802nape_
nappes104515622nappes
naps66238582na_ps
narc67127952nar_c
narco76718242narco
narcos86714202narcos
nard56634452nar_d
naric76824172naric
nark85230062nar_k
narked114116742narked
narky126017802narky
nary76931222nar_y
natures7311962natures
nave75732312nave_
navel87016572navel
navels95712692navels
navies95218622navies
nays75931592na_ys
nazis145216082nazis
neared75119802neared
nearer64618892nearer
nearest73415842nearest
nears55529422near_s
nenes55329672nenes
nerds65719252nerds
nereis6315342nereis
nerts55924982nerts
nerves94216192nerves
neves87021872neves
nides65229132nides
nines55937342nines
nites55736342nites
nitres65519332nitres
nixes124519622nixes
nodes64633492nodes
noes45845392n_oes
nomes74933122nomes
nones55639132nones
noris54928272noris
norms76019302norms
noses55435642noses
notes55034582notes
nudes64723292nudes
nukes95418122nukes
nurds65518522nurds
nurls55519682nurls
nurse54420122nurse
nurses63919352nurses
oared65030652oared
oars46846032oar_s
oases55330982oases
oaves84925612oaves
ogres65818632ogres
ores46056682_ores
paces96741112paces
padres95016982padres
pages85235072pages
pales75753802pales
panes76148692panes
paras76143042paras
pards85634332pards
pare66760842pare_
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
parers85530742parers
pareu74928742pareu
pareus85420742pareus
parges94529542parges
paries84742512paries
paris75145942paris
parks116134462parks
parles86334392parles
parrs75928672parrs
pars67560792par_s
parse75236992parse
parses85534702parses
parts77743372parts
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
peres76246642peres
pores75849032pores
pyres105523882pyres
races74943242races
rages64539442rages
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rare45348432rare_
rared65738322rared
rarer54731702rarer
rarest65725482rarest
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
res35565042__res
sabes76437462sabes
sabres85520862sabres
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sards64736182sards
saree55044662saree
sarees65329942sarees
sarges75128592sarges
saris54544952saris
sarks96632462sarks
saros55238062saros
sates54949322sates
saves85838632saves
saxes125229342saxes
scares85033002scares
seres55448892seres
shares95236412shares
sires55945372sires
snakes103919602snakes
snare54429982snare_
snared74824552snared
snarer64620842snarer
snarers74216662snarers
snarfs95113422snarfs
snarks104815732snarks
snarls64016872snarls
snores64324312snores
sores55454282sores
spares84834552spares
stares66038752stares
tabes76033922tabes
taces76237802taces
tajes124920692tajes
takes94437792takes
tales55451372tales
tames75242012tames
tapes75838602tapes
tare45957622tare_
tared69340052tared
targes74524592targes
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tarres64723042tarres
tars46763952tar_s
tarts57242022tarts
tates55444982tates
taxes124730822taxes
tires55437492tires
tores55352672tores
tres46542902_tres
tyres84725232tyres
unarms839242unarms
urares64519092urares
vales85434262vales
vanes85130972vanes
varas86028192varas
varies94330872varies
vars75742072var_s
varus85921182varus
varves124414782varves
vases84626262vases
vires84529682vires
wades95634142wades
waes76048602wa_es
wages95330932wages
wakes126633652wakes
wales86142832wales
wames106432802wames
wanes85040882wanes
wards97734402wards
ware76254722ware_
wared96339872wared
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
waves115633922waves
waxes155825502waxes
wires86034912wires
yards95324612yards
yare75636942yare_
yarer84321572yarer
yarest95018912yarest
yarns85621792yarns
yores85031322yores
zaires1539702zaires
zarfs174713622zarfs
zaxes215113822zaxes

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 Filter178691538000.0931921408.6
2DLD Change Limit538004941.71631352.0
3Display Results4944940.1563166.7
 (SQL Overall)1786914941.96590936.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.