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

192 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
maars7462163(None) 
haars85620471haars
maar66025061maar_
mairs76228301mairs
makars124612631makars
malars85020681malars
maras75443291maras
mars66261871m_ars
aahs716428562_aahs
aals49941142_aals
aas310975392_aa_s
afars85716512afars
agars66120642agars
airs46447422_airs
amahs107819062amahs
amas67746292ama_s
amass77119682amass
amirs75924922amirs
ars37670932__ars
baals76122702baals
baas66844672baa_s
bars66564092_bars
bazars174613112bazars
bears75739042bears
boars75229602boars
carrs75730852carrs
cars67364762_cars
chars105936642chars
czars164812912czars
damars93814992damars
dears65736882dears
ears46356592_ears
embars103812882embars
fairs85825442fairs
fears84829392fears
fiars86720832fiars
gars55750742_gars
gaurs66317992gaurs
gazars164811552gazars
gears64628692gears
gnars66718852gnars
guars65021052guars
haafs115711162haafs
haar77323492haar_
hairs86225172hairs
hears86737372hears
hoars85925552hoars
izars145112932izars
jars117338352_jars
kaas86531842kaa_s
kabars124513952kabars
kbars114612602kbars
knars94416112knars
kyars124813962kyars
laari54415712laari
lahars94013162lahars
lairs55425872lairs
lars46956572_lars
lazars153812392lazars
lears55938732lears
liars54723162liars
mabes96331532mabes
macaws1337022macaws
macers105321272macers
maces97139962maces
machs125722562machs
macks135127602macks
macro94718172macro
macros104017012macros
macs86742512m_acs
madams11310942madams
madras94316432madras
madre85720172madre
madres93718182madres
mads76845372m_ads
maes66948402m_aes
mages85036022mages
mags75444532m_ags
magus85318752magus
maids86327142maids
mails76037782mails
maims96321792maims
mains75635112mains
mair66133782mair_
majors154511092majors
makar115614972makar_
makers123921732makers
makes115336852makes
makos116518362makos
malar76424442malar_
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mamas95930772mamas
manas76240432manas
manats84623462manats
manes76648962manes
manors84420882manors
manos74933622manos
mans66354552m_ans
manus75924932manus
maps86141052m_aps
mar57965952m_ar_
mara67444572m_ara
marc87034632m_arc
marcs95726622marcs
mare64759332m_are
mares76457632mares
mark105138062m_ark
marks115933482marks
marl66341622m_arl
marls75535162marls
marry104821692marry
marse76231152m_arse
marsh105320852m_arsh
mart66865982m_art
marts77442232marts
mas58175822m_a_s
masas75630412masas
masers84623452masers
masks115320532masks
mass66044942m_ass
masts77035762masts
maters85032392maters
mates75251362mates
maths105624022maths
matres84522232matres
mats65460292m_ats
matts76829182matts
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
mavis105622722mavis
maws96437142m_aws
maxes145629532maxes
maxis145721562maxis
mayas105924382mayas
mayors115714192mayors
mayos105521932mayos
mays96940032m_ays
mazard1838762mazard
mazards1937702mazards
mazers173917092mazers
mazes165632172mazes
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
mirs66940572m_irs
moans74624372moans
moas65545342moa_s
moats75827642moats
molars85517322molars
moors74923142moors
moras76438782moras
mors65950062m_ors
muras75329582muras
murrs75521302murrs
mylars114310442mylars
naans55815252naans
navars92810572navars
nears55529422nears
oars46846032_oars
pairs75325832pairs
paras76143042paras
parrs75928672parrs
pars67560792_pars
pears75138612pears
radars71314672radars
rears54739652rears
roars55622242roars
scars75433532scars
sears54744912sears
smears84714432smears
soars54732512soars
spars75431542spars
stars55836572stars
tahrs85412332tahrs
talars66021682talars
tars46763952_tars
tatars64619792tatars
tears55436462tears
tsars56717112tsars
tzars144914272tzars
vairs85019132vairs
varas86028192varas
vars75742072_vars
wairs86424062wairs
wars78659802_wars
wears86030302wears
years84527672years

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.313570897.8
2DLD Change Limit538001921.43637465.2
3Display Results1921920.0633047.6
 (SQL Overall)1786911921.81298615.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.